compare data in two different database

G

Guest

I have an AUDIT.mdb database which has all the data that was added to my
other database called DataEntrymAIN2.mdb. When the user adds data to a field
called ID on the form, I want to be able to look up data in my AUDIT database
to make sure the ID is not being duplicated. Can this be done?
 
G

Guest

Link to the table in AUDIT.mdb that has the data you want to validate. It is
okay to link to multiple back ends.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Splitting Database 6
Comparing data in two different tables 3
Option Compare Database 6
Q for Mr Allen Browne = Auditting a form = Audit Log 1
Access Click in Table to Open Form 0
Access Access Report Works on One Machine but not Another 3
how to enter data simultaneously to two different tables in Access 2
Allen Brown's audit log code "insert" problem 0

Top