Compile error

A

Alain Vaillancourt

I have an Access 2000 database I can compile with no error with Access 2002
but when I convert it in the Access 2002 format I get the compile error
"Object library feature not supported" on the "Me" keyword. Anyone have an
idea of how to correct this problem...

Thanks!
 
A

Allen Browne

If this code is in the module of a form or report (not a stand-alone
module), then the Me keyword is fine, so something else is happening.

It is not uncommon for VBA to highlight the wrong thing, i.e. there could be
somehing else on that logical line that is causing the problem.

If you created a new A2002 database and imported, it might need references
fixed, e.g. a ref. to the DAO 3.6 library.

There could also be an incipient corruption in the original file, that is
uncovered by the conversion process. Try this sequence:

1. In the original A2000 database, uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact

3. Close Access. Make a backup copy of the file. Decompile the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Open Access, and compact again.

5. Try the conversion again.

Post back if that still fails.
 
A

Alain Vaillancourt

Thanks! My Name AutoCorrect was already turned off but I tried the decompile
feature anyway before converting and it corrected the problem...
 
A

Alain Vaillancourt

It was working and then I removed a module and the problem showed up again.
I tried decompiling the database (in the Access 2002 format) and I also
tried importing the database in a new database file but the problem is still
there. Anyome have an idea of what else to try...

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top