Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jun 2005
    Beulah, North Dakota, USA
    Thanked 0 Times in 0 Posts

    Validating table field against external database (2003 SP1)

    Can I validate a table field against an external database? If so, how?

    I've got a table with field called EquipNo. We have a Maintenance System in Db2 that stores master Equip Numbers in a huge table. I want to run a piece of code to query the Db2 database using the entered EquipNo and check to see that it's valid. If not then the user should get a message. User sometimes uses form for data entry but often goes straight to table and always will, so I'd like to validate right at the table level instead if possible. I need to use code instead of doing a lookup because of speed problems.

    Thanks for the help!

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Sacramento, California, USA
    Thanked 1 Time in 1 Post

    Re: Validating table field against external database (2003 SP1)

    There is no way to validate at the table level in Access. As for your user, that is a design fault in the database. Users should never be allowed to enter data directly into tables for this very reason.

Posting Permissions

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