Well now, don't I feel dopey....  I go off on a diatribe and it sounds like you don't even need that kind of column.    ...

Reference tables "may" not need it.  They should rarely be updated or inserted and only a small handful of people should be able to access them. 

Production tables should not...

I can't wait to hear some of these truly smart people answer your question.  This generates quite a bit of thought from me, so I can only assume you will...

I think I see now, (said the blind man).  A number in Access is not the same as an integer.  I do not know what the precision is in Access,...

I think this is along the lines of what you want.  But!!!, I would heed Remi's advice.  This is very big change and you need much more code to ensure...

I can only assume you have not posted all of your code; but rather a shell to get the idea across?  I am not sure where you are getting table_name...

I see two possible solutions. 

Contracts.ModDate = GETDATE().  This may cause problems with the time part.  To overcome that and actually only match on the actual date without the time....

This is an approach I took with Invoice Numbers.  It might help.  The table name is AP and the two fields are RowID and InvoiceNum.  It is updating the CleanInvoiceNum...

Remi is correct. 

For the sake of argument, let's say all of your tables have a PatientID.  You pass that information into your stored procedure into the variable @PatientID.  Your...

I think you need to give us more information.  What do you mean by "delete partially"?  Delete only certain records from a table?  Remove information from certain columns in a...

Can you tell us what the datatypes are in both SQL Server and Access? 

You can schedule a manual shrinking, (along with the backup) to take place more often. 

Thousands of records per day should not cause too great a difficulty.  Might there be...

You can try the following: 

Go to "Tools" ----> "Options" 

Click on the Connections tab.  Un-check "Use Regional settings when displaying currency, number, dates, and times". 

I need that setting...

Beauty!  Thanks

I may be missing the boat here, but it sounds like you may want to give a little more information.  Are you calling this SP from an application?  In that...