Here is my situation. There are 6 of us using a split database. The database is located on our server in a folder, from there it is split into to more folders. Folder one is the client file folder containing the client file (The nav and reports etc.) the second folder is the database (containing multiple tables with the data we enter from the forms in the client file). Things have been working great until recently our financial controler has just started using the database and our data has begun to disappear. Just so no one asks, yes it is because of her, the entire team has witnessed it at some point or the other, she highlights and copies but doesn't pay attention to what she is doing and cuts or deletes data out of the forms while going through the files. I created queries for her with all the data but she wont use them because it and I quote, "doesn't look as pretty as the form and she prefers the form view." Our boss has told her to use them and she still doesn't even though she says she is, I know she isn't becuase our data continues to be deleted. My solution would be to fire her as access and excel do her job for us but thats another story.
What I want to do is create another client file solely for her that only gives her the option of the queries and nothing else, strictly read access no write. Is this possible or is there another way to do this? Do I have to create a user login is that the only way?
Bookmarks