By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,104 Members | 1,063 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,104 IT Pros & Developers. It's quick & easy.

replicate Frontend MDB to Backend Database

P: n/a
I have a football school mdb used at the following locations:
1. office
2. home of owner
3. training fields

Once a day (eg morning) all mdbs must be replicated.
Since none of the pcs is online all the time, I thought to store the
data on the company's webserver (hosted by a 3rd party and has asp.net
and MSSQL) , and all pcs should sync with the database on the
webserver.

I think that if I want to have an mdb on the server in order to use
internet replication, then I must have Replication Manager (coming with
MS Office Developer Edition ) on the server . I think I cannot do that
as I have no control to the software that can be installed on the
webserver (as far as I know)

Since the webserver has MSSQL I thought to put the data in it.
So the question is: How can an MDB replicate with MSSQL ?
(The host of the webserver provides Enterprise Manager access to me.)

Or, is there a way to have the central mdb on the webserver without
having to install replication manager ?

Thx

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

interuser wrote:
I have a football school mdb used at the following locations:
1. office
2. home of owner
3. training fields

Once a day (eg morning) all mdbs must be replicated.
Since none of the pcs is online all the time, I thought to store the
data on the company's webserver (hosted by a 3rd party and has asp.net and MSSQL) , and all pcs should sync with the database on the
webserver.

I think that if I want to have an mdb on the server in order to use
internet replication, then I must have Replication Manager (coming with MS Office Developer Edition ) on the server . I think I cannot do that as I have no control to the software that can be installed on the
webserver (as far as I know)

Since the webserver has MSSQL I thought to put the data in it.
So the question is: How can an MDB replicate with MSSQL ?
(The host of the webserver provides Enterprise Manager access to me.)

Or, is there a way to have the central mdb on the webserver without
having to install replication manager ?

Thx


Anyone can provide an answer please ?
Thx

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.