|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 1st, 2009, 11:09 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Exclusive Lock
I set the default open mode to Exclusive. What I expected is that if a user
had the database open another user couldn't access the database. However that is not what is happening. Other users can access the database. What am I doing wrong? Access 2002 -- Matt Campbell mattc (at) saunatec [dot] com Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200906/1 
|
|
#2
June 2nd, 2009, 12:15 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Exclusive Lock
mattc66,
The 'Open Exclusive' e\functionality is not a property of the database, it is a property of the Access session. If I recall the only way to do this is to open Access and then navigate to the database. Perhaps if you explained why you only want one user at a time to access your database someone can offer a solution. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "mattc66 via AccessMonster.com" u16013@uwe wrote in message news:96f7fe0b7c536@uwe... I set the default open mode to Exclusive. What I expected is that if a user had the database open another user couldn't access the database. However that is not what is happening. Other users can access the database. What am I doing wrong? Access 2002 -- Matt Campbell mattc (at) saunatec [dot] com Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200906/1
|
|
#3
June 2nd, 2009, 12:25 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Exclusive Lock
This is a database that is used to download data from an external source. If
more that one user try's to run the download at the same time they end up deleting what the first user started. Gina Whipp wrote: mattc66, The 'Open Exclusive' e\functionality is not a property of the database, it is a property of the Access session. If I recall the only way to do this is to open Access and then navigate to the database. Perhaps if you explained why you only want one user at a time to access your database someone can offer a solution. I set the default open mode to Exclusive. What I expected is that if a user had the database open another user couldn't access the database. However that is not what is happening. Other users can access the database. What am I doing wrong? Access 2002 -- Matt Campbell mattc (at) saunatec [dot] com Message posted via http://www.accessmonster.com
|
|
#4
June 2nd, 2009, 12:58 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Exclusive Lock
mattc66,
Depending on how you are downloading it you might want a message to appear that informs the other user that new data is being downloaded. Just thinking here.... 1. User opens database and starts download 2. A message gets posted to a Temp table (Download Started...) This message would appear on the form in a bound test box. 3. Once the download is complete a new message (Download Complete...) 4. You might even consider a time date stamp that way no need to redownload recently imported data. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "mattc66 via AccessMonster.com" u16013@uwe wrote in message news:96f8a6fc72165@uwe... This is a database that is used to download data from an external source. If more that one user try's to run the download at the same time they end up deleting what the first user started. Gina Whipp wrote: mattc66, The 'Open Exclusive' e\functionality is not a property of the database, it is a property of the Access session. If I recall the only way to do this is to open Access and then navigate to the database. Perhaps if you explained why you only want one user at a time to access your database someone can offer a solution. I set the default open mode to Exclusive. What I expected is that if a user had the database open another user couldn't access the database. However that is not what is happening. Other users can access the database. What am I doing wrong? Access 2002 -- Matt Campbell mattc (at) saunatec [dot] com Message posted via http://www.accessmonster.com
|
|
#5
June 2nd, 2009, 01:08 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Exclusive Lock
Oops, forgot... on exit of the database you will want to dump the message OR
replace with 'Last Download on Date at Time...' -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Gina Whipp" wrote in message ... mattc66, Depending on how you are downloading it you might want a message to appear that informs the other user that new data is being downloaded. Just thinking here.... 1. User opens database and starts download 2. A message gets posted to a Temp table (Download Started...) This message would appear on the form in a bound test box. 3. Once the download is complete a new message (Download Complete...) 4. You might even consider a time date stamp that way no need to redownload recently imported data. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "mattc66 via AccessMonster.com" u16013@uwe wrote in message news:96f8a6fc72165@uwe... This is a database that is used to download data from an external source. If more that one user try's to run the download at the same time they end up deleting what the first user started. Gina Whipp wrote: mattc66, The 'Open Exclusive' e\functionality is not a property of the database, it is a property of the Access session. If I recall the only way to do this is to open Access and then navigate to the database. Perhaps if you explained why you only want one user at a time to access your database someone can offer a solution. I set the default open mode to Exclusive. What I expected is that if a user had the database open another user couldn't access the database. However that is not what is happening. Other users can access the database. What am I doing wrong? Access 2002 -- Matt Campbell mattc (at) saunatec [dot] com Message posted via http://www.accessmonster.com
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
