Multiple users accessing an Access database

[eblattner]

Is it possible for multiple users to access an Access database without using ODBC? I have an app that uses an Access database using

Set db = New Connection
db.CursorLocation = adUseClient
db.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "\VITdb.mdb;"

Set RS1 = New Recordset
RS1.Open "select * from Header", db, adOpenStatic, adLockOptimistic

as the connection string. This works well as long as there is only one app accessing the database. I have been told this app will be accessible to multiple users via Terminal Server. It does not work. I get the error "Error 3356 You attempted to open a database that is already opened exclusively by user..."

This was designed to be a single user app, now it will be a multi user app. Is there any easy fix? In the advanced options, in Access, the database Default Open mode is Shared, and Default Record locking is No Locks - still get the error.

Thanks for ANY and all responses

Eddie Blattner

 

[eblattner]

O.K., My bad. Since this started to be a single user app, I compacted the database on startup. Well, I didn't disable this when I tested it as a multi-user app. You can NOT compact a database that is opened by another user STUPID! Sorry for the bogus post, maybe someone else can use this.

Eddie Blattner