online database ??

[pungentSapling]

I have a database for service and Maintenance requests. It is a very simple db.

It lives on a shared folder on the intranet.
It has a hyperlink that points to it from the company intranet homepage.

problem:
When you click on the link the network will not allow the user to open the database from the folder where it is stored. They have to download it to their own pc in order to use it.

I linked the main table to another "Main" copy of the db so the data is not staying on the users pc....but this situation is not ideal.

it is access 97
any suggestions?

 

[The_Doc_Man]

When you have a shared database, you need certain permissions on the remote folder because of the .LDB file requirements. Check with your network administrator to verify that all such requirements are met.

On Novell systems with AC97, we found that we needed rights on the file and the directory as noted:

File Scan - to find the .MDB file and some associated documentation files we kept in that directory.

Read - (obviously) to read the .MDB file

Write - (obviously) to extend files by insertion.

Modify - (obviously) to modify the contents of the .MDB file by updating, appending, or deleting records

CREATE - because the first person to use the .MBD file has to be able to create the lock file, .LDB

ERASE - because the last person to leave the .MDB file has to be able to delete the lock file, .LDB

Sounds to me like you have READ but not enough of the others. To make your network person happy, you probably should move the database to an isolated directory used for no other purpose so that proper security can be maintained.

 

[pungentSapling]

thankyou for the input.
I am working with the network guy on a good solution.

thanks again
p.