While I've never really been able to find a way to do this in Access what we did was make a read only copy of the Access database for users...

If Access 2002 supports user defined functions (maybe you can use VB to do this) you could create a function that expects a candidate and then loops through all the...

Have you tried something like the following?

gdbData is the Designer

conATOMS is the connection

"Production" is the name of the server i want to connect to in runtime.  I use "Development" when...

Looking at the code there doesn't seem to be an issue with it, however I would suggest changing to using the exists clause.

Something like:

CREATE Procedure sp_updateInvalidziplist

 @zipcode varchar(5),

 @sessionID varchar(50),

 @dateTime datetime,

 @ani varchar(10),

 @did...