Recent content by ecrrolson

I'm running a large update/append query, with 90 fields being updated. If there are any more than about 100 records in the Update table I get the following error: "The MS Jet DB engine stopped the process because you and another user are attempting to change the same data at the same time."...

Thanks Pat Hartman, and Fornation for replying... The MS Knowledge base example (Q127977), that Pat sent me, was right on the money. I have used the example and have the update query working great!!! Thanks, again!! Erik

In other applications I have used there are utilities which will compare each value of the new data, to the existing data and add or change depending on what is found... In the initial Load the Hotel Number may not be input yet, in the next extract based on Date of last update, the Hotel is in...

So there is on utility that will analyze the data as it is loading, and do the corresponding add or change?

I'm new to this forum, and to Access...Please have patience with me!!! I have been tasked with setting up a DB in Access for Sales Lead tracking and Paying Commission. We recieve an extract (csv) weekly from another DB, which has Sales Lead information, ie. Company, Name, last Call, Sales...