Sharing a Access Database

[Steve White]

We have a Windows Small Business 2003 Server along with our 11 Windows XP
Pro workstations. Only one of the workstations has Office 2003 that includes
Access 2003 and the user has created a basic Database with 1 set of Tables.
What would be the best option for sharing out this database to the rest of
the 10 users?. The other users only really need read -only access to the
database. I'm looking into the possibilites of incorporating the database
in SBS 2003 Sharepoint unless there are easier options.

thanks!

 

[Ken Snell \(MVP\)]

Not many options:

1) Buy Visual Studio Tools for Office 2003 in order to purchase the runtime
license for ACCESS, which will allow you to create runtime versions of
ACCESS on all other users' PCs and then they can open the database (needed
even if just read-only is the intended use).

2) Create a Data Access Page (warning: DAPs are nothing like forms or
reports!) that will display the information that you seek. Put the database
on a web server (or internal server), and let users use Internet Explorer to
open and view those DAPs (data access pages).

3) Use Sharepoint option.

 

[John Spencer]

Don't forget that you can do some sharing (reading of data) using
spreadsheets and querying the database that way. It depends on your needs
and the structure of the database.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..