By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,660 Members | 1,560 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,660 IT Pros & Developers. It's quick & easy.

Problems with the access 2003 convert option.

P: n/a


hi,
trying to convert access 97 to access 2003 with the access 2003
convertion tool of microsoft, but the only thing that isn't convert is
the modules in the vb of access 97.

what should i do ?

i need it urgently?

bye
Dori

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
There is a problem with the Access 97 database, and you will need to fix it
with Access 97 so the conversion process can complete.

1. Open the database in Access 97.
Open a code window.
Choose References from the Tools menu.
Make sure none are marked as "MISSING".
Deselect any you do not need. If you are not sure what you do need, see:
http://allenbrowne.com/ser-38.html

2. Compact the database:
Tools | Database Utilities | Compact.

3. Close Access 97. Decompile a copy of 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 it in A97 again.
Open a code window.
Choose Compile from the Debug menu.
Fix any errors.
Repeat until there are no errors.

Then try the conversion again.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dori" <do****@gmail.com> wrote in message
news:11**********************@l41g2000cwc.googlegr oups.com...


hi,
trying to convert access 97 to access 2003 with the access 2003
convertion tool of microsoft, but the only thing that isn't convert is
the modules in the vb of access 97.

what should i do ?

i need it urgently?

bye
Dori

Nov 13 '05 #2

P: n/a
thank you very much, i will try it and if i will find that it solve the
problem i will also let you know, my friend.
thanks again,
Dori

Nov 13 '05 #3

P: n/a
Hi Dori,
Another alternative is to create a new blank Access 2003 mdb file
and then import everything from the 97 version. If you have any modules
in the 97 version, your will have to update your references by
deselecting ADO (which is the default in 2000 and higher) and selecting
DAO 3.6

Hope ths helps.

David Hodgkins, MCSD, MCDBA, MCSE
dh*******@jstarsoftware.com
www.jstarsoftware.com
Dori wrote:
thank you very much, i will try it and if i will find that it solve the problem i will also let you know, my friend.
thanks again,
Dori


Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.