here's my advice.

go through enterprise manager and ensure all your tables have primary keys

drop all of your linked tables in access

re-link all of your tables in access - it...

i'm guessing here but i bet you have to be a memeber of diskadmin as a minimum?

can't you just use query analyser and use the output to file function ?

the other ones i forgot to mention that just came back are...

if you have BIT/Boolean fields in SQL server and they are linked to Access then you must add a...

is there any vb code behind the form to generate the recordset?

or is it just a collection of fields that are data bound to the query.

if you upsize access to...

good point - have you missed disabling a trigger?

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!