Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    vancouver, BC, Br. Columbia
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    User level security - how to convert from Access 2010 to Access 2003?

    I read everywhere that I must convert my .accdb file to .mdb file before the User Level Security Wizard will run. But nowhere do I see *how* that is done.

    Does anyone know how to convert from Access 2010 to Access 2003?

    Gwenda

  2. #2
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    vancouver, BC, Br. Columbia
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Lightbulb I think I'm onto something ....

    I see under "Access Options" I have the ability to change the Default file format for creating new databases. So, I will change this to "Access 2003", create a new database and import all the objects from my "Access 2010" database.

    I will post again here if this doesn't work.

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    In Access 2010 there is also a Save and Publish command under file, that has numerous options, including changing the file format.

    But converting from 2010 back to mdb can be difficult as you need to make sure that there is nothing in the db that is not supported by 2003, and 2010 tends to automatically put in things that are not supported.
    Regards
    John



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •