View Full Version : sharing linked tables


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.

Pat Hartman
09-17-2003, 01:28 PM
Text files are updated by DOS rather than Jet and they cannot be shared. You'll see the same problem if you try to open the file with notepad from two computers. If you want to truely share a file, import it into a table and then link to the table in another database.