ADOX Compactdabase does not work correctly ?

From: Fuochi Cédric (nospam_at_nospam.com)
Date: 11/24/04 

Date: Wed, 24 Nov 2004 10:38:47 +0100

System : Windows XP Pro SP1, MDAC 2.8, Jet 4.0 last SP, Access 2003 Pro

I use ADOX JetEngine Compactdatabase method to convert an access 97 database
file to an access 2000 database file.

the conversion is successfull, but when opening the database in access it
display a message asking for :
- converting the database
OR
- validating the database

I choose validating the database, but it produce warnings, saying that the
database is in ReadOnly mode and no modifications can be done, (to do
modifications, convert the database... and so on...). The problem is that
I can't modify anything in the database, except data. (can't delete
relation,
table, ...)

If I try to convert the same access 97 database via the access menu :
Tools\Database utilities\Convert database, the conversion succeed without
any problems and I can modify/delete what I want.

Conclusion : the ADOX conversion method do not convert correctly to access
2000 format.

I must use the ADOX conversion method to convert the database and can not
use the access menu as a workaround.

did anyone experience the same problem ?

thanks in advance

Relevant Pages

  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)
  • Re: Converting database from Access 97 to 2003: problems
    ... Although the owner of the database had all the rights the conversion was not ... placed the Admin user in the Admins group (Admins group has Administrator ...
    (microsoft.public.access.conversion)
  • Re: MDW
    ... using the MDB at the same time. ... When Access 2003 enables the database, ... Multi-User Databases are databases which have an associated WIF (Workgroup ... that could complicate the conversion process. ...
    (microsoft.public.access.gettingstarted)
  • RE: Conversion from VT_DECIMAL TO VT_I8 failed
    ... Welcome to MSDN newsgroup. ... Regarding on the Type Converting problem met in accessing database through ... Conversion from VT_DECIMAL TO VT_I8 failed ...
    (microsoft.public.data.oledb)
  • Re: Converting user-secure 97 to 2000
    ... appear when I open the converted database files in Access 2000. ... >> Use the Compact and Repair Database menu item to compact the new MDB file. ... Starting Access 2000 with the MDW file can only be done in two ways: ... in either the conversion or import processes. ...
    (microsoft.public.access.conversion)