Just to clarify, do I write dynamic SQL to call sp_executesql ? And by 'dynamic SQL' are you referring to a stored procedure?

If possible, what would sample code look like?....I...

GAIL , it works! much thanks.... 🙂

-uman

Hello, (Matt, Gail, and the rest of the pros!)

I'm back, and I have written a trigger. It works given your instructions.

However, the underlying table has 2 columns which are defined...

Matt, it works ! I appreciate your help.

Moreso, I appreciate clueing me into the reason for the coding. I'm saving this for future research.

-uman

rbarryyoung (12/3/2008)

---

My light saber apparently has a glitch!

The following trigger is not working:

USE [db]

GO

/****** Object: Trigger [dbo].[trTest] ...

Jonathan Kehayias (12/3/2008)

---

I just wanted to point out that my recommendation was to use a default constraint with a value of getdate() which is persisted with the date and time...

Ninja and Mitchel...

I can get no farther than the screenshot I've illustrated above. So, in Ninja's suggestion, I open the file through the Access app itself, and I choose "Open...

ha...pretty funny...

Gail, i like your signature quote...its "otherwise" for me ! :hehe:

Will follow your directions from here on out....

Awesome, thanks Matt!

Grant, no problem....

GilaMonster (12/3/2008)

---

Stats aren't a table. If you need to know when a entry was made to the table, you need to have some mechanism to track that. Typically a trigger...

GilaMonster (12/3/2008)

---

umanpowered (12/3/2008)

---

UPDATE or INSERT will format a lastupdate column with the data I need. Thats fine. But because I work with a couple of related rows against the...

GilaMonster (12/3/2008)

---

The engine does change some internal objects, but you don't need to even be aware of that.

You only need to know stuff about the internals when something breaks...

Hi,

As a side question, do you know of...

Um, actually I was interested in unlocking a locked .mdb file. (See Perry Harts post above).

But with respect to your information, do you know if there is any code...