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?