I note from another post that the problem is in the permissions that the user
needs to have in the directory. Is there a way to change the required
permissions on the database during the install?
Peter
"Peter the grate" wrote:
[Quoted Text] > I have developed an application using access 2003 as front end and back end.
> I am not using workgroup security (ie all users will be admin) the program
> part is
> distributed as mde and the back end as mdb, the package also includes Access
> 2003 runtime and a dll that I have written. The developer's extensions are
> used to package the app (using the package wizard).
> Defect Symptoms are:
> I install the app on a stand-alone WinXP using an administrator account.
> (The PC
> is actually a simulated PC using Microsoft Virtual PC)
>
> When I then try to open the db application using a (limited) user account it
> fails on the first query that updates a table. The two files: mde and mdb
> appear to be read-only (they can't be deleted or renamed by the user)
> even though win xp describes them as read-write and the user can write
> other files into the same directory.
>
> The directory they are being written into is:
> C:\Documents and Settings\All Users\Application Data\MyDir\
> I have also tried writing them into a program files directory:
> C:\Program Files\MyDir\
>
> The application works just fine if the user is an administrator, but as you
> know in many businesses, users are only given "limited user" accounts.
>
> If you can't think of an answer, can anyone direct me to where I might
> get an answer? As you can imagine, this is a "show-stopper" my application
> development is effectively stopped until I can get a solution.
>
> Peter
>
>
>
|