Database Security

[Edgarr8]

Hi,

I recently created a Database,

My backend in a shared network and also the front end, but i require every user to make a copy of the front end and paste it on their desktop before they use it.

The problem is that, depending who opens it, it react differently in my back-end.

For one of the users that opens the front end, it makes the back-end a read only.

other users it creates a laccdb file, which makes everyone elses front-end pretty slow

and finally of a user opens the original copy of the fornt end, the back end does not create the laccdb file..

I tried setting my "User-Level security Wizard" but its disabled...

any help or guidance would be great

thank you!

 

[boblarson]

The laccdb file is an IMPORTANT part of Access. It is the locking file which tracks who is in the database and all. It MUST be created when a user opens their frontend which then opens the backend. The laccdb file (ldb in previous versions) will be created in the same directory as the frontend file AND if a table is opened in the backend an laccdb file will be created there as well.

If a user does not have the proper permissions (Add/Delete/Edit) on the folder where the database file is located (both FE and BE) then it will not be able to create or delete the laccdb file as necessary. All users need those permissions.

If the laccdb file cannot be created, the database will be read-only.

 

[Edgarr8]

That You very much for the response, But how can i set all the permission and stuff?

 

[boblarson]

That You very much for the response, But how can i set all the permission and stuff?

Which permissions are YOU wanting to set?

The permissions on the server would be set by your IT folks, if you have them (your network administrator).

 

[Edgarr8]

Oh....ok, thank you

 

[Galaxiom]

You should also check out Auto FE Updater. Once set up it deals with the distribution of front ends entirely automatically. It installs the FE whereever you want and creates a desktop shortcut that not only runs the the FE but initiates updates automatically if they are available. It is free.

http://www.granite.ab.ca/access/autofe.htm

 

[bg3075]

I had the biggest problem trying to set a "Read-Only" group access to my database due to a make-table query that is fired (in a vba script) by the "Autoexec" macro (anything in a macro with this name fires when the database is opened, automatically. The reason I needed this to fire each time the database is opened is to keep the data in my main lookup-table fresh, as this is data used in many queries/forms in the database, and the data changes often. At first I set the Read-Only permission to this table at least to "Modify" the table. But, if I were to login with my Administrator/Owner login, and then again with a Read-Only login, it would drop the "Modify" permission to the table.
What I ended up doing, the only method I found that worked, was to give "Administer" access to the table being created each time by the make-table query, rather than just "Modify" permission. I also set the permission on the query to at least "Update Data" for the Read-Only group.