Access - SQL Replication

Hi,
I have an Access database that has been replicated over an intranet.
It is a fairly simple database - it has people working on it online and people who work offline and sync into it.
Now we need to sync over the internet.
I enquired in these discussion groups and was adviced to Upsize my database in order to be able to use MS SQL server hosting it at my ISP.
I have upsized the access database from within access 2000.
What do I do next ? How do I put that on to my ISP MS Sql Server?
Do I need to reformat stuff.
I am completely new to sql server. I have programmed MySql and PHP though.
CHEERS
Paula,
I'd advise you to set up replication internally first. There are plenty of
details on the replication setup routines in BOL, but if you describe the
articles involved and if the subscribers are updatable etc - the general
business case - then I'd be better placed to recommend a particlular setup.
Once you have it working internally and understand the security setup and
roles of the various agents then you can contact a hosting provider. There
will be a lot of configuration questions with the provider and it would
probably be much easier if you host it locally, but there are providers who
do offer the service. However, when I looked into it for a recent poster,
the hosting providers seemed to only offer hosting as a subscriber, for
security purposes (eg http://www.1stchoiceinternational.com).
HTH,
Paul Ibison
|||If I am going to implement it internally - would then users conect to the central DB through FTP you mean?
Sorry my english is not good.
Can I just do this with Access Replication then?
"Paul Ibison" wrote:

> Paula,
> I'd advise you to set up replication internally first. There are plenty of
> details on the replication setup routines in BOL, but if you describe the
> articles involved and if the subscribers are updatable etc - the general
> business case - then I'd be better placed to recommend a particlular setup.
> Once you have it working internally and understand the security setup and
> roles of the various agents then you can contact a hosting provider. There
> will be a lot of configuration questions with the provider and it would
> probably be much easier if you host it locally, but there are providers who
> do offer the service. However, when I looked into it for a recent poster,
> the hosting providers seemed to only offer hosting as a subscriber, for
> security purposes (eg http://www.1stchoiceinternational.com).
> HTH,
> Paul Ibison
>
>
|||Paula,
if it's entirely internal, then there's no need for FTP. FTP is used for the
initiation process when replication is carried out across the internet or
non-trusted domains. If you're all on the same domain, then the normal
fileshare method of initialization is fine.
I am not familiar with Access replication so if you need advice on how it is
set up you're best bet is to post in the dedicated access group.
HTH,
Paul Ibison