Major Problems with conversion to 2003

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

Guest

I have a new computer pent 4 3ghz, 1 gig Ram, XP PRO, & Office 2003 complete
install.

Database is split, compilied, & relatively simple.

I converted both my compiled copy and my development copy of my application
from Access 2000 to Access 2003. If I open any of them both the program and
my computer run slow and lock up.

I removed a bunch of code that just did some color design features and it
doesn't crash when I open the forms and it doesn't run slow.

I tried to create a new compiled version from the development copy and It
won't let me. It says there are too many objects, exceeding 2048. I just have
34 forms,4 queries, 15 tables, 8 macros, & 16 reports

Does anyone have any experiance and suggestions for this problem.

Thank you!
 
It certainly sounds like something has corrupted.

Try this sequence to get Access to recreate it:

1. Make a backup copy of the problem file.

2. Decompile 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"

3. Create a new (blank) database.

4. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

5. Import everything from the old database:
File | Get External | Import

6. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

7. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.
 
Thank you for the response. After much research on the Microsoft support site
I found the instructions for decompile but it wouldn't load. I ended up
running compile in in VB editor about 50 times and deleting all the code it
didn't like. Each time I deleted code Access and VB Editor would lock up and
I would have to close them. I think the problem was a module I downloaded and
imported from peterssoftware.com that created a background color gradient on
each form. The code in the module and each form that created the gradient was
specifically for Access 2000 so when I converted that code then became
corrupt.

After a whole day of that it seems to work fine.
 
Back
Top