Access of several users to a database

[yobensh]

Hi all,

I'm trying to figure out how to make it work...
I have an Access2000 as a database for my application which is installed at several users.
How can I let more than one user to access the database and update it so others can see the changes?

here is what I have now:

Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset

On Error GoTo err

'open connection to db
cn.Open "DSN=MPS"
rs.Open "Data", cn, adOpenDynamic, adLockOptimistic

....
what am I doing wrong here?
I'm getting an error that says something like: "This file is in use by other user"

Thanks in advance for your help!
Yoav

 

[fredericofonseca]

you need to set up your connection string in a way that allows multiuser access, as well as setting the MDB itself.

look at thread709-1177286 for a microsoft link on it, and also at

http://www.carlprothman.net/Default.aspx?tabid=81

for connection strings samples.


Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com