gstrohmann
|
| Posted: 01/08/2004, 1:18 PM |
|
Hi
Does anyone know how to block a record in a MS Access database, when another user is already updating it !
I use MS Access via MS Jet driver and ASP language and for the moment there is no lock when several users want to change the same Access record (fine ... except that only one user get his record updated !)
I hope MS Jet/ Access handle properly this case ... (with a return code in order to display a message like ... record already in use by another user ... try again later !). Thx for your help
|
|
|
 |
Edd
Posts: 547
|
| Posted: 01/08/2004, 1:45 PM |
|
MS Access is NOT a multiuser database. If you have a locking problem and you are running Access 2000 and above SERIUOSLY consider changing the database to MSSQL personal edition (no Cost). Microsoft are not investing any resources in MDB files anymore - you will have to go to MS SQL.
Alternatively, investigate MySQL, no where as powerfull or feature rich as MSSQL but you can use MS Access to front end it fow windows and Reporting.
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
 |
|
Tom Jones
|
| Posted: 08/17/2004, 7:30 AM |
|
Edd that is not true. MS Access can be used as a multi user database. You would have to change it though the advanced options or code it if you are using ODBC. I don't know the details but do a web search on google and you will find the detail steps to implement the database as a multiuser one.
|
|
|
|
Oper
Posts: 1195
|
| Posted: 08/17/2004, 11:40 AM |
|
That not only a MDB problem, and BTW MDB 2003 is out there and is real goo.
Will happend with MSSQL or any database, last updater will update the record.
you will have to check at the moment of submiting your record if the record was changed and display and error or somthing.
Codechar free record and database every page load.
note: you could use a Filed Name LastDateUpdated to compare.
MDB still has few advantage over MSSQL only if you going to use 255+ user at the same time and your database is bigger that 1GB register you shoudl change asap.
MDB still one of the best Database for Small/Medium Project.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
|
