Database Upgrade 2003 to 2007

[GUIDO22]

I have been using 2003 for some years now and deicde perhaps to make the move to 2007.
Using 2003 I use a workgroup file which I think is giving me the following problem.

In 2007, I open the DB I wish to upgrade and it states : You do not have the necessary permissions to use the _ object (strange seeing as I am the Administrator!)

Figure I only have to remove the workgroup reference to this DB? This is a demo database and not the LIVE one on my netwrk - so how can I remove the workgroup association with the Demo DB that I wish to upgrade and not affect users of the LIVE database that is also hosted on my machine...?

 

[Pat Hartman]

Welcome Aboard
I posted the documents you need to read here:
http://www.access-programmers.co.uk/forums/showthread.php?t=238127&highlight=security+faq

 

[AccessMSSQL]

In Access 2007 if you have a .mdw file from a 2003 version you can still use it. You just need to open the database with the proper shortcut. I don't think you can invoke the workgroup administrator from Access 2007 as this menu item was removed in Access 2007 and is only available from VBA.

Here is a link to an article about it:
http://support.microsoft.com/kb/918583

 

[AccessMSSQL]

Also, you cannot just remove the workgroup file. You would have to create a new Access 2007 accdb file and import all of the objects into it in order to have a version with no workgroup security. This can be done but you would have to create a new blank Access 2007 accdb and then open it with a shortcut to the mdw file in order to allow the Access 2007 blank database to import objects from the secured database. Hope this makes sense.