Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Replication / September 2006

Tip: Looking for answers? Try searching our database.

briefcase replication

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tyriso - 15 Sep 2006 15:28 GMT
I am in the process of doing a Briefcase replication as I have no experience
with access. We are using Access 2000. I replicate the back end to the
briefcase and leave the master alone. It seems
to replicate fine. The problem is how do I get the forms to work. I take the
laptop off the network and the forms open but I can't open the queries. It
says disk error. I know I am getting this error as I do not know what I am
doing. Good thing I have back ups. I am using briefcase because it is a very
small database and I am not skilled enough to do it the correct way.

Thanks in Advance
David W. Fenton - 15 Sep 2006 22:34 GMT
> I am in the process of doing a Briefcase replication as I have no
> experience with access. We are using Access 2000. I replicate the
[quoted text clipped - 5 lines]
> ups. I am using briefcase because it is a very small database and
> I am not skilled enough to do it the correct way.

Is this a split database? That is, does the front end point to
tables in a different MDB? If so, you need to have them in exactly
the same location on the laptop as when connected to the network.
That means they can't be on the network.

In any event, it's a bad idea to replicate forms/reports/etc., as
they are Access objects, and Jet replication works well only with
pure Jet objects (tables/queries).

I have never used briefcase replication as it has always seemed a
poor stepchild to real replication, and not programmable, so I have
no experience with it. But the problem you are having doesn't appear
to me to be specific to the briefcase. Indeed, it doesn't seem like
a replicatoin problem at all. It is more likely that a path to the
server is hardwired into some of the queries. If you look at the SQL
of them you might see that the from clause ends in "IN
'\\server\share\some.mdb'", and if so, that means the query is
hardwired to a server data source, and you won't ever be able to use
it except connected to the LAN that has access to that server.

Signature

David W. Fenton                  http://www.dfenton.com/
usenet at dfenton dot com    http://www.dfenton.com/DFA/

Tyriso - 18 Sep 2006 15:14 GMT
>> I am in the process of doing a Briefcase replication as I have no
>> experience with access. We are using Access 2000. I replicate the
[quoted text clipped - 21 lines]
>hardwired to a server data source, and you won't ever be able to use
>it except connected to the LAN that has access to that server.

Thank you David
How do I look at the SQL. I have looked around to try and figure it out with
no success.
David W. Fenton - 18 Sep 2006 22:27 GMT
>>> I am in the process of doing a Briefcase replication as I have
>>> no experience with access. We are using Access 2000. I replicate
[quoted text clipped - 25 lines]
> How do I look at the SQL. I have looked around to try and figure
> it out with no success.

Open any the queries that are throwing the error in Design View.
Switch to SQL View on the View menu.

Or, open the query in design view and view the query's properties.
The string I described above would appear in the Source Database
property.

Signature

David W. Fenton                  http://www.dfenton.com/
usenet at dfenton dot com    http://www.dfenton.com/DFA/

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.