Thanks.

But that's actually pretty all you can do.  You can always do select * from both tables and manually do the joins... but there comes a point where you just...

Thanks. I meant the code of the stored proc on the sql server.

I'd like to run some test on my pc... can you send me the proc (at least the header so that I know what to work with)?

@TableName was set with a cursor in SQL server.  You'd have to do the same thing in access : open a recordset and fetch all the tables name from the...

Not exists.

Right join .

Change the db design

No idea on how to explain this.

Can you run profiler at night while that process is started / running and ends?  Maybe that'll give some more information on what happens.

What do the jobs do?

How do you know something has gone wrong?

Do you have any error message?

Simply put, it either hits the barrier and stays valid or the insert errors out.

You can check this out as a very basic starting point : SELECT SUM(LEN(?not sure here?)) FROM...

Who is the owner of the master job?

Under what account does the agent run?

In regards to that option, what do you think a user needeing help woul dbe doing on a forum like this one?

Thanks for the info.

I'm just curious... why would they want that??

Is the column in the table of datetime datatype??

If so, why can't you simply open a connection on the remote APP directly to the server, or even a linked server...

HTH.  I've been on both sides of the fence in my career...  it's greener here .

1 - DROP the index

OR

2 - ORDER BY NEWID()