Briefcase can't sync access 2007 database

[Bernie Herpin]

I setup a briefcase that contains an Access 2007 database file. When I made
change to the DB in the briefcase and try to sync with desktop, get an error
message that briefcase can't sync file because the database is not repicable.
How can I make it replicable?

 

[Tom van Stiphout]

On Mon, 22 Feb 2010 20:37:01 -0800, Bernie Herpin <Bernie
(e-mail address removed)> wrote:

Is this an accdb file or an mdb file?

-Tom.
Microsoft Access MVP

 

[a a r o n . k e m p f]

I thought that it was pretty clear, that when he says 'Access 2007
database file' that he's referring to ACCDB
basically.. Because jet replication was soo buggy and unreliable,
Microsoft removed Replication capabilities from this format

if you want to use replication, you MUST use Access Data Projects and
SQL Server.

 

[Tony Toews [MVP]]

if you want to use replication, you MUST use Access Data Projects and
SQL Server.

This is wrong.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[David W. Fenton]

=?Utf-8?B?QmVybmllIEhlcnBpbg==?= <Bernie
(e-mail address removed)> wrote in

I setup a briefcase that contains an Access 2007 database file.
When I made change to the DB in the briefcase and try to sync with
desktop, get an error message that briefcase can't sync file
because the database is not repicable.
How can I make it replicable?

ACCDB files do not support Jet replication -- it's available only
with MDBs.

That said, the Briefcase is a pile of crap and nobody should be
using it in the first place, particularly with Access/Jet databases.

 

[a a r o n . k e m p f]

Access 2007 (format) doesn't include replication.

That is 100% factual, kid

 

[Tony Toews [MVP]]

Access 2007 (format) doesn't include replication.

That is 100% factual, kid

Correct, ACCDB's don't support replication. However you're wrong in
that A2007 MDBs still do.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[a a r o n . k e m p f]

apparently you don't understand Access 2007 (format) doesn't include
replication.

 

[a a r o n . k e m p f]

Access 2007 (format) doesn't include replication.

 

[David W. Fenton]

"a a r o n . k e m p f @ g m a i l . c o m"



Correct, ACCDB's don't support replication. However you're wrong
in that A2007 MDBs still do.

He's wrong. MDB is a native format for A2007 and it supports
replication. The ACE supports replication. It's only the ACCDB
format that doesn't.

If Aaron writes it, it's 99% likely that it's wrong.

In the other 1%, it's probably misleading.

 

[a a r o n . k e m p f]

David;

go and spread your misinformation somewhere else.

This is perfectly factual, kid

Access 2007 (format) doesn't include replication.

-Aaron

 

[De Jager]

message
I thought that it was pretty clear, that when he says 'Access 2007
database file' that he's referring to ACCDB
basically.. Because jet replication was soo buggy and unreliable,
Microsoft removed Replication capabilities from this format

if you want to use replication, you MUST use Access Data Projects and
SQL Server.