mdw file when converting secure database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark - 23 Nov 2004 18:59 GMT

I have a secure Access 97 database that I am going to convert to Access 2003.

Will the new 2003 database be secure?

What happens to the old Access 97 .mdw file?

Does it need to be converted to an Access 2003 .mdw file or are they all
interchangeable?

Does Access 2003 have it's own Workgroup Administrator?

Thanks a lot if you have answers!!

Mark

Reply to this Message

Joan Wild - 27 Nov 2004 19:05 GMT

> I have a secure Access 97 database that I am going to convert to
> Access 2003.
>
> Will the new 2003 database be secure?

As long as you use the 97 version mdw, and log in as a member of the Admins
group, you'll be able to convert it. Technically a 2003 mdb can use the 97
mdw.

> What happens to the old Access 97 .mdw file?

Nothing. Your new mdb will still need to use this mdw file.

> Does it need to be converted to an Access 2003 .mdw file or are they
> all interchangeable?

Technically, you don't have to convert it, however it is recommended that
you unsecure it in 97, convert the unsecured mdb, and then reapply security
in 2003.

You'll find a couple of utilities at http://www.daiglenet.com/MSAccess.htm
to script out the permissions.

> Does Access 2003 have it's own Workgroup Administrator?

In 2003, you'll find the workgroup administrator is now built-in to Access -
you'll find it in the Tools, Security sub-menu.

Signature

Joan Wild
Microsoft Access MVP

Reply to this Message