Hi,

there's nothing in the table definition I can see that has those settings.

Jonathan,

Thanks very much for the detailed row-update solution. I have to go through it and ascertain if I can implement it for my purposes. (Still a newbie...).

I implemented the...

Are you saying that a column can be included in the table which is automatically populated with the last time the table was updated? If so, that would work for...

So will adding a datetime type column to the table automatically insert the "date/time" when the table is last updated?? I'm sorry, I guess I don't understand the conclusion.

The...

Ninja, thanks for responding. Your questions jogged my memory and I figured it out.!

I reproduce the solution for myself and for all others who might be experience the same....

I am trying to do the same thing. I have developed a Default.aspx page with 2 objects (table handlers) which does Select statements against a SQL 2005 DB (1...

Ken, it works! Thanks. I set identity to "yes", made it a PK.

And thanks for the feedback for this answer from everyone else.

Ken Simmons (10/6/2008)

---

If you add an Identity column...

Chris, and thank you! Your solution works, too. It correctly lists just the one user (myself) who is logged in this time.

I'd like to take this solution and make...

William, thank you very much! great solution! It works. However, it lists each user as logged in twice. Any suggestions?

WILLIAM MITCHELL (10/2/2008)

---

Here is an easy way to to it. I've...

gene.stebley (9/12/2008)

---

I would suggest the fastest and most useful way to learn how to use an adp project would be to create a project from scratch, connect it to an...

smunson (9/12/2008)

---

Hi All,

However, Access can be no picnic too. It has it's own quirks, including the tendency to self-corrupt, especially if you don't run a regular "Compact and...

WILLIAM MITCHELL (8/8/2008)

---

That is a good point. If you already have links to a back-end file, after the conversion you would have two sets of links - front-end to back-end...

smunson,

Had the same thing happen to me. I tried using the Upsizer through Access 2003. It sucked. It did tables okay, but couldn't interpret simple select queries. It changed...

Scott, excellent choice. I've been successful thus far in converting all the tables and queries, and...

Although at MS site for SQL Server Migration Assistant for Access, they say "SQL...