[AccessD] Replicated .mdb and SQL Server

Barbara Ryan BarbaraRyan at cox.net
Wed Mar 30 16:21:17 CST 2005


Regarding "Do you plan on running replicated SQL server or updating via the
internet and SQL Server?"

---- I don't know!  I know very little about SQL Server.  I am open to any
suggestions on how I can handle this situation (i.e.,  the Access
application (front end) is linked to 2 separate back end .mdbs.  Backend "A"
contains the majority of the data tables for the application; Backend "B" is
a replicable database that is also used as the sole backend database for
another Access application that is used by salesmen on their laptops.   The
front end contains some queries that currently join tables from both Backend
"A" AND Backend "B".)

Could the salesmen use an Access backend and somehow synchronize it with a
SQL Server database?

Thanks,
Barb Ryan



----- Original Message ----- 
From: "MartyConnelly" <martyconnelly at shaw.ca>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, March 30, 2005 5:10 PM
Subject: Re: [AccessD] Replicated .mdb and SQL Server


> I don't know if the Access to SQL upgrade wizard handles replicated
> databases but here is an unreplicator just in case
> http://www.trigeminal.com/lang/1033/utility.asp?ItemID=7#7
> Do you plan on running replicated SQL server or updating via the
> internet and SQL Server?
>
> Barbara Ryan wrote:
>
> >I currently have an Access application, split into a front end linked to
2 separate back end .mdbs.  Backend "A" contains the majority of the data
tables for the application; Backend "B" is a replicable database that is
also used as the backend database for another Access application that is
used by salesmen on their laptops.
> >
> >The client is considering migrating the data for this application to SQL
Server.  Any ideas on how to handle this?  The front end contains some
queries that currently join tables from both Backend "A" AND Backend "B".
> >
> >Thanks,
> >Barb Ryan
> >
> >
>
> -- 
> Marty Connelly
> Victoria, B.C.
> Canada
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com




More information about the AccessD mailing list