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

Remote database

P: n/a
Dear Gurus,

we have 3 branches in variuos locations say various city. they are
linked as VPN, WAN...you can say internal LAN.

we wanted to developed a centeralised database where all users from
branches enter at a single locations.
I need to know 2scenerio solutions
- if v have single db and all remote users accessing, what method, and
if we make web pages in as or access web page does this helps, can v
print report queries from web access page?
- if v have 3 various locations database, and wanted to data come as
batch at the end of day so how will it process
any ideas will be appreciated

thanks and regards
shahzad

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


P: n/a
You don't mention if you are familiar with using a split database (you
should be).

However, a split system over a wan will not work.
can v
print report queries from web access page?


You can certanly build and make sql queries on your web server, but you
don't use ms-acce3ss for this. (so, no, the ms-access reports can't be used
on your web server).

You can read up about using ms-access on a wan here:
http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.attcanada.net/~kallal.msn
Nov 13 '05 #2

P: n/a
Thanks for reply i will check this.

But we can do in alternate way by using copyobject, transferdatabase,

can you also further tell me if i want to run a file batch how can i do
this? say i made bkup_access.bat it will run evening time 11.00pm, it
will load access , and in access VBA module by default loading the
script will start running and start transfering data from one VPN
branch to other. any ideas...or say we want to copy only that records
that has got modifed as of today...so on daily basis the record willl
copy and db either side will be update

but there r 2 scenerio in this one is real time, soon the record insert
should update, then 2nd is on batch process as i mention above this
will update at the end of the business day
any suggestions, any experience welcome to discuss

rgds
shahzad

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.