Juanita,

My advice was based on access ADP projects not on ACCESS linked tables!

For linked tables you just have to rename the link as suggested by Logan above (which you...

Which version of ms access is your developer using ?

As far as I remember you can change settings in the access front end so that the code can be transparent to...

I would not run that code !

sp_changedbowner not only touches the sid from sysdatabases it also updates sysusers (sid, status and updatedate)

Try...

exec sp_update_resume

Donald,

1. The "inserted" virtual table is an image (in structure) of the Table where the trigger was defined. Therefore it does not matter what field the application is sending to...

If you think that the queries above are not simple how in the world the RAC4SQL package made up of a ton of code would seem simpler ?

Your initial code would do it just uncomment the where clause.

For Update triggers use the construct:

IF UPDATE(PkgCodeID)

 begin

  --- Your Code Here

 end

 and for the delete trigger just use the "deleted"...

Don't get me wrong, VB scripting is extremely easy to use and plays very well with DMO, ADO, WMI and CSCRIPT objects.

The problem comes in to play when you...

>> Forgive my ignorance, but what can PERL do what Windows scripting cannot do? <<

String parsing and manipulation power of Perl is very difficult to achieve on any of the...

Ramona,

If the column in which you have the xml is not a text column you may have a little easier path, but if it is

have a look at this (this...

Best approach I have found from most angles to this problem is to use 4 tinyint columns

Just my $0.02

nicki ,

I am sorry I wasn't explicit enough I put q in red and bold on my query and assumed it will...

My Post was meant as an example of what to do or at least how to accoplish it.

NO MATTER what rule you follow there are going to be always execptions....

SQL Server reads Extents which are nothing but eight Pages. The fuller the pages the less I/O it will have to perform to get the requested data.

HTH

That is exactly why this recomendation is for a system with a LARGE amount of processors!