Could not find <back end database path> database's startup message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I enjoyed the code provided there:
http://www.mvps.org/access/tables/tbl0009.htm

but:

1)I don't know how to avoid the message that the database shows when starts
up and don't find the linked table!: Could not find <back end database path>

2) what's the best way to launch a Function when the database starts?
in my case the function is "fRefreshLinks()"
 
Autoexec - is a right one. if you call this function in Autoexec - then it
will relink tables before any form opened - so you get rid of "Could not
find <back end database path>" message
 
Hi Alex,

I have been trying to run the code found at
http://www.mvps.org/access/tables/tbl0009.htm

I keep getting an error saying I haven't defined the type. I am assuming I
haven't got the appropriate object library or type library ticked. Do you
know which libraries are required to run this code?

Also, my issue is that on my computer a drive is mapped to my Q drive, some
other users have S drive, others have P etc etc. When I link a table is
obviously references the Q drive, I am struggling.......

If my locations don't change, and I just want the linked tables to point to
the actual server address, is this possible?

Thanks

Neil
 
If my locations don't change, and I just want the linked tables to point to
the actual server address, is this possible?
Click to expand...

Just to add to Alex' suggestion - you can use the file location dialog that
the linked table manager will bring up; the trick is to navigate via Network
Neighborhood, not via the mapped drive names. This will store the UNC path in
the tables' connect strings, and other users with different mappings will be
able to connect without having to re-find the backend.

John W. Vinson [MVP]
 
Back
Top