Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    York, Pennsylvania, USA
    Posts
    164
    Thanks
    0
    Thanked 3 Times in 2 Posts

    Commercial Access 97 Database (Access 97)

    We got a third party Access 97 application. Bear in mind I'm not an Access guru. We need to export the data for importing into an Oracle replacement application.

    The Access application does not have any export options. Additionally, we cannot even examine the database design so we can't tell what the field names are. Since the database is protected, I can't access it using ODBC.

    Is there some 3rd party utility that would allow us to get the data and field names out of this database?

  2. #2
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    NYC,USA,Earth
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Commercial Access 97 Database (Access 97)

    Can you open the db with the bypass key (shift key)? Hold the shift key down while opening the db - this will bypass the startup options - unless the creators disabled that functionality. If you can you should be able to export any tables you need. At least I can with the third party db we have here. Good luck!

  3. #3
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    York, Pennsylvania, USA
    Posts
    164
    Thanks
    0
    Thanked 3 Times in 2 Posts

    Re: Commercial Access 97 Database (Access 97)

    Thanks, but we've tried this. We just get an error message about there not being any 'read definitions'.

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Mishawaka, Indiana, USA
    Posts
    145
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Commercial Access 97 Database (Access 97)

    I do not know if this will work, but try creating a new database and importing the tables from your old database.

    File, Get External Data, Import, etc.

    Let me know if it works.

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Commercial Access 97 Database (Access 97)

    If this is a commercial application, you don't have a license to muck around in it. Is the company that created the database still in existence? If so, they're the ones you should be talking to.
    Charlotte

Posting Permissions

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