Page 1 of 2 12 LastLast
Results 1 to 15 of 20
  1. #1
    tshaw is offline Novice
    Windows XP Access 97
    Join Date
    Feb 2010
    Posts
    9

    MSACCESS.exe has problems that MSARN200.exe doesn't


    Hi all,

    First off, I'd like to thank the members of this forum for helping me solve so many problem's I've had with Access in the past. This is my first time posting, and I hope that you guys can help me out with this issue:

    I'm trying to redesign an old database (mdb) that was created with Access 97 because some reports are not being generated correctly. It was distributed with and intended to be opened by MSARN200.exe. This works fine, but I cannot redesign any forms or debug any problems. But when I try to open up the same database with a MSACCESS.exe (97 version), I get the troublesome "the current user account doesn't have permission to convert or enable this database." I've joined the workgroup as an Admin (stored in an MDA file that was also distributed with the database) to no avail. Is there something that makes the MSARN200.exe unique in opening the database?

    Any input would be greatly appreciated. Thanks!

  2. #2
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Can you export to a new Database that is not secured?

  3. #3
    tshaw is offline Novice
    Windows XP Access 97
    Join Date
    Feb 2010
    Posts
    9
    hey rainlover, thanks for the response

    when I tried importing everything into a new mdb, I successfully imported all of the queries, reports, etc.; but many of the forms were not imported. Instead, form by form, I got the message "You don't have permission to import, export, or link to '[form name]'...you must have Read Design and Read Data permissions for it".
    I'm not sure why this is. I used the provided MSARN200.exe to open/edit the SYSTEM.mda workgroup file, and all of the permissions seem to be wide open (I set every thing to the "Administer" permission, which includes read design & data).
    What's also strange is that MSARN200.exe cannot open the new mdb that I created; it says "It may not be a Microsoft Access database, or the file may be corrupt."

  4. #4
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Let me start by saying that I am not familar with MSARN200.exe. So I am in the dark in that regard.

    I do suspect that it has something to do with a Runtime Version of MS Access.

    I further suspect that it it is not Access 97 but a version prior to that. Either 95 or perhaps Version 2.

    Back to your problem.

    If you created a new Database and exported some objects to that file then you should be able to open that by a simple Double Click. Provided that your settings will open with 97. You will no longer need the MSARN200.exe to open this new Database.

    Do I understand that you exported to your new Database everything except a few Forms?

    Back to you.

    And to everone else on this site if you have any experience in this please chime in.

    Edit

    Please confirm that you are using Access 97.
    Last edited by Rainlover; 02-03-2010 at 01:44 AM. Reason: Further clarification

  5. #5
    tshaw is offline Novice
    Windows XP Access 97
    Join Date
    Feb 2010
    Posts
    9
    Please confirm that you are using Access 97.
    Yeah, I dug up an old CD of Access 97 to try and revive this database.

    Do I understand that you exported to your new Database everything except a few Forms?
    I tried to import everything (select all --> import) but most of the forms don't import. Everything else was imported just fine, including several linked tables.

    I do suspect that it has something to do with a Runtime Version of MS Access.

    I further suspect that it it is not Access 97 but a version prior to that. Either 95 or perhaps Version 2.
    Wow that's some ancient software...now I'm not sure if a definitive solution is out there, since this database was probably made with an ancient version of Access on an ancient version of Windows. Does anyone even remember using those programs? I tried running this on a virtual windows 95...what a blast from the past.

    Thanks again for looking at this issue!

    edit:
    The database was indeed made with a version of access before 97

  6. #6
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Were you able to open the new version?

  7. #7
    tshaw is offline Novice
    Windows XP Access 97
    Join Date
    Feb 2010
    Posts
    9
    Quote Originally Posted by Rainlover View Post
    Were you able to open the new version?
    By new version do you mean the new database that I imported things into? Everthing that I imported into that database works fine.

  8. #8
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    So it appears that you have a new Database that works fine (with no security) but you are missing some forms.

    Can you log onto the original Database as owner?

    You would need the user name of the owner.

    Here is an idea.

    Log on as Administrator and remove the Password for the owner.

    Log out and back in as owner with no password and try again to export those forms.

    I think this might work. Good luck and keep me posted.

  9. #9
    tshaw is offline Novice
    Windows XP Access 97
    Join Date
    Feb 2010
    Posts
    9
    Can you log onto the original Database as owner?

    You would need the user name of the owner.
    Since the original .mdb does not open with Access, I have to open it with MSARN200.exe. When I use masarn to open other .mdb's, all of the menu options are there (File, Edit, View, Security, etc.). In these cases, I can easily change the User permissions through the Security drop-down menu.
    But when I open the problem .mdb, the options View and Security are not available. I tried the bypass (Shift+Open) to no avail.

    frustrating, ain't it? thanks again for sticking with this issue

  10. #10
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    I have a little utility somewhere that may overcome that for you.

    The Shift Open thing.

    I will send it later today but for now I must rush out the door.

    You could google for the same thing as there are other versions out there.

  11. #11
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It looks like MSARN200.EXE is from Access 2.0. I don't know if it will help but Microsoft has a converter from v2.0 ro v2003.

  12. #12
    tshaw is offline Novice
    Windows XP Access 97
    Join Date
    Feb 2010
    Posts
    9
    yeah, the converter was the first thing i tried...and unfortunately the first failure

  13. #13
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Try this utility to enable the By Pass Key.

  14. #14
    tshaw is offline Novice
    Windows XP Access 97
    Join Date
    Feb 2010
    Posts
    9
    i'm not sure if i'm running that utility correctly--both access 97 and msarn200 don't recognize and cannot open the mdb.

  15. #15
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Open the Utility with Access 2003

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Compare msaccess data
    By dref in forum Queries
    Replies: 10
    Last Post: 05-14-2010, 05:35 AM
  2. Problems with Dates
    By oldteddybear in forum Queries
    Replies: 0
    Last Post: 08-22-2009, 07:12 AM
  3. Problems with [Group by] in SQL
    By GeedieZ in forum Access
    Replies: 1
    Last Post: 08-14-2009, 03:34 AM
  4. Validation problems...
    By dbDamo in forum Forms
    Replies: 1
    Last Post: 05-15-2009, 12:43 PM
  5. MSACCESS Query
    By saa18 in forum Access
    Replies: 0
    Last Post: 11-14-2008, 05:12 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums