David W. Fenton wrote:
[Quoted Text] >> 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.
>
Thank you David
How do I look at the SQL. I have looked around to try and figure it out with
no success.
--
Message posted via http://www.accessmonster.com
|