how to change hard-coded computer name

[OM]

Hi,

I am given a Access 97 DB that I would like to upgrade to access XP or 2003
and place it in on a new server.

When I run the DBs from the new machine, it is giving me the following
error.

'\server\share\myapp.mdb' s 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.

Although I am don't much about Access, I believe that the name of the old
server (server in this case) which the DB resided on is hard-coded within
the DBs (the front end is written in Access as well).

Would anyone pls. tell me where I should look at in order to change the
computer name within Access?

PS: I did look at the code in all the modules and can't seem to find the
reference.

Thanks

Keith

 

[John Vinson]

Would anyone pls. tell me where I should look at in order to change the
computer name within Access?

Tools... Database Utilities... Linked Table Manager.

John W. Vinson[MVP]

 

[OM]

My guess is it is looking for a linked database that would have been at
that location in the old computer. If the database loads, you should be
able to re-link to that database from your current location, assuming you
have the proper access to that database.

Thanks guys,

The database is sitting in the same folder location as the application.
I can't seem to re-link to the database. Access just displays that error
message without offering any suggestion (relinking the DB).

Thanks

Keith

 

[John Vinson]

The database is sitting in the same folder location as the application.
I can't seem to re-link to the database. Access just displays that error
message without offering any suggestion (relinking the DB).

Try holding down the SHIFT key as you open the database to bypass any
startup code. Do you see table names in the Tables tab of the database
window, with arrow icons by them? If you do, you should be able to
select Tools... Database Utilities... Linked Table Manager to
reconnect to them.

You apparently have some startup code which is attempting to open the
linked tables. Relinking may cure the problem; or you may need to dig
into the startup code and identify where the old path is hardcoded.

John W. Vinson[MVP]

 

[OM]

Try holding down the SHIFT key as you open the database to bypass any
startup code. Do you see table names in the Tables tab of the database
window, with arrow icons by them? If you do, you should be able to
select Tools... Database Utilities... Linked Table Manager to
reconnect to them.

You apparently have some startup code which is attempting to open the
linked tables. Relinking may cure the problem; or you may need to dig
into the startup code and identify where the old path is hardcoded.

John W. Vinson[MVP]

Thanks for your reply John,

I am able to look at the design view and select the table with the
arrow. However, when I highlight the table (any of them), the linked
table manager is not available (gray out).

How do I find the startup code within the DB? I did look the modules and
can not find the reference for the machine name though.

Thanks

Keith

 

[John Vinson]

I am able to look at the design view and select the table with the
arrow. However, when I highlight the table (any of them), the linked
table manager is not available (gray out).

The linked table manager gives you a list of all the tables - you
shouldn't have any table selected in order to use it. Within the LTM
you can select which tables to relink.

It this doesn't help, I'd suggest the following: MAKE A BACKUP of your
database, this can be dangerous.

Open it (shift-open as before); select the table (each table) that has
the arrow, and delete it. This will delete the link (not the backend
table).

Then use File... Get External Data... Link to connect to the new
location of the backend to relink the table. If you go through Network
Neighborhood rather than My Computer you'll get the \\server\path
syntax, which can be preferable as it's not sensitive to drive mapping
letters.

John W. Vinson[MVP]

 

[OM]

The linked table manager gives you a list of all the tables - you
shouldn't have any table selected in order to use it. Within the LTM
you can select which tables to relink.

It this doesn't help, I'd suggest the following: MAKE A BACKUP of your
database, this can be dangerous.

Open it (shift-open as before); select the table (each table) that has
the arrow, and delete it. This will delete the link (not the backend
table).

Then use File... Get External Data... Link to connect to the new
location of the backend to relink the table. If you go through Network
Neighborhood rather than My Computer you'll get the \\server\path
syntax, which can be preferable as it's not sensitive to drive mapping
letters.

John W. Vinson[MVP]

I don't know why the LTM is not available even I did not select any
tables. Anyway, I will give your suggestion a try.

Thanks very much for you input John

Keith