I'm trying to insert a record into an attached SQL server 6.5 table from
an Access 97 database. I get an error 3155 insert failed on attached
This happens from both a bound form and trying to insert into the table
directly from Access. I do have full permissions, no rules, and the all
the fields are filled out correctly.
When doing a trace from SQL server we can see the data is coming across
correctly and can perform the Insert from SQL Server enterprise manager
with no problems. What can be the problem?
We are using NT server with SP3 Access 97 with SP1 and ODBC ver.
18.104.22.168 and SQL server driver ver. 2.65.0240.
SQL server has SP 4.
Craig M. Bobchin