MDB File path

[Tina]

Hi,

I have a project with a bunch of queries and macros. The mdb file has lived
on a server. But for development purposes, I need to move it elsewhere. When
trying to run any of the macros/queries, I get a file path error. Where do I
find and fix the path? I am quite sure the path was hard-coded when
originally created.

Any help this newbie will be greatly appreciated.

Thanks.

 

[Rick Brandt]

Hi,

I have a project with a bunch of queries and macros. The mdb file has
lived on a server. But for development purposes, I need to move it
elsewhere. When trying to run any of the macros/queries, I get a file
path error. Where do I find and fix the path? I am quite sure the
path was hard-coded when originally created.

Any help this newbie will be greatly appreciated.

Thanks.

You would of course have to look at the design of each and every macro that
produces the error. If queries raise this error then I would expect that
perhaps table links might be pointing at an incorrect location (unless those
queries make use of user defined functions). Another possibility is a query
that uese an IN clause to reference another MDB file.

This is actually a bit strange. In a monolithic MDB file, moving it should not
make any difference since a file would rarely make reference to its own
location. In a split application it would be moving the back end file that
would cause errors. Moving the file that contained macros and queries should
again not make any difference.