DataBase - Ms Access 2000 to Ms Access 2003

Asked By Skrogy

14-Nov-09 02:39 AM

I built a db using Ms Access 2000 with drop down boxes and such.  Company
recently upgraded to Ms Access 2003 and drop down lists are blank.  If I put
the file on a computer without the upgrade they are there.  I dont know of
any other issues yet that wont work as Im afraid of corrupting the database.

16-Nov-09 02:30 PM

If you are afraid of corrupting the database, make copies of it, first.  (In
any cases, you should make copies/backups of your database files at a
regular interval; otherwise you will deeply regret it if you find yourself
with a corrupted copy and withou any recent (very recent) backup).

Second, this is not the place for asking this question.  This newsgroup is
about Data Access Pages and is very specialized as you can see by the very
few posts here.  If you want a better luck in getting an appropriate answer,
you should ask in a newsgroup such as microsoft.public.access.

In your case, you might have a reference problem or a compilation problem.
What happens if you create blank new database file directly from Access 2003
and import everything into it?

The usual solution to the problem of moving a file between different version
of Access and of Windows if to fully decompile the file before using it on
the newer version.  Create a shortcut with the following start parameters:

/decompile /compact /repair.

Another trick is to add a dummy reference in the VBA references window,
close the window, reopen it and remove the dummy reference.  This will force
Access to recompile all modules because the references list has changed.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)

06-Dec-09 04:08 PM

Hi, Skrogy

If your access db is broken.I think you can try a utility called
Advanced Access Repair to repair your Access MDB file. It works rather
well for my corrupt Access MDB files. Its web address is
http://www.datanumen.com/aar/

WangD.

12-Dec-09 04:21 PM

1) You are an employee of such a company

2) You should be disclosing that fact more openly.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/