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
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