Microsoft Office Tutorials and References
In Depth Information
Putting Your Database Where People Can See It
This chapter describes the first method: setting up a database so that more
than one person can open it at the same time, using computers that connect
to a LAN.
Putting Your Database Where People Can See It
For other people on a LAN to be able to open your Access database, you
need to store it in a shared folder — a share, for short. The shared folder can
be on your computer or on a file server — a computer whose primary job is
storing files for use over the LAN. If you work in an organization, check with
your LAN administrator to find out the best place to store your database.
If you decide to store the database on your own computer, you need to share
the folder with other people. On the Start screen, type explorer in the Search
box and then choose File Explorer from the menu that appears. Next, find or
create the folder where you plan to store the database. Here’s how to share
a folder on your LAN, depending on which version of Windows you use:
Windows XP: Put the database in a folder inside the Shared Documents
folder.
Alternatively, to configure any folder as shared, right-click the folder in
Windows Explorer and choose Sharing and Security from the contextual
menu. On the Sharing tab of the Properties dialog box that appears,
click the Share This Folder option, and give the folder a name, which will
appear on other users’ computers. Click the Permissions button to set
whether other people can only read files in the folder or also edit them.
Then click OK in both dialog boxes to close them.
Windows Vista: Put the database in a folder inside the Public folder.
Windows 7: In Windows Explorer, click the folder name. Choose Share
With from the menu that appears; then choose Homegroup (Read),
Homegroup (Read/Write), or Specific People.
Windows 8: In File Explorer, right-click the folder name and choose
Share With from the contextual menu; then choose Homegroup (View),
Homegroup (Read/Write), ASP.NET Machine Account, or specific people.
You can tell whether a folder is shared by right-clicking it and choosing
Properties from the contextual menu. Click the Sharing tab of the Properties
dialog box to see the sharing status of the folder.
If you store a shared database on your computer, everyone else depends
on the stability and speed of your computer. If you restart Windows after
installing the latest update to your favorite game of solitaire, everyone else
loses the edits they make to the database. If you decide to run a big, hairy
application that slows your computer to a crawl, the other computers that
are using the database on your computer crawl too. If your database is
Search JabSto ::




Custom Search