In what area??

There are way too many answers to that questions... Where do you need help with?

I'll also be humble for once in my life and I won't put my...

VBA.

BTW my pseudo-code will need a lot of syntax checking .

I don't have any written code in access but here's the logic :

set NumbeOfDays = 25000 'your choice here

set StartDate = '2007/01/01 'again when do you need this to...

All I can offer is course experience I had back in school.  Seems to be a nice alternative, I had a free GUI at the time. Sorry but I don't...

Where do you log the error when the connection fails?

If every recordset is somehow presented on the forms, then the operations should be able to resume... but I can see a lot of times where that scenario could fail...

The Ninja still learns everyday on this site.  That's why I became so good and that's also why I'll be 10 times much better in 2-3 years.

As for transactions I only have a...

Without doing all the work for you :

Distinctrow = Distinct

CLONG = CONVERT(DECIMAL(18,4), Columns)

NZ = ISNULL(Column, ValueIfNull)

So what were you testing?

I find it very usefull when an actual link is posted.  That way the date becomes much less of an issue when trying to find the said thread.  Thanx in...

Can't agree more with you on this one.  Be here done that, twice this week alone .

All objects refferencing that table will be recompiled.

Can we see the script to see if we can change it there?

This would force a file change :

ALTER DATABASE [Ideal_Audit] MODIFY FILE (NAME = [Ideal_Log], SIZE = 1300MB)

Afraid not...

You can search syscomments to find all cursors and then update 'em all :

SELECT OBJECT_NAME(id) AS ObjName FROM dbo.SysComments WHERE Text like '%CURSOR%' ORDER BY ObjName