roliver
09-17-2003, 10:28 AM
I can't figure out how to share a Access 2000 database that uses linked tables. Here is the boiled down situation.
In the folder TEST
I created a common delimited file called test.csv.
test.csv contains field1,field2
I create a new database in Access 2000 called test.mdb and link test.csv.
I share the folder TEST and open test.mdb on my computer and then, using a networked computer connect to my computer and open test.mdb and then I open the table test. When I then go to my computer to open the test table I get the error "The Microsoft Jet Database engine could not open the file 'Test'. It is already opened exclusively by another user, or you need permission to view its data."
I though I would make this easy to reproduce.
In the folder TEST
I created a common delimited file called test.csv.
test.csv contains field1,field2
I create a new database in Access 2000 called test.mdb and link test.csv.
I share the folder TEST and open test.mdb on my computer and then, using a networked computer connect to my computer and open test.mdb and then I open the table test. When I then go to my computer to open the test table I get the error "The Microsoft Jet Database engine could not open the file 'Test'. It is already opened exclusively by another user, or you need permission to view its data."
I though I would make this easy to reproduce.