Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2009

    Unanswered: updating an exisiting database that has no tables

    I have been employed to update an exisiting database. The original database wasn't on access, but the data can be exported to excel.

    The new database on access, was created by someone who has since left the company, and the database he created has no tables only forms.

    How do you create a database that already has forms yet no tables with any key information? Isn't this working backwards and hard if you did not know the original design idea?

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    i suspect you will find another database with the data in in

    you need to examine the forms or reports to find where they are getting their data from.

    of course if the previous employee left under a cloud they may have deleted the tabels to be bloody minded in which case you will have to go back to a previous backup.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2007
    Adelaide, South Australia
    Isn't this working backwards and hard if you did not know the original design idea?
    Very much so.

    The tables must exist somewhere! Find them to figure out what the structure of the database is. You can then re-create it with Access and the data you can export into Excel.... probably.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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