Serious DB error

General discussions about Abacre Restaurant Point of Sale
Post Reply
Nongkiau
Posts: 35
Joined: Sun Jul 20, 2008 4:36 am

Serious DB error

Post by Nongkiau » Wed Feb 24, 2010 2:34 am

My DB file in unreadable. I'm getting this error when I try to open the .mdb file directly. I cannot open it in Abacre.

The Database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code from modules, forms and reports. You should backup your database before attempting to open the database and delete the VBA project.

Abacre
Site Admin
Posts: 1198
Joined: Mon Jan 31, 2005 5:32 pm
Contact:

Re: Serious DB error

Post by Abacre » Wed Feb 24, 2010 5:45 am

There are no VBA projects inside database (no modules, no reports).
So as advised you can try to delete VBA projects in order to open finally database.
Or try to restore your database from backup.
Kind regards,
Abacre Limited
http://www.abacre.com
support@abacre.com

Nongkiau
Posts: 35
Joined: Sun Jul 20, 2008 4:36 am

Re: Serious DB error

Post by Nongkiau » Wed Feb 24, 2010 10:33 am

I googled the problem and realised that this is a common problem when a .mdb file of Access 2003 is opened with Access 2007. I'll try to delete whatever VBA there is in there.

Abacre
Site Admin
Posts: 1198
Joined: Mon Jan 31, 2005 5:32 pm
Contact:

Re: Serious DB error

Post by Abacre » Wed Feb 24, 2010 3:39 pm

In current version we are using drivers of Access 2003 because most customers still use it.

So if you already opened the database file with Access 2007 and if you don't have backup copy of file then the solution can be the following:

Open database file with Access 2007 then try to use main menu Tools - Database Utilities - Convert Database - To Access 2002-2003 File Format.
There a exact menu command for Access 2003. In Access 2007 there are similar command.

Finally, with Access 2007 you will be able to convert your database back into Access 2002-2003 File Format.
Kind regards,
Abacre Limited
http://www.abacre.com
support@abacre.com

Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests