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

Database Conversion error

P: n/a
I got error message like "run time error 3421: data type conversion error"

how can i fix the trouble like that, any references should i include in ?

any help would be great

thank you
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Before conversion, perform these steps using your old version of Access.

1. Make a backup copy.

2. If you see an LDB file in the same folder as your database, delete it.

3. Compact the database to get rid of any temp objects: Tools | Database
Utilities | Compact.

4. Decompile by entering this into a command prompt while Access is not
running. (It's one line, and include the quotes.)
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\My Documents\MyDatabase.mdb"

5. Compact again to get rid of the junk left after decompile.

6. Open the database. Open a code window. Remove any references you do not
need. If this is Access 97, you probably need the Access, VBA and DAO
libraries. More info:
http://allenbrowne.com/ser-38.html

7. Compile (Debug menu from a code window).

You should now be able to convert.

--
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.

"Tu Quach" <qu********@optusnet.com.au> wrote in message
news:3f***********************@news.optusnet.com.a u...
I got error message like "run time error 3421: data type conversion error"
how can i fix the trouble like that, any references should i include in ?

any help would be great

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.