Re: ADOX Compactdabase does not work correctly ?

From: Frank Hickman (fhickman_NOSP_at_M_noblesoft.com)
Date: 11/25/04 

Date: Thu, 25 Nov 2004 01:58:09 -0500

I'm pretty sure that the CompactDatabase method does not convert the
database so when you open it for validation Access 2000 makes it read-only
because Access 2000 cannot save changes in '97 format. 

-- 
============
Frank Hickman
NobleSoft, Inc.
============
Replace the _nosp@m_ with @ to reply.
"Fuochi Cédric" <nospam@nospam.com> wrote in message 
news:%23mKU7kg0EHA.1292@TK2MSFTNGP10.phx.gbl...
> 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

  • Re: Rapidly expanding MS Access data file size
    ... My recommendation is that in addition to the SQL server database, ... the application that is managing the imports. ... could use the CompactDatabase method to compact the temp.mdb file. ...
    (microsoft.public.access.externaldata)
  • Re: How can I be sure that I have opened a BE .mdb in exlusive mode?
    ... > CompactDatabase method? ... However, since your database is in a multiuser environment, then ... If you try to open a database in exclusive mode while someone ... prevented from opening it. ...
    (microsoft.public.access.security)
  • Compact Access DB with VB6
    ... Dim jro As jro.JetEngine ... sgDatabase is a valid and complete path to the db on the same computer ... sgDBName is the database name ... Is there no way to use the compactdatabase method in VB6 with an Access 2000 ...
    (microsoft.public.vb.general.discussion)
  • Re: How to: encrypt (password protect) prebuilt sql server ce data
    ... If the database is already created, the only way to get a database password ... on the database is to use the compactdatabase method. ... >> encrypt the database when the database is initially being created. ...
    (microsoft.public.sqlserver.ce)
  • Re: Shared v. Exclusive Access
    ... Control Panel, Add/remove programs, find Adobe, click Modify -> create Adobe ... The folder wherein the frontend resides grants Full permissions to the ... When I open the database, however, I don't get the message boxes. ...
    (microsoft.public.access.security)