Invalid Path

[Guest]

Trying to Copy a database from one computer to another. After copying to my
flash drive and the to the other computer, I received the following message
when trying to open a form:
C:\Mydocuments\MyComputername\MyDocuments\ThierComputername\FolderName\LMT.mdb"
My computer being my computer and TheirComputerName being their computer.
Both computers are running Windows XP and Access 2000.

 

[Joseph Meehan]

Trying to Copy a database from one computer to another. After copying
to my flash drive and the to the other computer, I received the
following message when trying to open a form:
C:\Mydocuments\MyComputername\MyDocuments\ThierComputername\FolderName\LMT.mdb"
My computer being my computer and TheirComputerName being their
computer. Both computers are running Windows XP and Access 2000.

It sounds like the path to linked files has changed. Have you tried
manually re-linking them? I am assuming this is a split database.

 

[Guest]

I don't want to sound illiterate, but explain manually re-linking them. And
yes, this is a split database. After I copy it to the other computer I can
even open a form.

 

[Joseph Meehan]

I don't want to sound illiterate, but explain manually re-linking
them. And yes, this is a split database. After I copy it to the other
computer I can even open a form.

I have not had to do it for some time. Here is some help from the help
file. See if that helps. If not come back and if needed I will do a little
more checking

1.. Open a database, or switch to the Database window for the open
database.
2.. Do one of the following:
a.. To import tables, on the File menu, point to Get External Data, and
then click Import.
b.. To link tables, on the File menu, point to Get External Data, and
then click Link Tables.

3.. In the Import (or Link) dialog box, in the Files of type box, make
sure that Microsoft Access (*.mdb; *.adp; *.mda; *.mde; *.ade) is selected.
4.. Click the arrow to the right of the Look in box, select the drive and
folder where the Access file that you want to import or link is located, and
then double-click the database's icon.
5.. In the Import Objects (or Link Tables) dialog box, click each table
that you want to import or link.
If you're importing, and you want to import just the selected tables'
definitions (not the data they contain), click Options, and then under
Import Tables, click Definition Only.

Note If you import a table that is already linked, then Access does not
import the data; instead, it links the table to its data source (in effect,
copies the link information).

 

[Guest]

Thank You I will Try it.

I have not had to do it for some time. Here is some help from the help
file. See if that helps. If not come back and if needed I will do a little
more checking

1.. Open a database, or switch to the Database window for the open
database.
2.. Do one of the following:
a.. To import tables, on the File menu, point to Get External Data, and
then click Import.
b.. To link tables, on the File menu, point to Get External Data, and
then click Link Tables.

3.. In the Import (or Link) dialog box, in the Files of type box, make
sure that Microsoft Access (*.mdb; *.adp; *.mda; *.mde; *.ade) is selected.
4.. Click the arrow to the right of the Look in box, select the drive and
folder where the Access file that you want to import or link is located, and
then double-click the database's icon.
5.. In the Import Objects (or Link Tables) dialog box, click each table
that you want to import or link.
If you're importing, and you want to import just the selected tables'
definitions (not the data they contain), click Options, and then under
Import Tables, click Definition Only.

Note If you import a table that is already linked, then Access does not
import the data; instead, it links the table to its data source (in effect,
copies the link information).