Share data

J

jeff

I have a database that I will like to share in a network configuration. What
is the best and easy way to share the same data?
 
J

Jeff Boyce

Jeff

"network configuration" can mean so many things. What do you mean by it?

For example, some folks consider a Wide Area Network (WAN) to be a network
(?!) But Access front-end and back-end configuration doesn't work well over
a WAN.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
J

John W. Vinson

I have a database that I will like to share in a network configuration. What
is the best and easy way to share the same data?
Click to expand...

On a fast, stable Local Area Network, use a "split" database - a shared
backend containing nothing but tables, and each user with a frontend
containing the forms, reports, queries etc. See
http://www.granite.ab.ca/access/splitapp.htm for a detailed overview.

On a wide area (remote) network, you may need to use a terminal server
application such as Windows Terminal Server or Citrix - Access doesn't "play
nice" over a WAN. Alternatively you could store the data in SQL/Server and
revise your database to link to the SQL tables. There's a page on Tony's
website above about issues with upsizing to SQL.

John W. Vinson [MVP]
 
Top