Lee
Sorry to let this thread sit so long. I guess our friends in Europe and India are taking some time off.
Read/write is not enough. She has to have create/delete as well. When data is updated, added or deleted an LDB (Locking file) must be created. When all users are out of the database that file is killed. Without create/delete, she is for all intents in a Read-Only mode.
And you say you split the database. Each user has his own copy of the front end on his local drive, right?
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca
--- In MS_Access_Professionals@yahoogroups.com, "Lee" <leevt99@...> wrote:
>
> Hi,
> I have a split db with a 2003 back end. Some users have 2007 and others have 2003 for their front ends.
>
> One of the users (who has 2003 front end) is sending me screenshots of an Error 70 (Permission Denied) message. She is trying to run a series of queries that add/update data on a back end table.
>
> I wasn't able to find anything useful online, but I know this user can do this routine, because she uses another project I worked on that uses the exact same routine in it and she's never had any issues. All users on that project are on 2003, however.
>
> Does the versioning have anything to do with it? She has the correct windows permissions for read/write to the folders she's using. I am able to run the routine on my copy fine, using the exact file she was using, so that leads me to think that has nothing to do with it.
>
> Any ideas?
>
> Thanks
> -Lee
>
Tidak ada komentar:
Posting Komentar