i'd try running a profiler trace and look at the sql either side of the error.

unless this only ever occurs once in a blue moon?

have you tried using merge replication...

does this happen after a certain event? perhaps after a failed write to the table?

i'm guessing you're using identity columns? - if i knew 2 years ago what i know...

Am I missing the point here? you could create a fixed size form, ensure that the border size is set to thin (therefore not alterable in size) and then add...

from SQL to Excel?

this looks a lot like msaccess

what account is your SQL server service running as? is it loalsystem?

it sounds like the problem may relate to the windows permissions of the SQL server service. - can...

i know it sounds stupid, but are you using the proper 3 part nameing conventions for your tables in the view

e.g. master.dbo.sysusers

if your create view statement is attempting to...

SCRATCH THAT LAST QUESTION - I'VE GOT IT NOW

i can use objectproperty(tablename,'CnstIsNonclustkey') and objectproperty(tablename,'CnstIsclustkey')

Carl, thats great, Top Man - i've been looking for sysindexes.status breakdown everywhere.

with respect to the primary keys though how can i identify these? i can't afford to have this...

Fantastico.

i should have realised there was a save button there!

Service Pack 4 fails to install if you LOG P.I. installed.

the replout.sql script fails.

in order to solve the problem stop the Log PI services.

in the meantime can i suggest a very easy alternative

i use a program called blat.exe which is an smtp mail client.

if you want to send an email (and...

do you have some examples?

have previously seen KB articles about this, relating to the exchange server being unavailable for the address book lookup.

i'd definatley recommend making sure your emails specify the full address...

what version of outlook do you have installed on the SQL server?

if i understand correctly your form may be doing something along the lines of

dim db as database

set db=currentdb()

dim qdef as new querydef

set qd=db.querydefs("myquery")

qdef.sql="create table dbo.mytable.......blah blah....."

you can then simply...