Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Developer Toolkits / August 2006

Tip: Looking for answers? Try searching our database.

Database read-only after using packaging wizard

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Peter the grate - 18 Aug 2006 12:08 GMT
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
Peter the grate - 20 Aug 2006 02:07 GMT
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

> 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
[quoted text clipped - 26 lines]
>
> Peter
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.