Re: 2007 won't open older format database

The mdw is on the network drive. The database is a 2000 format
database. She does not even get to the login prompt before Access 2007
tells her it can't open the database. yet, I go to another person's
computer with Access 2007 using the same short cut and there are no
issues getting in at all.

Bruce wrote:
On Sep 22, 2:21�pm, "Chris O'C via AccessMonster.com" <u29189@uwe>
wrote:
Unless she's the owner of the db, or a member of the Admins group, or a
member of another custom group with Administrator permissions, she's pretty
limited to what she can do in Access 2007 regarding settings and options.
The only things a normal user can do within Access 2007 with a secure db is
check which workgroup she's permanently joined to, or change workgroups
(which is overridden by using that shortcut with the secure workgroup command
line switch), or check which workgroup she's joined to for the current
session, or change permissions/names/designs on any objects she owns in the
db. �She can't give herself permission to open/run the db or remove that
permission if the db is secure.

Find out what the actual error message is when she tries to open the db.. �It
*can't* be the error message she gave you unless you've made a mistake and
it's really an Access 95 or 97 mde. �I don't think that's the case. �Access
2007 can open *every* Access db format except those 2, unless it's secured,
and you say she's joined to the correct workgroup with that shortcut, so that
avoids the "You don't have permission to open the dbname.mdb database.
Please see your administrator..." error message.

Chris
Microsoft MVP

godiva wrote:
Is there something in options that I should look
into in Access 2007? �Even if I connect to their server and use the
same short cut, I get in using Access 2007. I am concerned that
something was screwed up when they re-installed Access 2007 on her
box.

--
Message posted viahttp://www.accessmonster.com

Is the workgroup file a central file on a server somewhere or does
each computer get its own copy? If it's on the user's computer, copy
the workgroup file from a computer where the application is working
correctly and try again.

Bruce
.

Relevant Pages

  • Re: Dual Workgroup - Problem with creating administrators
    ... Every user must have permission to open the database. ... Administrators can have permission to open the database, ... If you use this workgroup, that user will now be able to enter any ...
    (microsoft.public.access.security)
  • Re: 2007 wont open older format database
    ... The only things a normal user can do within Access 2007 with a secure db is ... (which is overridden by using that shortcut with the secure workgroup command ... permission if the db is secure. ... Find out what the actual error message is when she tries to open the db. ...
    (comp.databases.ms-access)
  • The workgroup information file is missing or opened exclusively by another user.
    ... database with no workgroup file via the following connection string: ... file is missing or opened exclusively by another user" error message. ... The user has successfully repaired the database using my app (which ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Show execution plan
    ... the developer who wants the permission, ... I don't know how often I see "gets an error message", ... SHOWPLAN permission denied in database 'Northwind'. ...
    (microsoft.public.sqlserver.security)
  • Re: 2007 wont open older format database
    ... The only things a normal user can do within Access 2007 with a secure db is ... (which is overridden by using that shortcut with the secure workgroup command ... permission if the db is secure. ... Find out what the actual error message is when she tries to open the db. ...
    (comp.databases.ms-access)