Hi.
What am I missing here? Is it a linked table
Very likely. To find out, you'll need to open the database file without any
startup settings running. Hold down the <SHIFT> key while opening the
database, and keep holding the <SHIFT> key until the database is completely
open.
Select the Tools menu -> Options... to open the Options dialog window.
Select the "View" tab, then check the "System objects" check box. Select
the "OK" button to save your change.
In the Database Window, select the "Tables" tab. Scroll down to the
"MSysObjects" table and open it in Datasheet View. Look for any entries in
the "Database" column. These entries will list the file path and file name
of any databases that contain a table that the current database links to.
If you find any file paths in these records that you know are wrong, then
you'll have to delete the link to that table and relink to it using the Link
Manager. If none of these paths look suspicious, then manually test all of
the links. To do so, for each record that has a file path and database file
name listed in the "Database" column, find the name of the linked table in
the "Name" column. Go back to the Database Window and double-click to open
the linked table. If it opens in Datasheet View, then the link is valid, so
check the other links, too.
If any linked table doesn't open, then you'll receive the error message that
the path is invalid. This link will need to be deleted, and the table
relinked using a valid path and file name.
When you are finished checking the links, select the Tools menu ->
Options... to open the Options dialog window. Select the "View" tab, then
uncheck the "System objects" check box. Select the "OK" button to save your
change. The system tables will disappear from the Database Window.
If you cannot find a bad link in your linked tables, then perhaps it's a bad
link hard coded-in the VBA code or listed in the property of a database
object. Search the VBA code for the path and file name that Access is
claiming is invalid in the error message.
If you still can't find the invalid path that Access is complaining about,
post back here. There are more things to check, but only after you've
eliminated the most obvious ones first.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
ddodge said:
I have installed a new XP workstation at a client site and am trying (from
the workstation) to open an Access 2000 database on an NT4 server. The XP
workstation is running Access 2003.
When I try to open the database on the server I get an error message which
says that the path to the database "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."
It is the correct path and I am connected and other client machines on the
network can open the database file.
What am I missing here? Is it a linked table or security group issue? I
haven't worked with Access very much and the last time was several years
ago.
