opening DB problem

L

Little pete

I have gone out to a customer copied there DB to CD but then when i try and
open it up on my PC i get the following when trying to view the tables etc

'S:\StepsOpen_be.mdb' is not a valid path. make sure that the path name is
spelled correctly and that you are connecting to the server on which the file
resides.

That S: drive is where the customer has it on there PC, i would have thought
that since i have it on CD and moved to my PC thats where the path would be.

the size of the DB shows its 16mb

can some one help me out, thanks
 
D

Douglas J. Steele

You'll need to use the Linked Table Manager to change the linkages from
S:\StepsOpen_be.mdb to whatever's appropriate for your CD drive.
 
B

Brian

Little pete said:
I have gone out to a customer copied there DB to CD but then when i try and
open it up on my PC i get the following when trying to view the tables etc

'S:\StepsOpen_be.mdb' is not a valid path. make sure that the path name is
spelled correctly and that you are connecting to the server on which the file
resides.

That S: drive is where the customer has it on there PC, i would have thought
that since i have it on CD and moved to my PC thats where the path would be.

the size of the DB shows its 16mb

can some one help me out, thanks
Click to expand...

The name of the problematic file suggests that the database is split into a
front end and a back end i.e. to copy it you need TWO files, probably called
"StepsOpen.mdb" (the front end), and "StepsOpen_be.mdb" (the back end).
If/when you have got both files, the linked tables in the front end file
will still be linked to S:\StepsOpen_be.mdb, so you will need to relink them
to your copy of the back end. You can do this by right-clicking on any of
the linked tables in the front end file, and choosing Linked Table Manager
from the pop-up menu. It is possible that you do not have the Linked Table
Manager installed, in which case you will need your Office/Access
installation disks to install it.
 
Top