I'm assuming you have an Access Front End on each person's machine so that they're running reports and the like locally instead of off a single resource, like you would...

Both databases are indeed on the same server, so it looks like that won't complicate things. Thanks for the help. I've got a brother-in-law IT guy so he...

Here's my situation. I'm a scientist that inherited a crazy database (MS Access for data entry, SQL Server back-end) when I started the current job. The database was...

Sorry, I should have been more specific. I know that it needs to be run in SQL Server Management Studio, I just need to know where to insert the...

A couple of questions:

Does the code depend on the maximum value of the primary key in the Master database being larger than the maximum value in the data entry database?...

As far as ID_old is concerned, that's there because I was trying a few things in Access (where we do most of the data entry) to see if there was...

Derp. Here's the table from the data entry database (CTAPA). The data from this database needs to be appended to tables with the same name in the master...

I wish I could. I'm not well versed in writing code. Like I said, I'm kind of learning on my own as I go.