Results 1 to 14 of 14
  1. #1
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    136
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conversion Issues (Access 2000 to 2003)

    Hello Access Gurus,

    Can you please advise me about converting an Access 2000 database to Access 2003? The Access 2000 database currently has Access security applied. Are there any issues that I need to be aware of in converting both files to the new version?

    Thanks

    Jocelyn Browning

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conversion Issues (Access 2000 to 2003)

    I wouldn't convert the database. Access 2000, 2002 and 2003 can all create, read and edit databases in Access 2000 format without conversion, so staying with the Access 2000 format ensures that users with any of these versions can use the database.
    The Access 2002/2003 format greatly increases file size, and is less stable than the Access 2000 format - many developers have experienced problems with it, so that's another reason not to convert.

    The only disadvantage is that you can't create an .mde database from an Access 2000 format .mdb database in Access 2003, only from the native Access 2002/2003 format.

  3. #3
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    136
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conversion Issues (Access 2000 to 2003)

    Hello Hans,

    Thanks kindly for your quick response. I have just converted the database as you said leaving it in Access 2000 format. Everything seems to be OK except the reports. I can no longer view any of the reports. The queries underlying the reports work OK however, the reports will not open from the reports menu form or database window. I also tried to open the reports in design view and this is not possible either. Can you help?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conversion Issues (Access 2000 to 2003)

    Do you get an error message when you try to open a report in preview mode or in design view?

  5. #5
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    136
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conversion Issues (Access 2000 to 2003)

    I have just tried to create a report in Design view and also using the wizards and found that I can't do either. I have recently upgraded to Office 2003. It appears that I can't create reports in a new database either. I currently have Office 2003 SP 2. Is there something I need to enable in order to use the reports and wizards?

    Jocelyn

  6. #6
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    136
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conversion Issues (Access 2000 to 2003)

    I have just found that my computer had lost it's printer connections within my network. The reports are now available. I am sorry about this one and thanks for your help.

    Regards,

    Jocelyn

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conversion Issues (Access 2000 to 2003)

    Phew! Glad you found it.

  8. #8
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    322
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: Conversion Issues (Access 2000 to 2003)

    Thanks for this info... I am close to upgrading our database from 97 upwards... hoping this would decrease the number of corruption issues here. This topic might have saved me from only exchanging one kind of trouble into another... <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22> <img src=/S/smile.gif border=0 alt=smile width=15 height=15>.

    FYI... also other topics touch issues with Access 2003... like Mass conversion utility where Charlotte clarifies the database bloat and HansV refers to a number other topics.

    Take care,
    Hasse

  9. #9
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    322
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: Conversion Issues (Access 2000 to 2003)

    <hr>I wouldn't convert the database. Access 2000, 2002 and 2003 can all create, read and edit databases in Access 2000 format without conversion, so staying with the Access 2000 format ensures that users with any of these versions can use the database.
    The Access 2002/2003 format greatly increases file size, and is less stable than the Access 2000 format - many developers have experienced problems with it, so that's another reason not to convert.

    The only disadvantage is that <font color=blue>you can't create an .mde database from an Access 2000 format .mdb database in Access 2003, only from the native Access 2002/2003 format.</font color=blue> <hr>
    Hans,
    should I expect any of the 2002-2003 problems you described when employing a 2003 mde front end on a 2000 backend?
    Hasse

    FYI: in order to avoid Multi user problems, I guess it is still advisory to use an mde front end.
    But since we have (now) Office 2003 installed, with still one user in Access 2000, I'm actually working like this:
    - delevopment in Access 2000 format
    - back-end remains in Access 2000 format
    - front-end is a 2003 mde (except for that one 2000 user).

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conversion Issues (Access 2000 to 2003)

    I would develop a single .mde frontend in Access 2000 (in Access 2000 format, obviously). All users, whether they have Access 2000, 2002 or 2003 (or even 2007) should be able to use this .mde.

  11. #11
    Star Lounger
    Join Date
    Apr 2001
    Location
    Melbourne, Australia
    Posts
    53
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Conversion Issues (Access 2000 to 2003)

    I have been interested to follow this thread, as I have a number of applications built as MDEs with Access 2000, and while I have not experienced any problems running them with later versions of Access, I have been concerned about whther there are lurking issues.

    Of more concern, and perhaps something for a different thread, is the issue of what happens if a user tries to run the Access 2000 Runtime installer. Can you tell me if that will co-exist comfortably and safely with later versions of Access please? And does VIsta have any relevance to this question?

    Thanks.
    Geoffrey

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conversion Issues (Access 2000 to 2003)

    I hope someone else can give more authoritative answers to your questions.

    I have no experience with installing an older version of Access runtime on a PC that already has a later version of Access installed, but I suspect that it is not a good idea. Access runtime is basically Access with all editing capabilities disabled. The general recommendation is that if you want to have different versions of MS Office (or parts thereof) on one PC, you should *always* install them from oldest to newest. I would guess that this applies to a mixture of Access and Access Runtime too. So you'd have to uninstall the full Access (or Office), install Access 2000 runtime, then reinstall the later version of Access (or Office).

    Windows Vista shouldn't influence this, but again, I have no experience with it.

  13. #13
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    322
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: Conversion Issues (Access 2000 to 2003)

    <hr>I would develop a single .mde frontend in Access 2000 (in Access 2000 format, obviously). All users, whether they have Access 2000, 2002 or 2003 (or even 2007) should be able to use this .mde.<hr>
    Thanks Hans.
    Funny: I'll have to use that one collegue's pc to create the 2000 front-end, as it's not possible from 2003 on my machine...
    Take care!
    Hasse

  14. #14
    Star Lounger
    Join Date
    Apr 2001
    Location
    Melbourne, Australia
    Posts
    53
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Conversion Issues (Access 2000 to 2003)

    Thanks Hans.

    Yes, having multiple versions installed is certainly a pain, not least because each version grabs the file associations for .mdb etc. In theory, the Runtime installer is supposed to check for an existing instalaltion, but it is not good at always finding newer versions of Access. I don't have experience, but suspect A2003 and A2007 will be a bit ugly.
    Unfortunately, when a shrinkwrap package is being provided to a user it does not go down too well if you ask them deinstall a complex package like Access of Office just so they can install my little app! <img src=/S/frown.gif border=0 alt=frown width=15 height=15>

    Geoffrey

Posting Permissions

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