View access DB on an intranet?

Benson112

Registered User.
Local time
Today, 11:50
Joined
Apr 17, 2008
Messages
21
Hi All,

I was wondering if it is possible to display my access 2000 DB on our intranet site or a website of any description? If so what would I have to do?

Also, would there be any issues with multiple people running the reports at the same time? At the minute if somebody else is in the DB, i cant open it!
 
Access has some limitations when it comes to a multi-user environment. You should look at splitting your database into a Front-End which has your forms, queries, reports and code, and then a backend which has your tables. The Front End should be hosted locally on each user's machine. This should alleviate the currrent problem your getting with being locked out.

If you are serious about hosting a database on a webserver then you might look at a solution other than access. Access CAN be utilized on the web but there are far better database solutions, SQL Server or MySQL to name a couple.
 

Users who are viewing this thread

Back
Top Bottom