473,385 Members | 1,742 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

replicate Frontend MDB to Backend Database

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
1 1615

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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: w | last post by:
Hello all!!! For a year and a half now, we have been developing different Access 2000 applications. Most of them are access frontend and access backends. Some of them have SQL server 2000 as a...
1
by: matt bourke | last post by:
Hi, Can you please tell me what the advantage is of using an access backend with a VB frontend OVER access as a frontend and backend. M
10
by: Squirrel | last post by:
I posted a question a couple of days ago about running different versions of Access for the frontend versus the backend databases. Got some good advice but now I've received this information: ...
16
by: Wayne Aprato | last post by:
I have several Access 97 databases which are split into front end and back end running off a server. The front end mde is shared by 2 or 3 - absolute maximum of 6 concurrent users. This scenario...
3
by: DD | last post by:
Hi I have a split database, that is packaged and used in a runtime enviroment. I want to make it easier for the user, a button on the frontend "Export Backend" They can click on the button...
2
by: Sukkel | last post by:
When I define relations in the Backend of my Database, everything works fine. I get these funny lines (with 1 and "OO") between the fields of the different table that indicate a one to many...
42
by: PC Datasheet | last post by:
I have zero experience with using a SQL database for a backend and Access for a frontend. I have some questions: 1. Does an SQL database have tables? 2. How does Access connect to the data in...
9
by: philelpko | last post by:
Good Morning all, Lost once again which is becoming a common occurance atm. My database has successfully been broken into a frontend and a backend db. A problem has now arisen as it has become...
0
by: John Kirkpatrick | last post by:
Hi all, I am having difficulty displaying records on a frontend MS Access 2000 form using a MySQL backend. The following code works well with the Jet database engine but doesn't work properly...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.