Unable to access database after moving to another computer

[joel]

We are currently have 3 computers on the network, all
computers have Office XP installed. One computer had an
Access database that we used to place all our customer
information in. That database was then shared to the
other machines using mapped network drives. The drive
letter was labeled F:. We recently purchased a new
machine that will house all our important files and will
no longer have it shareable on the network. We copyed the
database to this new computer, but when ever we try to
open the database it gives us an error that
states "Fatabase.mdb is not a valid path. Make sure that
the path name is spelled correctly and that you are
connected to the server on which the file resides." The
problem I have is this is not a shortcut to the database,
but the database itself. Filesizes match perfectly and we
copyed all the files that are in the folder that it was
created in.

Can anyone give me any advice on this?

 

[Immanuel Sibero]

Hi Joel,


A couple of things to look at:

Did you map the drive letter F: to the new computer?
Alternatively, you can also correct this by refreshing the linked tables to
the new location in the new computer.


HTH,
Immanuel Sibero

 

[Guest]

The new computer will not be on the network and is
actually located in an office that is appart from the main
one. There is no way to map a network drive.

I am unable to open the database to be able to change
anything because of this error.

 

['69 Camaro]

Hi, Joel.

Your database application has some startup automation executing in which it
attempts to open a form bound to a table that is located in another database
file, which *used to be* stored on the F:\ drive, which is not a valid path
on your new computer.

On this new computer that is not networked, open this database while holding
down the <SHIFT> key to prevent any startup Form from opening or Autoexec
Macro from executing. If Access security has been added, then after you
enter the password, hold down the <SHIFT> key while you're clicking on the
"OK" button.

Use the Tools menu -> Database Utilities -> Linked Table Manager to open the
Linked Table Manager Wizard. Here, you'll see a list of linked tables and
their paths. These paths are likely all identical and, if so, then you can
just select the "Select All" button on the right side of the dialog window
and then make sure that the "Always prompt for a new location" check box is
checked on the bottom left corner before selecting the "OK" button. You'll
next browse for a new location for where the database file containing these
linked tables is now located on your new computer.

If there are differing paths and file names in the Linked Table Manager
Wizard list, then you'll have to manually go through the list to make sure
that each linked table gets mapped to the new location of the file that
contains the table.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.