Email Update

bluwind

Registered User.
Local time
Yesterday, 18:33
Joined
Mar 20, 2008
Messages
26
o.k i have been given the task at work to implement a new database system, the trouble is we have 3 different departments spread throughout the city and the only means of electronic communication we have is via email.
we will all be adding to the database seperatly of each other. What i was after was if both sub teams send me there database via email, is there a way i can electronicly merge all the new data. The database at each site is fully featured 20+ tables with multiple forms.

and after the merge i will reply to emails with fully upto date database
 
Sounds like a recipe for disaster, but, if that is really how you are going to do it, have you looked into replication? I don't really know anything about it, but I have heard of it being used to synchronize multiple copies of the same database . . .
 
Sorry i need to close this thread now.
I went back to the managers today and managed to get extra funding to have the database hosted on a server :), so we can all link to the same server.....wooo hooo
 
if you are on a wan, rather than a lan, (ie not in same building) you will still have problems using access

you probably want to consider connecting to server with remote desktop, but then you need to check your server licensing for sufficient logins

ask here for general info about alternatives- out of my league a bit
 

Users who are viewing this thread

Back
Top Bottom