Opening 2000 Format Database in 2003.

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

Guest

Just installed Access 2003 to manage our HUGE database for our supplement
website. I can open the database (created by our programmer, the jerk), but
when I click on a table or anything for that matter I get "ODBC connection
failed," and "Cant Open Table in Designsheet View." Now cut me some slack
here, I'm teaching myself Access from scratch with absolutely no help or
schooling, so this is probably a stupid question. I transferred this database
from another computer, I'm not sure if I did something wrong, but I NEED
help, I'm going crazy! I will bow down in your presence!!!
-Margit
 
Margit

It sounds like the front-end (the piece you moved from another computer) is
using linked tables (the tables of data are elsewhere, not in the copy).

But it also sounds like the way the tables were linked was using a network
"share" (like the N: drive, or the P: drive or the Z: drive). You can
discover this by opening the database, clicking on Tools | Database... |
Linked Table Manager and looking at how the tables are linked (in
parentheses).

Here's a likely possibility ... your PC does NOT have the same share as the
old one. Either map a share with the identical drive letter (e.g., N:, P:,
Z:, ...), or re-link to the tables, whereever they are on the LAN, using a
UNC naming convention (e.g., \\servername\path\file). You might need to
look up how to use UNC...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Thank you so much. I understand what you're saying. I'm going to try to
tackle this now so I may need you again! Thanks Jeff!
 
Back
Top