Glad you liked it Chris,

The more I look at stats the more sceptical I am about government statistics.  Lies, damn lies and statistics and all that.

My favourite quote was that...

Now that Dubyaa has obliterated the dollar I would be daft not to subscribe! 

Fortunately we have an American subsidiary so the present US only distribution can be got around.

I...

Granted that Access can be a resource hog but I found that the query properties eased that a lot i.e. record locks, use transactions etc.

I found that if you have...

If I have a regular import job then I use DTS.

If I need to do a quick one off then I tend to do my data cleaning and preparation in...

Can you give an example?

I tend to design my tables with rules and defaults so I am not sure why you need a trigger to enforce this?

Pause a moment whilst I swear profusely

I wish I had known about fn_replinttobitstring & fn_replbitstringtoint, it would have made my life so much...

Andy,

Sorry to add to your woes but I also get the (1 item remaining) message on the shwmessage screen, although everything appears to work correctly. 

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=61&messageid=93623

If I click the...

No Andy, but then under Mozilla the reply form is just bog standard HTML rather than the ActiveX control you see under IE.

Under IE I can see all the toolbars...

I would also recommend putting some sort of logging code into your front end app.

When I have my code in a DLL then every function has an error trapping clause...

Have you noticed that when you write an ActiveX DLL, passing values ByRef is faster than ByVal, but when you write an ActiveX EXE the opposite is true?

Just as an aside, every year in Britain we have the New Years honors list where persons who have made a great contribution to British life get enobled with awards...

Frank,

The $HTTP_REFERER, $HTTP_POST_VARS and $HTTP_GET_VARS stuff is dictated by the PHP.INI file. I'll find out which setting it is that determines thebehaviour and pass it on when I return...

I appreciate your problems with a couple of hundred databases, but the thought of trusting the backup of that lot to one maintenance plan gives me the screaming heebie jeebies.

One...

My brother in-law described PHP to me as "imagine if all the frustrated ASP programmers got together and said 'I wish ASP did this', then they got drunk and added...

I suppose the aim is to have a quality mark against the posts on the forum.

The stars do not affect the validity of the answers given.

At present you have a...