Steps to Update 97 to 2000 when security is Installed

[carfj1]

I have more than 100 users, 70% of them have Access 97, the others have Access 2000. Now most of them are changing their computers to a Access 2000.

The 97 FE has the most updated developments. But some functionality on the 2000 version is pending to be done.

I want to know a simple way to:
1.- Import 97 front end objects
2.- Apply security
3.- Deploy the newest version to all users

I know how to do steps 1 & 3 (Check the miracle thread705-546432)

Is it possible to get the security be imported easily? I mean that I don’t want to check on the special permissions of each group every time the updating process is done.

Or is there a way to import and delete old versions of the forms or queries been modified after the original database was created.

Thanks,
Carlos

 

[Lightning]

With Security you basically have two choices:

1. Continue to use the mdw file created in Access 97

2. Create a new mdw file using Access 2000

You cannot convert the mdw file from Access 97 to Access 2000.

You can get more detail on this in the Knowledge Base articles:

http://support.microsoft.com/defaultasp?scid=kb;en-us;295253

http://support.microsoft.com/defaultasp?scid=kb;en-us;282357

HTH
Lightning

 

[carfj1]

Both versions of mdw files, and both versions of Front ends are running at the same time.

What I need to speed is the process of updating the 2k FE when an update on the 97 Fe is done.

Thanks,
Carlos