Client is using SQL Server, Access .mdb Front End and Linked Tables

[SBendBuckeye]

They gave me a copy of their .bak files created using Enterprise Manager which I was able to restore into SQL Server running on my laptop. They also gave me a copy of their Access front end which is a standard database instead of an Access Project so it uses linked tables.

The problem I am having is that when I try to access the Link Table Manager in Access it gives me an error every time I try to refresh the links. Do I need to delete them all and recreate them for testing purposes on my laptop? If so, is there some code I can use as there are bunches of tables involved.

Thanks for any ideas and/or suggestions!

Have a great day!

j2consulting@yahoo.com

 

[onpnt]

seems like path issues may be the cause and effect of something of this nature.

did you adjust everything they gave you to laod properly on your system comparable to the two interacting on the clients system?

I highly doubt simply loading the databases on your laptop without modifications to particular permissions and path related needs will work.

___________________________________________________________________

http://www.onpnt.com

The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page faq333-3811

 

[ArtieChoke]

Typically, linked tables in Access use an ODBC data source on the local computer - make sure you create one that points to the SQL database.

"I think we're all Bozos on this bus!" - Firesign Theatre