| Mark Vincent via AccessMonster.com 2005-04-25, 9:29 am |
| Any help would be greatly appreciated.
I have a split database with the frontend located on each PC and the
backend located on a network. I also have three different user groups set
up (admins, fulldata and readonly). One feature I have added is the ability
to create a backup of the backend at any given point in time depending on
the requirements. This is an administrative task and the backups are all
kept one directory below the backend.
\\Directory\Backend
\\Directory\Backend\
Backup
As the admin, I can link to any backup copy and run a multitude of reports.
I am now working to enable this feature for all of the other users but
every time I log in as someone else and try to link a backup copy I get an
error 3033 "You do not have the necessary permissions".
First, keep in mind that this is me logging into my PC every time so I do
not think it is a network permissions problem. If I log into Access as the
only person in the Admins group I can relink back and forth from the
backend to a backup copy all day long without any trouble although linking
to the backend does take a little longer for some reason and no LDB file is
created. When I log in as any other user the normal backend works fine.
However, when linking to the backend (there are several tables) the 3033
error always happens but not always on the same table or even group of
tables.
As for the workgroup file, I have the backend tables set up appropriately
for each user group with the lowest level being read only users and having
read only privileges. In the frontend all groups have full privileges on
all tables.
Observations: If I log in as an admin and link to a backup copy everything
works fine. Then if I log out and log back in as a read only user I can not
only use the linked backup copy but I can change links back and forth
between the backup copy and the normal backend without any trouble. It's
even faster! If I try to link to a different backup copy I get the error
again. Also, once the links have been changed to a backup copy, logging in
as anyone creates an LDB file for the backup but if I link back to the
normal backend the LDB file stays with the backup copy.
One more thing, it doesn't matter if I perform the relink through the link
table manager or through code I get the same error. However, if I modify
the code to retry the RefreshLink when an error occurs it will eventually
succeed after about 10 to 15 tries. Even if I do get through it I still get
an object variable not set error so there is still something else wrong.
Thanks,
Mark
--
Message posted via http://www.accessmonster.com
|