sharing database

[armin]

I want different users to be able to open my database at the same time. My database is on our network server. The users will be accessing the database through data access pages to add, delete or edit the data. But I'm running into problems here. When I try to open the DAP from the different computer which is still on our server it gives me an error, saying "Microsoft Office Web Components could not open the database" followed by the path to the database. It thinks that the DB is on the computer that I'm accessing it from.

Is there a way to fix this?
Thanks.

 

[Autoeng]

Please detail how are your trying to access the DAP's?

 

[armin]

I installed Tomcat server on one of our computers on the network and the DB is on that server. Also, all the DAP's are in the same folder (on Tomcat). It works fine when I open them on that computer. In order to access them from a different computer I open the browser, on that computer and type in the IP address of the server where the database is located. Normally this is how you access files on other computers.
Do you know if it is possible to open DAP's the same way (via Internet)?

Thanks

 

[mission2java_78]

I installed Tomcat server on one of our computers on the network and the DB is on that server. Also, all the DAP's are in the same folder (on Tomcat). It works fine when I open them on that computer. In order to access them from a different computer I open the browser, on that computer and type in the IP address of the server where the database is located. Normally this is how you access files on other computers.
Do you know if it is possible to open DAP's the same way (via Internet)?

Thanks

what's a dap? data access page? if so that was your first mistake .
just kidding..check security privelages...this sounds like a problem of the actual db / the dap's rights to end users.

Make sure you have this on a shared folder on your web server and users have read write exec privelages.

 

[armin]

Actually, this involves sharing database objects and DAP's (Data Access Pages) on the internet. It has nothing to do with the local network.
For example, can DBs at work be accessed from a home computer through data access pages?

 

[mission2java_78]

Actually, this involves sharing database objects and DAP's (Data Access Pages) on the internet. It has nothing to do with the local network.
For example, can DBs at work be accessed from a home computer through data access pages?

Yes, the whole point of data access pages is providing a means of accessing the db in an asp / php style...meaning web enabled. I think Access isnt the best tool for this..one reason I shy away from using DAP. I dont like the way the pages look because most of it becomes bloated HTML anyhow. But yes if you're asking can data be sent to a db via a web page, one made in DAP, then the question is yes. If you're asking can you access the db entirely just to do work on it from home..then this is possible through a VPN (virtual private network), this is basically a tunnelling system which encrypts your packets through to your destination (your office). Its supposedly very secure in that the encryption can only be translated by your client machine and the machine or black box at your destination.

Jon

 

[armin]

Yes, the whole point of data access pages is providing a means of accessing the db in an asp / php style...meaning web enabled. I think Access isnt the best tool for this..one reason I shy away from using DAP. I dont like the way the pages look because most of it becomes bloated HTML anyhow. But yes if you're asking can data be sent to a db via a web page, one made in DAP, then the question is yes. If you're asking can you access the db entirely just to do work on it from home..then this is possible through a VPN (virtual private network), this is basically a tunnelling system which encrypts your packets through to your destination (your office). Its supposedly very secure in that the encryption can only be translated by your client machine and the machine or black box at your destination.

Jon

Thanks, I'll look into that.