How do I format and update Access on an Intranet?

[beeorlando]

I've been using Access for a few years but I've never put a database on an Intranet before and I'm a bit perplexed how to do it.

Here's what I'd like to do:

I created a form from which users can search & view reports generated from the database -- but they can't do anything else (like get to the data and change it). If I publish this form to the intranet as an .htm file, can it be linked to the database so that as we make changes they will be reflected in the reports? Or, do we have to physically update the database on the intranet every day?

Any help would be much appreciated!

 

[BanditWk]

How we do it in my company is put the Data tables in backend databases. Then, have a front-end database that has nothing but linked tables to the backend database tables. For instance:

FrontEnd.mdb would have all your queries, macros, reports, etc pointing to all the needed tables. The tables would be linked to the BackEnd.mdb. NOTE: If you use network addressing, it slows down the database tremendously. Try running the Front-end and Backend on the same server so that when you link, you're linking to "C:\Data\backend.mdb" instead of "\\128.9.9.9\Data\backend.mdb"

BackEnd.mdb would have the actual tables.

HTH
Roy
aka BanditWk
Las Vegas, NV
roy@cccamerica.org
RLMBandit@aol.com (private)