Firstly you cannot TRUNCATE a table that has primary/foreign key relationships.

The only advantage to DROP/CREATE that I can see is that it takes care of situations where the source structure...

The problem I have with "how to program" type books is that at some stage there seems to be an example that is basically how to build a scribble or...

Given the importance of data in the corporate environment I think Microsoft have made a good call.

If YUKON is as big a jump forward as VS.NET then it will have...

This is assuming you have a reference to Microsoft Data Access Objects.

Public Sub sbRename()

    Dim db As DAO.Database

    Dim tb As DAO.TableDef

    Set db =...

I have an MS Access database that is blank apart from standard utility functions that I always use.

One of the routines loops through the tabledefs collection and removes any dbo_...

INSERT won't delete records because the virtual table "inserted" contains the appended records, not the "deleted" table.

This strikes me as a Dilbert trigger.  If anyone attempts to update records, punish...

I thought hotfix 8.00.818 which is supposed to be the SQL Slammer patch?

Yep,

They are an external (an theoretically neutral) department with no connection to the issues involved.  Effectively they are for external verification that you raised an issue and it wasn't dealt...

Put down your issues in writing in unemotional language.

E-mail said issues to your boss and copy in your HR manager.

Keep a copy where you know you can get at it.

If...

Anyone remember EDLIN and the F6 key?

The CMS I am using uses JavaScript and has a gc(); command to invoke the garbage collector.

I haven't got that far into VB.NET yet but I'm sure that there will...

A good tool makes a hell of a difference to the productivity.

I don't like the way Interdev and Frontpage bloat the code, and yes, I too used notepad for web...

I seem to remember an article somewhere on this site that said that SA use, not just access, should be avoided where possible.

If I was in the situation where I...

3 steps forward 2 steps back then

One thing I am not clear on with garbage collection (whether in Java, .NET etc) is when is...

I like Kalen Delaney's idea to use case sensitivity in a development environment.

I inherrited a database that isn't particularly well normalised and is case sensitive.

The problem comes at the user...