Can't open in Access2003

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

Guest

I have a database designed in Acces2002 (using 2000 format).

I now have a new computer preloaded with Access2003 ...and every time I try
to open the database I get an error loading a form. The error is on the
switchboard.

Stange thing is that this same Database opens on other PC's running 2003.
I tried compacting and repairing and got no results.
 
Hi Stephen,

You are undoubtedly using a switchboard created with the switchboard
manager. To verify this, do you have a table named "Switchboard Items"?

The switchboard manager wizard uses late bound ADO code behind the
Switchboard form (Access 2000 and higher). If you have any problems with your
MDAC (Microsoft Data Access Components) installation or ADO is not properly
registered on a PC, then you can run into these types of issues. Personally,
I avoid using the wizard-built switchboard by creating my own unbound
switchboard forms.

Try reregistering ADO. To do this click on Start > Run and enter the
following command:

Regsvr32.exe C:\progra~1\common~1\system\ado\Msado15.dll

Then click on OK.

If you still cannot get the switchboard to function properly, then download
the MDAC Component Checker utility and run it on your PC:
http://support.microsoft.com/?id=307255


Good Luck,
Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

I have a database designed in Acces2002 (using 2000 format).

I now have a new computer preloaded with Access2003 ...and every time I try
to open the database I get an error loading a form. The error is on the
switchboard.

Stange thing is that this same Database opens on other PC's running 2003.
I tried compacting and repairing and got no results.
 
ODBC or OLE problems on the machine it won't open on, maybe? Or some other
component external to Access that your database needs? Happens to me all the
time.
 
MDB is too unreliable to use in the real world for anything.

use Access Data Projects so you dont lose your data when windows has a
hiccup.

keep your DATA in a DATABASE SERVER
if you care enough to build a database; do it right not twice
 
Stephen said:
I have a database designed in Acces2002 (using 2000 format).

I now have a new computer preloaded with Access2003 ...and every time I try
to open the database I get an error loading a form. The error is on the
switchboard.

Stange thing is that this same Database opens on other PC's running 2003.
I tried compacting and repairing and got no results.
Click to expand...
 
Back
Top