It looks like I figured out the cause, and it only sort of had to do with the security prompts. Apparently, the second connection was occuring before update was completing in the access database. The only reason it would work when clicking the prompts was it allowed an extra second or so for the upd...

I am currently working on a PO form for our company and have run into a bit of a snag. I have one one database with two tables that populate a list of vendors and a list of PO #'s.On the form is a Get PO button that connects to the databse, gets the first available PO # that is available, updates th...