Access db accessibility (permissions??)



I've inherited a visual basic (v6.0) app that uses an Access 2000 database. Supposedly the database isn't secure so it
doesn't matter who has access to it.

When I deployed the app + database my users can't open the database (W2K or XP). However, when they install the app +
database on their own personal systems they have no problems. But at work they can't get to the database. I've made
sure that Office 2000 is installed on their systems so that all the requisite components are present.

One thing I've been able to establish is that when they are given local administrator rights to their own systems the
app and the database work perfectly.

I know very little about Access; when the app was deployed the app executable and the mdb file were deployed. What
else needs to be done so that my users can use the database without having local administrator rights to their systems.
The Sys Admins are adamant about this.

I suspect that since as local administrators they can use the app + database that there's a permissions issue
somewhere, but I haven't a clue what or where to start.

any help is definitely appreciated.


TIA

cathy
.



Relevant Pages

  • Re: Portable Database Choice
    ... I searched this group quite a bit looking for database alternatives and did find the options below from this search. ... I'm posting this in the hope it can be of use to other developers in a position similar to mine where I needed a low cost alternative to Pocket Access. ... One app requires synchronization between desktop and mobile device, the other requires a push of data from the desktop to mobile. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Portable Database Choice
    ... > database alternatives and did find the options below from this search. ... One app requires ... > push of data from the desktop to mobile. ... > Both of these apps used Pocket Access on the device with Peter Foot's ...
    (microsoft.public.dotnet.framework.compactframework)
  • Portable Database Choice
    ... database alternatives and did find the options below from this search. ... of data from the desktop to mobile. ... The read-only app requires speedy lookup of data in a flat table ... Both of these apps used Pocket Access on the device with Peter Foot's ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Sqlserverce class not working when VB.Net application is running from network drive
    ... one app attempts to connect to a sdf file on a network share, ... possible that the database is already in use when you attempt to ...
    (microsoft.public.sqlserver.ce)
  • Re: MSVC++ app type choice, form design questions
    ... > 1) MSVC Project definition requires that for an MFC app I choose ... MFC's built-in database support is really built around the document/ ... with the full version of SQL Server, but it's still pretty usable -- ...
    (microsoft.public.vc.mfc)

Loading