Can't compact or repair after doing DDL changes to Access

[Laphan]

Hi All

When I do DDL style queries on my Access DB via VB, eg alter table, add col,
etc, Access won't let me compact/reapir the DB!!

It says it can't recognise the DB, but everything appears to work OK.

Do you know why this is and is there a fix?

Thanks

 

[Ralph]

Hi All

When I do DDL style queries on my Access DB via VB, eg alter table, add col,
etc, Access won't let me compact/reapir the DB!!

It says it can't recognise the DB, but everything appears to work OK.

Do you know why this is and is there a fix?

Thanks

You need to provide a little more detail.
Are you unable to compact/repair while the database is open in MSAccess
(using menu options)? Or are you using JRO? DAO?
Are you using MSAccess 2007?

-ralph

 

[Newbie]

Hi Ralph

Access 2003 DB

DDL queries done through VB > ADO > DB

Tried to compact/repair through Acess 2003 program.

Is it possible to compact/repair through ADO?

Rgds

Hi All

When I do DDL style queries on my Access DB via VB, eg alter table, add col,
etc, Access won't let me compact/reapir the DB!!

It says it can't recognise the DB, but everything appears to work OK.

Do you know why this is and is there a fix?

Thanks

You need to provide a little more detail.
Are you unable to compact/repair while the database is open in MSAccess
(using menu options)? Or are you using JRO? DAO?
Are you using MSAccess 2007?

-ralph

 

[Jamie Collins]

Is it possible to compact/repair through ADO?

How To Compact Microsoft Access Database Through ADO
http://support.microsoft.com/kb/230501

Jamie.

--

 

[Newbie]

Many thanks for this.

But what worries me is that the DB seems unrecognisable after I've done
these DDL queries - is this normal?

I can do things in the DB via Access, eg add data, add columns, etc without
problems, but I can't compact/repair.

Rgds

Is it possible to compact/repair through ADO?

How To Compact Microsoft Access Database Through ADO
http://support.microsoft.com/kb/230501

Jamie.

--

 

[Jamie Collins]

what worries me is that the DB seems unrecognisable after I've done
these DDL queries - is this normal?

I know that I must refresh the cache (again using JRO) to ensure the
changes are 'visible' to all connections to the mdb and that is
normal.

I can do things in the DB via Access, eg add data, add columns, etc without
problems, but I can't compact/repair.

I know that I must close connections to the mdb before it can be
compacted and that is by design, not a problem.

Whether you have other problems, I do not know.

Jamie.

--