Neil,

» > That's why we have backups.

» Not very useful on a 24x7 system. How can you restore from your mistake if users are continually entering transactions? «

You beg the...

Derek,

You make some excellent points. Regarding pass-through queries, I've never used them since I skipped right to ADP's and Views.

Joe,

I'm afraid you're SOL there, son. There is a Microsoft Office for the Mac, but it doesn't include Access.

Rasool,

Good point. I find that I re-use a couple saved Views and SP's in an Access Project to get around having to save each one in the production database.

Terry,

A friend on the Access support forum I subscribe to once described his experience of updating an existing Access application. He had been working almost exclusively with Visual Studio...

Andy,

I was also surprised that you didn't mention Access Projects. For those that are EM aficionados, the Access query by example interface is much closer to that in EM,...

Sam,

In answer to your questions:

1) Access is a way to ease into Enterprise Manager for those that are not SQL Server savvy. EM has many capabilities relating to...

David,

I can well believe that an Access quirk was at the bottom of it. Glad I could help you jump start that ol' gray matter.

Regards,

David,

I am not an expert on triggers, but I wonder about something: If you're inserting rows into tblInItem, then there is no Deleted table for you to reference when...

David,

Thank you for that very thoughtful and detailed reply! I will, indeed, look for the MS uninstall utility you mentioned. I haven't dived into the drastic surgery method...

Brian,

Yeah, I've done the same in the past, too. Just keeping an eye open for a more convenient way to do it. Thank you.

Brian,

Thanks for the encouragement. I'll Ghost the drive and polish off the SQL 2005 beta folder.

Any registry irregularity repair tool you recommend? I use Registry Mechanic and the...

Brian,

» Did you upgrade .NET Framework 2.0 or install the production version? «

Excellent question. I'm pretty sure that I either installed it from an MSDN Universal install disk on...

I own my own business and SQL Server work is just a part of it. The basement office is my natural habitat as a result. I'm not much...

Kevin,

>> My thanks again for the resources provided here. <<

Dittoes!