Question Upgrade from Access 2002 to 2007

[karrade]

I have just upgraded to access 2007 from 2002 (xp professional edition)

I cannot open my database in 2007

The original version is a split front / back end system which has a secured workgroup with each user having different permissions.

When i try to open the database in 2007 I get the following error

"You do not have the necessary permissions to use the <name> object. Have your system administrator or the person who created this object establish the appropriate permissions for you. (Error 3033)"

How do i join the workgroup in the new version of access? As I am the creator of the object I have no one to ask to establish the appropriate permissions

Or do I need to remove all security from the original database in V2002 and then open and convert the DB to 2007 and then re-create a new workgroup?

Any help or ideas would be appreciated.

many thanks

 

[Pat Hartman]

Yes you need to remove security. If you are going to use the .accdb format, user level security is not supported. If you don't convert to the new format you can still use A2007 to work with and edit your application and it will respect the user level security that currently exists.

There have been many complaints over the years due to the obtuseness of user level security. Rather than attempt to correct some of the problems, the Access team removed ULS entirely from A2007.

 

[karrade]

Yes you need to remove security. If you are going to use the .accdb format, user level security is not supported. If you don't convert to the new format you can still use A2007 to work with and edit your application and it will respect the user level security that currently exists.

There have been many complaints over the years due to the obtuseness of user level security. Rather than attempt to correct some of the problems, the Access team removed ULS entirely from A2007.

thanks for the info, i'll remove all the security. It won't let me access the DB at all with it secured. I'm just hoping all my codeing still runs because i've heard that a few other bits and pieces have been removed from 2007 and "sod's law" says that i've probably used all the removed bits