MS Acess

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

Guest

Hi everyone

need some help solving some replication problems
I have an acess database that has a front end and a back end
I have replicas of the back end running on PC that are not in a network - every 2 days they are sync. with the main replica to update
I now want to have them do the sync. through the internet - and have my main back end in a server on a 3rd. party ISP
How can I do this - I uderstand I should migrate to SQL server
Can I do that when I already have replicas that have been updated in Access
Where can I find information on how export the access to SQL Server? or do I have to start from scratch
Can I still use my standard front end in access ? HOw

Thnks!

PAula
 
Paula,
assuming you have Access v2000 or greater, you can have a Jet or SQL Server
MSDE backend. To change from Jet to MSDE, there is an Access Upsizing
Wizard. Once in MSDE, you can use the standard Access frontend, and can use
merge replication to synchronize the various databases.
For Access data storage:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acmsdeop.asp
For MSDE restrictions on replication:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q324992#2
For replication across the internet: http://support.microsoft.com/?id=321822
HTH,
Paul Ibison
 
Back
Top