G
Guest
I am tryiing to create one access data base that is link to 11 different
access databases. houw can I design one database for all 11 sites?
access databases. houw can I design one database for all 11 sites?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John Vinson
On Mon, 6 Feb 2006 06:00:34 -0800, "Creating one Master access
database" <Creating one Master access
Where are these sites? Out on the internet, or on a Wide Area Network?
Access is *very* demanding on network resources, and the usual local
technique of File... Get External Data... Link is not recommended.
Depending on the nature of the linkage that you need, you may want to
consider a web-based solution with either Access or SQL/Server (the
free version included as MSDE on your Access installation) as the data
storage medium. Or, if the databases are mainly site-specific but need
to be kept in synch periodically, consider using Replication (get the
Replication whitepaper from http://support.microsoft.com and study it
carefully).
John W. Vinson[MVP]
database" <Creating one Master access
I am tryiing to create one access data base that is link to 11 different
access databases. houw can I design one database for all 11 sites?
Where are these sites? Out on the internet, or on a Wide Area Network?
Access is *very* demanding on network resources, and the usual local
technique of File... Get External Data... Link is not recommended.
Depending on the nature of the linkage that you need, you may want to
consider a web-based solution with either Access or SQL/Server (the
free version included as MSDE on your Access installation) as the data
storage medium. Or, if the databases are mainly site-specific but need
to be kept in synch periodically, consider using Replication (get the
Replication whitepaper from http://support.microsoft.com and study it
carefully).
John W. Vinson[MVP]