Steve,

I'm not too familiar with ADO but the following code worked for me:

Private Sub Command0_Click()

Dim cnn As New ADODB.Connection

cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _

   "Data Source=.\ADODATA.mdb;"

Set rstADO = New ADODB.Recordset

rstADO.Open "SELECT *...

Sharon - that commented out bit was for changing server.

OK - in any sub place either or both commands and by calling that sub they will execute.

Alternatively - press Ctrl-G...

Sharon,

Jeff was asking earlier whether you used System or User DSN's - I use System.

The following functions will help with linked tables:

The removedbo will rename a linked table dropping the...

Strange one this.  Rather than using the Linked table manager - create the ODBC links thru the ODBC DSN and tick the Save Password option.

[File] [Get External Data] [Linked Files]...

Dave,

You may have to set a reference to DAO 3.6 Object model.

Richie

Dave,

Set up an ODBC DSN to point to your Database. In Access use File - Get External Data - Link Tables and point to your ODBC - DSN - the...

Peter,

Thats the perfect solution to a post I had here last week.  I didn't realise that the tables could be different structure (additional fields). Adding the Current_timestamp and system_user tracks...

Jeff,

I've been out of the office for a bit and I will take on board all of the helpful suggestions.  The Insert is the proper way to do it so I...

I'd sincerely like to thank you all for your contributions and I do apologise for seeming to fight back at the people suggesting different options but by doing so you...

Jeff,

There you go again - providing suggestions without an explanation of their purpose or effect.  What does the trace flag do? How do you set it on and what or...

Terry,

I'm not up to date with XP64 but rather than use a macro could you use a command similar to the following to zip the file:

Call Shell("z7.exe Zipfile.zip c:\FiletoZip.mdb")

Richie

Stephanie,

The following code resolved what I was looking for thanks to yourself. It may be lazy code but it works - thanks to your pointers.

I'm relatively new to this so...

Stephanie,

Many thanks for a Complete Answer.  I'll work on your suggestions.

I really appreciate the sample code - its the sort of answer i was hoping for.

The other responses were accurate...

Using select * on the Inserted/Deleted tables gives me what I want - a copy of the record before Updated/Deleted.  This is saved to the xPOPHD table.  My timestamp fields...

Richard,

To add to Jo's reply - you should set the default value to 1 or 0.

Bits are 1 or 0 and should not be Null.

As you've added a column you...