Linked Tables in Access 2000

[BobbyRidler]

I hope someone can help with this problem.

I have a split database, the back-end resides on a network server and the front end on my pc (win 2000).

I have linked the tables from the back-end to the front-end using the recommended UNC path. However, I cannot open any of the tables in datasheet view. I can create queries, reports etc., on the linked tables except opening.

If however, I hard-code the path of the linked tables, I have no problem opening the tables.

By the way, both the back-end and front-end are Access 2000 databases.

If anyone has a solution to this, I would be very grateful if you could reply to this post


Anthony

 

[hjgoldstein]

Hi, Anthony.

It might just be that your OS doesn't support UNC paths in this situation. It is sometimes the case with Windows 2000. You might just need to map a network drive letter or keep in the hard coding.

I don't think that it sounds like an Access 2000 problem.

Hope this helps.

Howard.

 

[BobbyRidler]

Thanks for the tip.

I'd rather not hard code the path, but if I have no choice then I guess I'll have too. Problem is, I have multi-users using the database and several of them have mapped varying drive letters to the folder.

Anthony