Access and Replication

[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

 

[Lynn Trapp]

Paula,
You will probably get a better answer if you post this question in
microsoft.public.access.replication

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

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>