Public input data to Database on restricted private drive

[treva26]

Is it possible to have a form that is accesible by everyone on my Network, that adds data to a database that is on a drive that most people dont have permission to access?

If not, what other ways around it are there?



Maybe I could put the database on a public drive but have a password to open it properly, but no password for the public form?
I'd prefer another way though so I dont need to keep inputting the password.

 

[Banana]

Based on what I know, if you want to allow your users to modify data, they *must* have full read/write permissions for the Windows directory backend is in or they'll go nowhere. You can use Windows security to block off non-users but you can't limit users' permissions, even if they are supposed to view/modify only certain kind of data. That has to be done within Access security model.

 

[mdb4me]

Maybe you could setup the application so the users logon to the frontend and it uses a special account that has been setup with appropriate permissions to access the backend to read and write data that the users know nothing about.