Dear all !
I have not any Server for using SQL Server, so i must use MS Access.
I want to connect to mdb file with multi users in the same time.
I known this is a bad way, but you help me, please !
Thank you.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Mahesh ChandPosted May 3, 2007, 9:44 AM
GeorgePosted May 3, 2007, 8:41 AM
It has 4 GB Limit and all performance speed of SQL Server 2005 ie, it doesn't have brakes put on it like MSDE has.
If you are about to start a new development project then do it with SQL Express 2005 -
Why wouldn't you ??
(Your question still needs to be answered - but essentially, by opening the database with Optimistic Locking, this should deal with your concerns of multi-user use)
Make sure you open and close connections as they are finished with so that you don't have problems with scalability
All the best