@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()

I would hardly call that advice.

My gut is also telling me that this is likely a joke, but this solution could certainly help someone someday, so I'll play along and...

Of course you could get out of your way and change the xtype of the system table... then you would be able to drop them... but I would assume that...

What problem are you having in getting those results ordered?