Checking for existing contacts in a ADP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I’m looking for a way to avoid duplicate contacts in an Access Project. In a
MDB I would use a parameter query. I’m a newbie to ADP and can’t seem to
find much documentation. Any suggestions are greatly appreciated.

Sincerely,
Raymond
 
The newsgroup for ADP is m.p.a.adp.sqlserver. By taking a look at the
previous posts, you should find there a lot of information about ADP.

In your case, you can either use the DLookup function in the same way as in
MDB file or use the CurrentProject.Connection object to make queries against
the SQL-Server. The CurrentProject.Connection is an ADO object; you will
find a lot of information about ADO on the m.p.a.modulesdaovba.ado and the
m.p.data.ado newsgroups (and in mpa.adp.sqlserver as well) and on the
internet.
 
Back
Top