Thread View: borland.public.cppbuilder.database.ado
5 messages
5 total messages
Started by Mario Sernicola
Sun, 25 Nov 2007 19:00
Using Access database in a network with ADO
Author: Mario Sernicola
Date: Sun, 25 Nov 2007 19:00
Date: Sun, 25 Nov 2007 19:00
18 lines
1464 bytes
1464 bytes
Hi, I wrote an ADO application that use a MS Access database. I'd like to use it in a LAN where there are 2-3 computers on which run my application that use the same database. I've seen that when one of this application write on db, the others applications don't see any modification of data. My goal is that all applications must have the same view on db at the same time. I use a TAdoConnection component that is connected with database and TAdoTable and TAdoQuery components that are connected with AdoConnection. How can solve this? Thanks Mario Sernicola
Re: Using Access database in a network with ADO
Author: Mark Richards
Date: Tue, 27 Nov 2007 09:32
Date: Tue, 27 Nov 2007 09:32
23 lines
1961 bytes
1961 bytes
I may be wrong, but you may have to force a refresh peridoically, this may even need to be a close / open of the dataset if it is to pick up changes by other users. It really isn't suitable for multi-user work in my opinion! "Mario Sernicola" <mariosernicola@libero.nospam.it> wrote in message news:4749c64f$1@newsgroups.borland.com... > Hi, > > I wrote an ADO application that use a MS Access database. I'd like to use > it in a LAN where there are 2-3 computers on which run my application that > use the same database. > > I've seen that when one of this application write on db, the others > applications don't see any modification of data. My goal is that all > applications must have the same view on db at the same time. > > I use a TAdoConnection component that is connected with database and > TAdoTable and TAdoQuery components that are connected with AdoConnection. > > How can solve this? > > Thanks > > Mario Sernicola
Re: Using Access database in a network with ADO
Author: Mario Sernicola
Date: Tue, 27 Nov 2007 22:55
Date: Tue, 27 Nov 2007 22:55
33 lines
2233 bytes
2233 bytes
Is there a solution in order to work in multi-user mode? I think is a problem due to the cache of the TAdoTable and TAdoQuery components. Mario Sernicola Mark Richards wrote: > I may be wrong, but you may have to force a refresh peridoically, this may > even need to be a close / open of the dataset if it is to pick up changes by > other users. It really isn't suitable for multi-user work in my opinion! > "Mario Sernicola" <mariosernicola@libero.nospam.it> wrote in message > news:4749c64f$1@newsgroups.borland.com... >> Hi, >> >> I wrote an ADO application that use a MS Access database. I'd like to use >> it in a LAN where there are 2-3 computers on which run my application that >> use the same database. >> >> I've seen that when one of this application write on db, the others >> applications don't see any modification of data. My goal is that all >> applications must have the same view on db at the same time. >> >> I use a TAdoConnection component that is connected with database and >> TAdoTable and TAdoQuery components that are connected with AdoConnection. >> >> How can solve this? >> >> Thanks >> >> Mario Sernicola > >
Re: Using Access database in a network with ADO
Author: Mark Richards
Date: Wed, 28 Nov 2007 10:42
Date: Wed, 28 Nov 2007 10:42
11 lines
1664 bytes
1664 bytes
One method is to set up a timer to peridoically flush any changes, close the connection and then open it again. A second method, and one which I use myself is every time a user selects to do a new task in your application, for example if they change to a secondary screen, or select an option from a menu, then the first cause of action could be to flush any buffers, close the database connection, open it and then launch the action the user has selected. This would ensure the changes up to that point made by other users are displayed or calculated correctly. hope that helps
Re: Using Access database in a network with ADO
Author: Mario Sernicola
Date: Thu, 29 Nov 2007 07:44
Date: Thu, 29 Nov 2007 07:44
18 lines
1812 bytes
1812 bytes
How can I do in order to "flush any buffers, close the database connection, open it"? Which are the methods? Mark Richards wrote: > One method is to set up a timer to peridoically flush any changes, close the > connection and then open it again. > > A second method, and one which I use myself is every time a user selects to > do a new task in your application, for example if they change to a secondary > screen, or select an option from a menu, then the first cause of action > could be to flush any buffers, close the database connection, open it and > then launch the action the user has selected. This would ensure the changes > up to that point made by other users are displayed or calculated correctly. > > hope that helps > >
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads