Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Opening Access DB more than one user

Status
Not open for further replies.

Phailak

Programmer
Apr 10, 2001
142
CA
Hail,

This is probably a real beginner question but I can't figure out a way around it. A VB app opens a recordset connection to the access MDB. While it is opened, no one else can use the application? The code to open the connection is like:

Dim DB as Database, RST as Recordset
Set db = OpenDatabase(App.Path & "\test.mdb", 512, False)
Set rst = db.OpenRecordset("Test", dbOpenDynaset, 512)
Could one of these parameters be causing these errors or can't I just not have a recordset open while others connect?

The error is like test.mdb file is already in use...

Phailak
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top