> 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/