using Access with SQL Server??

  • Thread starter Thread starter Jerome
  • Start date Start date
J

Jerome

Hi there,

I've created a DB on Microsoft SQL server and I'm now defining the
front-end in Microsoft Access 2000.

The tables are linked and the data already in the DB gets displayed
without problems but if I want to make changes or edits I get the
following error: "This record has been changed by another user since you
started editing it" and I can't save then! But I'm the only one editing
it right now!!!

What happened? Or where can I find some more info regarding the Access
<> SQL Server connection? Do I need to create special users or something
like that? Or is there something on the ODBC level??

Anyhelp is greatly appreciated,

Jerome
 
also, if you're using recordsets add the option dbseechanges
ie
db.openrecordset("...",dbopendynaset,dbseechanges)

Pieter
 
hmm, no ... It worked once to edit and save a record, but I tried
another one now and the original error message pops up again :/
 
SQL Server bit fields are 3 state by default: Yes No Null
Jet 4 does not support 3 state bit fields.

When you connect Access to SQL Server, all bit fields with
value Null are translated as "false". When Jet compares
the "false" value to the original "Null" value, it reaches
the conclusion that someone else must have changed the data.

You can change all SQL Server bit fields to integer fields,
or change them so that they cannot or do not have null
values.

(david)
 
Back
Top