Data Access Pages

[rboggess]

I'm a novice when it comes to Access 2000 but one of the features that the newest version has is "Data Access Pages." I created such a database and DAP, posted it to this site and tried to access it. I got the following message "Safety settings on this machine prohibit accessing a data source on another domain"

What I'm trying to figure out is this message the result of my machine or the host on which the web site resides (www.cfdmat.org - on FutureQuest).

One of the problems the organization is having is a centralized database with adminstration scattered throughout central florida. It would be nice to at least have a database posted at one server site and be able to access and make changes to by a select group of individuals. I had hoped that Access 200 with its DAP would do that.

Any answers, comments or suggestions would be greatly appreciated.

Thanks,
Bob

[Terra]

While I haven't worked with Access 2000, I do however understand what you are trying to do...

This would necessitate a dedicated server, running an SQL daemon to where your various offices had permissions/rights to access it at one core...

From a MySQL standpoint, this is controlled by the 'GRANT' tables, and can be setup to allow from various network masks and username/password combinations...

The only downfall of MySQL for this type of scheme, is that it has no automatic 'Replication'...  With pilot offices accessing a core database, it's usually best to not put all your eggs in one basket and have several points of SQL access in case one of the engines goes down...  However, you can program your own 'Replication' functions that handles this in the background...

I would highly recommend contracting a professional SQL Consultant that can help design this setup as it will quickly become complex in underlying nature...

--
Terra
--Watching the trend of dedicated servers coming to the forefront--
FutureQuest

[rboggess]

Thanks for your prompt reply.

I was really looking for a way for individuals to access the database, update and add records, etc., over an internet connection. MySQL may fill the needs but I don't know enough about it to make an intelligent decision.

Again, thanks for your assistance.

Bob