OK so much for this theory. I went to her desk and watched her create the file she's trying to import, it goes right to her C: drive, she has full read/write permissions to the file, full read/write permissions to all folders involved. I'm stumped.
--- In MS_Access_Professionals@yahoogroups.com, "Lee" <leevt99@...> wrote:
>
> Hi,
> The user has full rights to the folder containing the back end. I just double checked effective permissions to make sure.
>
> Now that I type that I just thought of something... it might not be the access file... it could be the excel file. If it gets sent to a folder where she has read only permissions, and she click/drags it to another folder, it would retain the read only permissions, even if it's in a folder she has read/write to. She emailed me the file to test it and I was able to import it right away, she has had access version issues in the past so I thought it might be something similar. Part of the import routine modifies the excel file to get rid of some formatting before import.
>
> And yes each user has a local front end mde file that connects to a shared back end. =)
>
> Thanks
> -Lee
>
> Tip of the day: don't click/drag network files, copy/paste or the file will retain the permissions of the folder it was dragged from.
>
> --- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@> wrote:
> >
> > Lee
> >
> > I thought I answered this but my post hasn't shown up.
> >
> > The user needs create/delete permissions, too. When data is changed a locking file is created in the back end folder. When all close out of the application that file is killed. If the user cannot create in the back end, she gets a read-only version.
> >
> > Also, each user has his own local copy of the front end, right? They aren't all sharing one on the server, 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