• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 31. Upgrading Access 9x and 2000... > Converting Secure Access 9x Files

Converting Secure Access 9x Files

Converting secure Access 9x files is a complex process that requires advance planning. Multiuser networked applications are the most common environment for secure Access files. To upgrade either the front-end or back-end .mdb file(s), you must open the files exclusively under an account that has Modify Design or Administer permission for all objects in the .mdb file. Alternatively, you must be the owner (creator) of all the database's objects. All users must close their front-end applications for you to obtain exclusive-open access to the back-end .mdb file.

Tip from

VBA code in secured forms and modules becomes unsecured when converting to Jet 4.0 because the change to the VBA Integrated Design Environment results in a different storage mechanism for your code. After you convert secured front-end .mdbs containing any VBA code, you must use the VBA IDE to password protect the code.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint