Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access 2000 to develop db of product catalogs?

Status
Not open for further replies.

mds100

Technical User
Mar 9, 2001
5
US
Here is the scenario:
We have 1 copy of MS Access 2000. The boss wants me to create a searchable database of vendors' catalogs that we have shelved in our library. The design should be rather simple, create tables of product categories, supplier names, etc. with related interface forms. I am relatively new at Access, but feel comfortable with the table/query/form design aspects.
My question is this: We have 15 people in our office and all would like to be able to search the database from their own PCs over the LAN. Do each need a copy of Access to run this database application, or is there a way to distribute the application to all (replication maybe)? Keep in mind that this is a small database of maybe 500 entries (vendor catalogs) so I dont need a sophisticated SQL solution.

Thanks in advance.
 
MDS100,

You can use Access Runtime with replication manager. It will take very little set-up and work right across you network.

KB
 
Will this allow other users to use the database (forms, etc.) without installing MS Access locally on their computers?
 
Also,
Do I need the "Developer" version of MS Access, or is the runtime switch included with the std 2000 version?

Thanks in advance.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top