Tools to scan access database

  • Thread starter Thread starter Eric Sten
  • Start date Start date
E

Eric Sten

I hope somebody can point me in the right direction.

I'm looking for a tool or script that will allow me to
scan access databases and look for externally linked
tables. What is going on is we are moving off of a
Novell file server to a Win2k server and want to find any
access database that references a table by UNC or drive
letter path so we can change it before we move it if
necessary.

Thanks!

Eric Sten
Desktop Systems Analyst
Ohio National Financial Services
 
Allen,

Thanks for your quick reply. This should help with a
few databases but not many unfortunetly.

I think I need to give more detail.

More detail....
We have 300+ databases that need to be checked. Most of
the people who use/created these databases don't know how
to or want to spend the time checking their databases.
We (the Helpdesk) have limited Access skills, to the
point of knowing how to troubleshoot some problems and
create basic databases. So what I'm looking for is an
external (to Access) program that will check and report
back if a database, or a bunch of databases have
eternally linked tables.
 
Back
Top