How to connect to the tables

[wind54surfer]

Hi all,

I just changed the linked tables from "C:/Access/my_be.mdb" to" //Server/Access/my_be.mdb"

I did it in the office while connected to the "Server"

Now away from the office I need to make some changes to the "front end" but can't access the linked tables and "my_fe.mdb" won't start.

Is there a way to accomplish this?

Any help is really appreciated.

 

[Mr. B]

You need a copy of the back-end file on your local machine. You will then need to open your front-end file while holding down the Shift key until the file is open. Then you can use the Linked Table Manager to link to the back-end file on your local machine. Then when you are back in the office and on the network, you will again need to open the front-end file while holding down the shift key and use the Linked Table Manger to link to the tables in the back-end file that is on the server.

This sounds much worse that it really is but if you want to do development without being connected to the server, this is the only way.

 

[wind54surfer]

You need a copy of the back-end file on your local machine. You will then need to open your front-end file while holding down the Shift key until the file is open. Then you can use the Linked Table Manager to link to the back-end file on your local machine. Then when you are back in the office and on the network, you will again need to open the front-end file while holding down the shift key and use the Linked Table Manger to link to the tables in the back-end file that is on the server.

This sounds much worse that it really is but if you want to do development without being connected to the server, this is the only way.

I was afraid that was the only answer.

Thanks a lot.