Just Upgraded to 2007 - security won't let me in database

R

Ronnie

I just upgraded to 2007 and the security I had set on the database in Access
2003 is not letting me in. I am getting a message to contact the
administrator to change my user permissions. I am the administrator and I
can't get in to make any changes. I can open the workgroup, but I can't see
how to change or remove passwords. I thought this might do it, but I guess
not. Any suggestions?
 
A

Arvin Meyer [MVP]

You must use the exact same workgroup file (.MDW) that you used with the
previous version. If the file was changed in the upgrade, you will need to
find a copy from one of your machine backups previous to the upgrade.
Further, Access 2007 ACCDB files do not support User=Level security, so you
will need to maintain the MDB file type.
 
A

a a r o n . k e m p f

Microsoft removed User Level Security from Access 2007 (format).

You should remove the security and upsize to SQL Server, so that you
can have real horizontal security.
 
A

a a r o n . k e m p f

I didn't say anything about Access 2007 MDB format.
It is a fact that ULS was removed from Access 2007 (format)
 
R

Ronnie

I have the workgroup file saved, but do not know how to join the workgroup in
2007. How can I remove the security from my 2003 version (from a pc with
Access 2003) and start over?

Also, is there a site I can go to learn about the upgrades. I opened up
another database I had created without security and can't access the
switchboards! Getting frustrated.
 
W

Walt Kowalski

a a r o n . k e m p f @ g m a i l . c o said:
I didn't say anything about Access 2007 MDB format.
It is a fact that ULS was removed from Access 2007 (format)
Click to expand...

Get off my lawn and don't come back.
 
A

a a r o n . k e m p f

you can't use ULS in Access 2007 (format).

if you need security in Access 2007; you're forced to move to Access
Data Projects.

SQL Server, the worlds most popular database.

-Aaron
 
T

Tony Toews [MVP]

you can't use ULS in Access 2007 (format).

if you need security in Access 2007; you're forced to move to Access
Data Projects.
Click to expand...

Wrong. Access security is supported in A2007 MDB format. Granted SQL
Server security would be very likely be better but would be
significantly more work.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
A

a a r o n . k e m p f

I never said anything about Access 2007 MDB format.

ULS and replication are not available in Access 2007 (format).
If you want replication or security, you're forced to use Access Data
Projects
 
T

Tony Toews [MVP]

A

a a r o n . k e m p f

Tony;

you're the one that _LIES_ at every corner.

you have no right to say that my statement is misleading.

You're the one that's stuck, insisting that everyone use
_YOUR_FAVORITE_ database..
and you just can't handle the fact that someone somewhere-- knows
databases more than you.

So sorry that you think that your 6 month project working for igloo-
manufacturing cmpany gives you the qualifications to proclaim that sql
server is 'TOO COMPLEX FOR EVERYONE'

you can just screw yourself.

so sorry that you had a hard time on an upsizing project a decade ago.
You have no right to insist that everyone use an obsolete database
_TODAY_ just because you couldn't figure out sql server.

Grow up you lazy bastard.

-Aaron
MCITP: DBA SQL 2005
 
A

Arvin Meyer [MVP]

You can remove security (from within Access 2003) by:

1. First, log in as a member of the Admins Group, or as the owner of the
database.

2. Grant full permissions to every object, including the database object
itself, to the Users Group.

3. Close the database and the Access application.

4. Use the workgroup administrator (which should be at: C:\
Windows\System32\Wrkgadm.exe) to make sure you are joined to the
system.mdw that ships with Access. (which should be at: C:\
Windows\System32\system.mdw)

5. Reopen Access after joining the changed system.mdw and create a new
database.

6. Import everything from your old database into the new, unsecured one.

7. That's it, now copy that database to Access 2007.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
 
R

Ronnie

Thanks! That will help.
--
Ronnie


Arvin Meyer said:
You can remove security (from within Access 2003) by:

1. First, log in as a member of the Admins Group, or as the owner of the
database.

2. Grant full permissions to every object, including the database object
itself, to the Users Group.

3. Close the database and the Access application.

4. Use the workgroup administrator (which should be at: C:\
Windows\System32\Wrkgadm.exe) to make sure you are joined to the
system.mdw that ships with Access. (which should be at: C:\
Windows\System32\system.mdw)

5. Reopen Access after joining the changed system.mdw and create a new
database.

6. Import everything from your old database into the new, unsecured one.

7. That's it, now copy that database to Access 2007.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Document won't print 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
Active Content in this file is blocked issue 1
Pop up requires me to confirm password to allow email to be received 0
Dynamic Naming of Form Button 3
Upgraded to Onenote 2016 but all data is old 0
Exporting Outlook 2007 contact list without losing groups 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0

Top