" From what I hear MS has abandonned Access Projects."

PLEASE, Stop spreading this terrible rumor! It is not true!

ADPs are alive and well in Access 12 (2006), and the MS...

And yet another problem with this article:  If you are doing serious SQL Server and looking for performance, you should be using an ADP, not an MDB.  In ADPs, T-SQL...

I have had the same problem.  There is something wrong with the script submission process, and I think it may involve human error via the site owner.

"On the other hand, triggers could be used against tables which do not have blob fields. I use it.  it is one of the best methods to add audit component...

"What about adhoc queries using UPDATETEXT/WRITETEXT?"

I would never allow such a thing, unless it was in a custom SP that updated the audit table in later statement.  The same is...

Preethiviraj Kulasingham

1.  "Instead of triggers overright your update statement and you can't refer blob columns.  That means you have no mechanism of updating the blob column through instead of triggers."

This...

I am concerned about the incorrect and unsubstantiated statements made both in the article and by some of the posters.  By now, most of the mistakes have been corrected, but...

Noel,

Thanks.  I have lots of practice!

Nice article.  It's just too bad that there is a need for it.

<Rant On>

Error handling in SQL Server 2000 is utterly brain-dead.  Whenever I can, I prefer to code in...

In the above VBA code (in Module),

I try to use the Command Object 'QTRSALES' and insert the "SELECT YEAR" statement after the "Set rs = cmd.Execute(NumRecs)" statement and I get...

There are several issues with your request.  First of all, pivot tables are generally used to summarize data based on aggregates such as sums and averages, from data stored in...

Wow, I got zinged by the same issue when I started with AppRoles!  There's also a length limit to the PW of ? about 64 characters, I think.  Since I...

I looked at your other post, and and can't see anything wrong with it.  If you are just testing it with a plain text PW, it should work.

You should note,...

Hi Jacob,

I use AppRoles, but I'm not sure what you are asking here.  AppRoles are very useful, because the user may access the database ONLY through your app, and can't get...

Initial Catalog=NorwindCS

Norwind?  I hope that's just a typo.