Replica Access & "Briefcase"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access database which is on the main office server and updated by
my office staff. I have recently dragged a copy of this file into the
"Briefcase" on my Laptop so that I can have a "more or Less" up to date
version with me when I am out of the office. When I did this I got a message
saying that it would need to create a "Replica".
I do not try to merge the databases, I merely tell it to replace the
"Briefcase" version with the updated version on the main server. I make no
changes to the Briefcase version, merely use it for reference.

I have noticed 2 problems:-
1) If a new Query is created in the server version it does not copy over to
the Briefcase version when I choose the replace option. All the forms in the
databases have green replice logos next to them apart from the newly created
queries.

2) My "Auto number" field, which is also my primary key, does not create a
consecutive number anymore. It now creates some sort of code which appears
87E+08 or 08E+09 or 1181206925.

Can you help please? Have I wrecked my database by copying into the
Briefcase feature?

Thank-you,
Ribcage
 
Access was never meant to be used with the Briefcase. I can't tell you if
you did any damage or not, but I would cease trying to do that from now on.
 
Access was never meant to be used with the Briefcase.
Click to expand...

Huh?

Since the Briefcase was introduced (in Win95), Access has supported
Briefcase replication *if* you install the support for it when you
install Access.
I can't tell you if
you did any damage or not, but I would cease trying to do that from
Click to expand...
now on

WHat *are* you talking about?

The database is not damaged. It's just replicated.

You can unreplicate it and then uninstall the Access Briefcase
Replication components and then the Briefcase will then treat the
database like any other type of data.

Here are links on unreplicating:

Sounds to me like you don't need replication at all.

* Access 2002 instructions (should work for A2003, too)
http://support.microsoft.com/kb/290052/

* Access 2000 instructions
http://support.microsoft.com/kb/208394/

There are two other tools that also work for Jet 4 databases:

* Michael Kaplan's TSI Un-Replicator Add-in
http://www.trigeminal.com/lang/1033/utility.asp?ItemID=7#7

* Graham Search's Unreplicate Utility
http://www.pacificdb.com.au/MVP/Code/UnReplicate.htm
 
Any particular reason why?
Click to expand...

Aaron Kempf is a troll, but in this case, his disagreement is
completely justified. Nothing you posted as an answer is correct
advice.
 
2) My "Auto number" field, which is also my primary key, does not
create a consecutive number anymore. It now creates some sort of
code which appears 87E+08 or 08E+09 or 1181206925.
Click to expand...

If you'll make this field wider, you'll see that these are very
large possitive and negative numbers.

This is to be expected -- it's how replication works.

See my reply to Lynn explaining what you should do to fix it.

You will have to replace the records with Autonumbers with new ones
as part of the incrementing sequence, though it shouldn't matter one
bit if your application is properly designed.
 
David,
I can't see your reply to Lynn.
What I would like to do is turn back the clock and remove the replication if
this is possible? None of the comments here seemed to have helped.
Can I or can I not use this application with Briefcase?

Ribcage
 
I can't see your reply to Lynn.
What I would like to do is turn back the clock and remove the
replication if this is possible? None of the comments here seemed
to have helped. Can I or can I not use this application with
Briefcase?
Click to expand...

Here are links on unreplicating:

Sounds to me like you don't need replication at all.

* Access 2002 instructions (should work for A2003, too)
http://support.microsoft.com/kb/290052/

* Access 2000 instructions
http://support.microsoft.com/kb/208394/

There are two other tools that also work for Jet 4 databases:

* Michael Kaplan's TSI Un-Replicator Add-in
http://www.trigeminal.com/lang/1033/utility.asp?ItemID=7#7

* Graham Search's Unreplicate Utility
http://www.pacificdb.com.au/MVP/Code/UnReplicate.htm

And if you uninstall the Access support for Briefcase replication,
it will treat your MDB as just a plain old data file, same as a Word
document.

So, unreplicate and uninstall Briefcase replication support from
Access and you'll be set.
 
Back
Top