Insufficient permissions to use back-end mdb object

Insufficient permissions to use back-end mdb object

Post by rdemya » Wed, 28 Feb 2007 02:12:15


Here's the scenario:

1) MyApp has workgroup security
2) In the startup routine I first relink to the backend file.
2) After relinking, I am trying to asynchronously create a local copy
of the backend file using the LaunchCopy procedure. This is done by
creating a batch file and when the batch file runs it uses Copy %1 %2
type commands. After the file is created it is launched via the Shell
command.

3) Startup continues after the Shell command for the batch file is
executed.

When I logon as a user who is not the owner of MyApp, I am getting the
following error:

"You do not have the necessary permissions to user the '.......
\Backend.mdb' object. ....."

When I logon as the owner, I never get this error.

The error seems to be caused by my startup routine trying to access
table data from the back-end file while it is being copied. I've
moved the LaunchCopy procedure to a later point in the startup
routine. I still get the error, but it doesn't seem to affect
anything. When logged on as a regular user (not the Owner), if I wait
awhile after startup before trying to access any data, I don't get the
error.

I wanted to launch the backend copy routine asynchronously, because I
didn't want to significantly increase the amount of time MyApp takes
to startup.

My main question is (assuming I understand what is happening): Why am
I NOT getting this error when I logon as the Owner. If the problem is
that the back-end file is being copied by the .bat routine and MyApp
is trying to access data from it (via the front-end links) during
startup, wouldn't I get this error regardless of who is logged on
(Owner or otherwise). Like I said, the Owner of MyApp has never
gotten this error.

Please, let's not get into why I want to create a copy of the back-end
file. I'm curious about why the Owner user wouldn't get this error.

Thanks.
 
 
 

1. Transitioning RPC-HTTP setup from back-end only to front-end / back-end setup

2. Front-End/Back-End Scenario, Back End on Global Catalog Server

Hello
Im triying to configure rpc on front end but im getting problems
Situation
Both Exchange servers Service Pack 2
Front end server: Rpc Proxy configure, IIS configuration Ok, configure as a
user aplication Rpc Server
Global Catalog: Rpc Proxy configure, IIS configuration Ok, ntds port create,
Not configure as a back end rpc services server (Propertis of the server) I
have to activate it?
When I try to configure my Outlook client it ask my for user and password ,
but I cant logon with my credentials

3. change the location of the back-end mdb tables file

4. cannot connect to back-end .mdb

5. Split .mdb back-end

6. Linking table to IN-USE back-end mdb ???

7. how to link to a back-end .mdb file on the net

8. Back-end mdb and odbc - newcomer

9. Front-end db run Parameter query in back-end Access db using ADO?

10. What are the disadvantages of using the Front-end and Back-end Da.

11. OWA using Front-End and Back-End servers

12. Building a website using FrontPage as the front-end and C++ as the back-end.

13. SQL Back-end / Access Front-end using linked tables????

14. Access front-end / SQL Server back-end using replication over WAN

15. using Access 2007 as front-end to SQL Server back-end