Is the briefcase available in access 2007?

[dave from victoria]

Is the briefcase or pack and go feature available in access 2007? If not, is
there a way to add/delete/edit records in a database on a home computer, then
synchronize those changes to the main copy of the database at the office?

 

[Arvin Meyer [MVP]]

There is no Replication in Access 2007, but it should continue to work if
you use an earlier format and open it in Access 2007.

 

[Maurice]

The focus is really on using SharePoint here. That's where you can do the
'offline' and synchronisation. But if you are looking for the 'old' briefcase
that's gone.

The problem is really that not everyone (yep they are still out there ;-)
uses sharepoint.

 

[Arvin Meyer [MVP]]

Other than updating a list, Sharepoint won't always work. Sharepoint does
not support Referential Integrity, and current versions are slow,
particularly on lists of more than 2000 records. Also Sharepoint is not an
off-line tool. It requires a connection to the Internet or other network to
synchronize. If an Internet connection is present, one can use Terminal
Services to quickly update a database with an update query much faster than
by synchronizing Sharepoint, and a LAN can always be used for the same
purpose. Why add yet another complete structure, when one only needs an
update and/or an append query?

 

[David W. Fenton]

There is no Replication in Access 2007, but it should continue to
work if you use an earlier format and open it in Access 2007.

This is JUST NOT TRUE.

There is no replication for ACCDB format.

But replication still works in A2K7 for MDBs.

 

[David W. Fenton]

But if you are looking for the 'old' briefcase
that's gone.

It's gone from Windows, but replication is still supported in A2K7
for MDBs.

Briefcase replication never really worked well with Access, in any
event.

 

[Maurice]

Very much true and that was one of the points during the beta I put to
discussion. Why going to sharepoint if you would have to create a db which
will never be properly normalized. Answer was that the majority of the people
will not program a database and merely use it as a user out of the box.

Ok so I won't be using that feature very much to much hassle. Let's stick to
the 'normal' solutions...
--
Maurice Ausum

Other than updating a list, Sharepoint won't always work. Sharepoint does
not support Referential Integrity, and current versions are slow,
particularly on lists of more than 2000 records. Also Sharepoint is not an
off-line tool. It requires a connection to the Internet or other network to
synchronize. If an Internet connection is present, one can use Terminal
Services to quickly update a database with an update query much faster than
by synchronizing Sharepoint, and a LAN can always be used for the same
purpose. Why add yet another complete structure, when one only needs an
update and/or an append query?
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Arvin Meyer [MVP]]

David, read what I said again:

An earlier format would be an MDB.

 

[David W. Fenton]

David, read what I said again:

An earlier format would be an MDB.

The two parts of your statement are mutually contradictory. A2K7
*does* do replication if you use MDB. That is not what "There is no
Replication in Access 2007" means.