Grant & Gail,

wow! thanks for the quick responses. your insight is instructive.

If I'm understanding SQL 2005 DBMS correctly, the DBMS "engine" has...

Kolivad,

I went to the link, and it looks the solution applies to SQL 2000. Do you have a comparitive solution for Access db?

Gouthama Kolivad (12/2/2008)

---

for more info visit...

I'm experiencing a far more unusual problem than the .ldb. Basically, its not even appearing when I try to open the corresponding .mdb.

see http://www.sqlservercentral.com/Forums/FindPost612028.aspx for a complete...

Hensbergen,

Thanks for the quick reponse.

No, there's no .ldb. While the .mdb is open, in the following manner:

I goto the folder where the .ldb is supposed to be...

Would this also clear any locks on an .mdb run locally?

I don't see the .ldb file when I open up the folder while the Access .mdb is open. For example, when I open up the .mdb file in question, the...

Sam, did you every find how to do the conversion?

Hansi and Garadin,

Nice! thanks.

Are you able to produce a modification to the code which puts a separating line above the Total row? (between the data and the last...

Barry,

...Modified in terms of changing a column description, adding a column, doing some type of work on the Table Definitions itself, NOT the underlying data...is this correct from when...

Just out of curiousity, I asked this other question on this board, but under another topic forum

I just thought this was pertinent to my subject. Do you have any thoughts...

R BARRY YOUNG;

Thanks! The code you provided

ALTER TABLE [testData]

ADD lastupdate datetime default(getdate())

worked!

I configured the TableAdapter with your suggested implementation:

Update testData

SET note=@note, lastupdate = getdate()

linked it to an ObjectDataSource on my...

Tim Meers,

Does the code you suggested provide the last time a table was updated?

I went directly into a table in SQL 2005, and change a column. I closed...

Rbarry young and Jonathan,

Once again, I appreciate your assistance. Forgive me that I'm still on a learning curve with SQL and the Visual Studio IDE. After reviewing your suggestions,...

rbarryyoung (10/29/2008)

---

umanpowered (10/28/2008)

---

... Add an index to your table(s) only on the "LastUpdated" column (ASC). Now create a view like so:

CREATE VIEW vwMainTable_LastUpdated

AS

SELECT MAX(LastUpdated) as [TableLastUpdated] From...

Thanks for replying, Jonathan,

Here is what I was thinking:

Rather than have a table which shows this:

Column 1, Column 2, Column 3, Column Last updated

....

(with data in each...