Solved Need help with a new user that can't enter data (1 Viewer)

[oxicottin]

Hello, I have a database that has a front end and back end, and I distribute an .accde to each user and if I haven't before I change the "Trusted Locations" so it isn't a read only etc. and this has always worked over the years. Recently I have a new employee that needed access to the MS Access program I made so I gave her a .accde file and changed her trusted locations and its subfolders to always allow etc. like I have always done.

Now when I open the DB on her PC everything works just fine EXCEPT, she can't enter anything, it won't allow her to enter data whatsoever. I log into the PC and do the same thing, and it works perfectly fine. I have other employees that use the program open it on that PC and it works just fine.... I don't get it?

Any ideas?

 

[theDBguy]

Did you implement any form of user level security at all?

 

[oxicottin]

Did you implement any form of user level security at all?

Yes, but It allows anyone to use except for a few selections on the switchboard for me. I have been using it that way for over two years with new users all the time with no issues. It did say when she first opened it, it had that Read-Only banner, but I changed the trusted locations, and it went away.

 

[cheekybuddha]

Does your new user have read/write permissions on the backend folder too?

 

[oxicottin]

Does your new user have read/write permissions on the backend folder too?

Not sure how to check that. I always give them thier accde and tell them keep it on thier desktop and when i do the trusted locations i just trust the location that the backend is on and thier desktop and it always works

 

[cheekybuddha]

Not sure how to check that.

Others will have to guide you better than I am able to, since I'm not really up to speed with Windows networking.

If your user right-clicks the back-end folder in Windows Explorer and chooses 'Properties', then looks at the Security tab, it should show the permissions the user has for that folder.

It may require a network admin to modify the permissions if necessary.

 

[arnelgp]

if you already give full access grant to user Everyone to the backend folder, what else then?

 

[The_Doc_Man]

David's advice is correct, but perhaps could be more directed. From your problem user's computer, don't click on the folder. Right-Click on the back-end file >> Properties >> Security then highlight the person's login name in the list of users having permissions. If your user doesn't have MODIFY (or FULL CONTROL) then you might have problems for that user.

Note that depending on how you browse around, you would find not 6 levels of access but T/F for 22 individual fine-control permissions. MODIFY is just the name of a high-level GROUP of permissions that includes things like "Traverse Folder" "Read" "Read Properties" "Write" "Create" "Delete" etc... some of them (like Create) making sense only on folders, others making sense on individual files.

 

[Solo712]

.....she can't enter anything, it won't allow her to enter data whatsoever.

Do you mean she can't enter data in the form or she cannot save data into the database? Next thing: can she display data?

Jiri

 

[DHookom]

To test back-end folder permissions, I asked users to right click in the folder and select New->Text Document. Have them both save and delete the new text file.

 

[oxicottin]

Ok I found the issue... My admin messed up on permissions, its fixed now! Thanks all for your help!

 

[oxicottin]

To test back-end folder permissions, I asked users to right click in the folder and select New->Text Document. Have them both save and delete the new text file.
View attachment 116762

I'll keep that in mind next time... Thats a good indicator to show if there are read/write permissions!

 

[gemma-the-husky]

Every day is a learning day. It's a shame it can sometimes take a while to understand the real reason for a problem.

 

[cheekybuddha]

I change the "Trusted Locations" so it isn't a read only etc. and this has always worked over the years.

This, I guess, is where the misunderstanding occurs.

Adding a Trusted location only means that Access will allow running db's from that location.

It doesn't do anything about actual file/folder permissions for a user on the network level - that is a separate set of permissions.

 

[gemma-the-husky]

If you don't set the trusted flag, you get asked whether you want to open the database each time. I imagine this is there to prevent malware databases opening without approval.