Converting Access 97 to Access 2010 - Fix Security

Question

I am trying to convert Access 97 front end and back end into Access 2010.  I have converted the tables into Access 2010.  Now I am trying to convert the front end.  The databases are password protected in the back end and I also have security in the front end to determine how each group views the information.  My problem is that when I run reports, it is asking me for a parameter "Environ".  If I click OK and leave the request blank it will give me the report.  How do I correct this where I don't receive this message?

Answer 1

What kind of security do you have in place? User Level Security is not supported in Access 2010, if you have that in place.

 

Best practice for converting is first Un-secure your Access 97 database and then convert your database to Access 2010, following:

http://office.microsoft.com/en-us/access-help/convert-a-database-to-the-accdb-file-format-HA010341552.aspx#_Toc262207807

 

You might read this article also from Allen Browne, converting from Access 97:

http://allenbrowne.com/ser-48.html

 

Hope this helps,

---

Daniel van den Berg | Washington, USA | "Anticipate the difficult by managing the easy"

Answer 2

Actually, it's not true that User Level Security isn't supported in Access 2010: it's just not supported for the new ACCDB file format. If you use the older MDB file format, you're okay.

The fact that it's prompting for Environ (which is a built-in VBA function) makes me suspect that there might be a problem with the References collection. I offer way to correct this in http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

---

Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/djsteele (no e-mails, please!)
Co-author Access Solutions — Tips, Tricks, and Secrets from Microsoft Access MVPs (ISBN 978-0-470-59168-0)

Answer 3

Hi Doug,

Yes, I should have point that out, but as OP converting the database, it can't convert the USL with it, that's what I meant with it.

 

Thanks,

---

Daniel van den Berg | Washington, USA | "Anticipate the difficult by managing the easy"