I have an Access 2003 database that was developed and used throughout it's life on a desktop computer which has an internal hard drive and an external hard drive. The database has been residing in the external drive (Call it the K: drive) It has a front end and a back end file. When working in this environment it works great and I have no troubles with it.

I have recently added a tablet computer to my office and I want to transfer the database to that computer so that I can have full access to my records when I am on the road and using the tablet away from my home office wireless network.

I copied both the front end and the back end files to the C: drive of my notebook, and the database tables, etc come up fine. When I try to use any of my forms, reports, etc, I get an error message:

"K\Mydocuments\PBS Docs\FORMS\PBS_be.mdb is not a valid path. Make sure that the path is spelled correctly and that you are connected to the server on which the file resides."

I cannot figure out how to change the relationships within my application to make the program look in a different place to find its back end. It's probably very simple but I'm stumped. Can anyone help me?


Rod Johnson
pbscda@gmail.com

Welcome to UA!!

This is down to the connection string for the linked tables - they are looking for your k: drive.

You could try using database replication or copy both front and back-end db's again and relink the tables using the linked table manager.

HTH
Paul

Hi Rod

You just need to use the Linked table Manager

Open the FrontEnd Db and then choose
Tools > Database Utilities > Linked Table manager

Then just point to the BackEnd

Hope this helps

Mike