Access 2007 Unable to Compact Database

We are currently converting from Access 2003 to Access 2007. I have
an Access app that is going to be very difficult to convert. This App
is used by people that are out in the field and are a long distance
from where our Access Databases are. So that is why we have
Replication set up. So they have a local copy that they can replicate
to our copies when they are in a high speed area. Since they have
data on their local laptop we use VBA code to compact these
databases. This code is

DBEngine.CompactDatabase "C:\Source.mdb", "c:\SourceTmp.mdb"

The error I receive is:
Error 3251
Operation is not supported for this type of object.
Position = 2

Any help would be appreciated.

Thanks,
Jon

Re: Access 2007 Unable to Compact Database

Access 2007 does not support replication.

-Ed


"ISUTri" wrote in message
news:f7a77636-2752-4722-a509-183d33a18b5d@s8g2000prg.googleg roups.com...
> We are currently converting from Access 2003 to Access 2007. I have
> an Access app that is going to be very difficult to convert. This App
> is used by people that are out in the field and are a long distance
> from where our Access Databases are. So that is why we have
> Replication set up. So they have a local copy that they can replicate
> to our copies when they are in a high speed area. Since they have
> data on their local laptop we use VBA code to compact these
> databases. This code is
>
> DBEngine.CompactDatabase "C:\Source.mdb", "c:\SourceTmp.mdb"
>
> The error I receive is:
> Error 3251
> Operation is not supported for this type of object.
> Position = 2
>
> Any help would be appreciated.
>
> Thanks,
> Jon

Re: Access 2007 Unable to Compact Database

"Ed Robichaud" wrote in news:478997f2$0$26900
$2ff6ac69@news.wdn.com:

> Access 2007 does not support replication.
>
> -Ed

A DB in the ACCDB file format is not replicable. But MS claims that Access
2007 can replicate older file versions.

from http://office.microsoft.com/en-us/access/HA100484061033.aspx

"You cannot convert a replicated database to the Office Access 2007 file
format. However, you can use Access 2007 to create a replica of a database
that is formatted in either the Access 2000 or the Access 2002 - 2003 file
format."

from Access 2007 Help:

"Office Access 2007 employs a new file format that supports a number of
product enhancements. When you create a new database in Access 2007, the
database uses the new file format by default and is given the .accdb file
extension.

You should use the new file format whenever possible because it supports
new features, such as multivalued fields and attachments. However, the new
file format cannot be opened or linked to with earlier versions of Access,
it does not support replication, and it does not support user-level
security. If you need to use the database with earlier versions of Access,
or if you need to use replication or user-level security, you must use an
earlier version file format."

Re: Access 2007 Unable to Compact Database

On Jan 9, 5:23 pm, ISUTri wrote:
> We are currently converting from Access 2003 to Access 2007. I have
> an Access app that is going to be very difficult to convert. This App
> is used by people that are out in the field and are a long distance
> from where our Access Databases are. So that is why we have
> Replication set up. So they have a local copy that they can replicate
> to our copies when they are in a high speed area. Since they have
> data on their local laptop we use VBA code to compact these
> databases. This code is
>
> DBEngine.CompactDatabase "C:\Source.mdb", "c:\SourceTmp.mdb"
>
> The error I receive is:
> Error 3251
> Operation is not supported for this type of object.
> Position = 2
>
> Any help would be appreciated.
>
> Thanks,
> Jon

In Access 2007 this works for me. ffdbabooks.mdb is in 2002 format.

Sub temp()
DBEngine.CompactDatabase "ffdbabooks.mdb", "temp.mdb"
End Sub