Hi Everyone,
All the very best for 2004!!
i need urgent help with this problem, the users are about to skin me
alive!!
we have an access front end with linked to sql server 2k tables.
when a user tries to insert a record into one of the tables it
"randomly" returns a generic ODBC error and fails to save. on other
occasions the same record will save.
a trace was applied and the following select seemed to appear right
after the insert statement whenever it failed:
select substring('NY',status/1024&1+1,1) from master..sysdatabases
where name=DB_NAME()
i had a look at other articles in the groups re this select statement,
but could not find a clear answer.
i have tried the insert statements as both SQL pass throughs and just
plain docmd.runsql's
can someone help me with the following:
* what is the purpose of the select?
* what other investigations can i do to get more info on why this
should be happening?
* how can i stop it?
the table i am doing the inserts into is showing as have a numeric
data type field in sqlserver, but the linked table shows this numeric
field as text - could this be the problem?? this field is not used in
the insert statement.
i could not find any references in the MS knowledge base.
any and all help would very gratefully received.
Edwinah63