Access looks for a particular drive.

[billyboy2]

A colleague was programming our Access database before I was asked to make a
few changes on it because we changed PCs. On loading, it tries to locate
the .mdb & graphic files on a particular drive - \\mdb-filesrv\goodguys.
"mdb-filesrv" was the network name of the former PC which is no longer in
use, and "goodguys" was the name of the folder with the "goodguys.mdb" file.
I've use the "Find" menu command to search through the vba codes for a clue
without luck. Please, how do I make it point to the new PC whose network
name is "mdb-filesrv-2": The folder is still the same - "goodguys".
Thanks.
- Billy Boy II.

 

[Guest]

I'd suggest creating a constant value in a module to begin with and setting
this to the name of your server.

i.e.

Public Const myServer As String = "\\mdb-filesrv-2"

You can do a global Find & Replace for the VBA replacing all instances of
\\mdb-filesrv\ with myServer & so that it builds up the path string.

As for references not in VBA, you will probably have to find them yourself.
The text can be replaced, in queries and forms for example, with this
function in a standalone module.

Public GetServer() As String
GetServer = myServer
End Function

 

[Larry Daugherty]

Tools|Add-ins|Linked Table Manager. Check the specific tables or the Ask
for all checkbox. OK. Now navigate to the desired location.

HTH

 

[Guest]

Tools|Add-ins|Linked Table Manager. Check the specific tables or the Ask
for all checkbox. OK. Now navigate to the desired location.

The original poster stated that the server details were in VBA and not via
the linked tables.

Just an observation.

 

[Douglas J. Steele]

The original poster stated that the server details were in VBA and not via
the linked tables.

Just an observation.

Where did the original poster say that the server details were in VBA?

The only reference to VBA I see in the original post is "I've use the "Find"
menu command to search through the vba codes for a clue without luck"

 

[Larry Daugherty]

Mot in what I read: Just an observation. It seems that the original poster
assumes that the problem is in VBA code but can't find the target text. I'm
guessing that the error is in his assumption and that using the Linked Table
Manager will solve his problem.

 

[Nick Coe \(UK\)]

In billyboy2 typed:

A colleague was programming our Access database before I
was asked to
make a few changes on it because we changed PCs. On
loading, it
tries to locate the .mdb & graphic files on a particular
drive -
\\mdb-filesrv\goodguys. "mdb-filesrv" was the network name
of the
former PC which is no longer in use, and "goodguys" was
the name of
the folder with the "goodguys.mdb" file. I've use the
"Find" menu
command to search through the vba codes for a clue without
luck.
Please, how do I make it point to the new PC whose network
name is
"mdb-filesrv-2": The folder is still the same -
"goodguys". Thanks.
- Billy Boy II.

Further to the other answers and this is a long shot, you
could check to see what the default database folder is set
to in Tools|Options General tab.

--
Nick Coe (UK)
AccHelp v1.01 Access Application Help File Builder
http://www.alphacos.co.uk/
Download Free Copy
----

 

[billyboy2]

A special 'Thank U' to all the nice folks in these groups who help novices
like me. The suggestions you offered were of great and instant help.
Problem fixed! I'm sorry that I posted the problem in several boards -
guess I was desperate. Hope you help a lot more others. Thanks again.
- Billy Boy II.