Linking SQL Server table with access forms

Question

Post reply

Linking SQL Server table with access forms

skumaranm

Valued Member

Points: 51
More actions
April 29, 2003 at 1:19 am

#64923

Hi all!
I linked a SQL Server to access DB as several users were using the SQL DB from access forms. But, when I tried to modify a linked table directly by opening the table in the access there comes a cute little 'Write Conflict' message that 'This record has been changed by another user since you started editing it. If you save you will overwrite the other user' and the best part is, it does not let me save !!! Note that, this problem does not occur when updating through a query
Can anyone help me resolve this? Thanks.

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 1

Do you have primary key defined in your SQL Server table?

Edited by - Allen_Cui on 04/29/2003 07:25:02 AM

skumaranm Valued Member Points: 51 More actions · Answer 2

skumaranm

Valued Member

Points: 51

April 29, 2003 at 8:50 pm

#455761

Yes, I do have a column set as the Primary Key.

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 3

Make sure all of columns have been assigned values when insert/update a row.

Data-Man SSC Veteran Points: 291 More actions · Answer 4

Hi...I recently converted an entire access database to use SQL Server tables. I found that sometimes Access wouldn't set the primary key correctly on linked tables. Verify that the SQL Server primary key matches what Access thinks is the primary key. Hope this helps.

mimorr SSCarpal Tunnel Points: 4850 More actions · Answer 5

Make sure you do not have bigint as a datatype in any of your SQL tables.

Make sure your decimal datatypes aren't bigger than (15,4).

Make sure none of your bit fields allow nulls or have nulls in them.

Michelle

Frank Kalis SSC Guru Points: 111183 More actions · Answer 6

Hi,

maybe a little late for an answer, but...

An issue with linked SQL Server tables in Access I stumble over very often is that, every time you change something in the table definition in SQL Server, you should drop the link in Access and connect again. If you don't, Access can behave very strange

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 7

Frank,

You don't have to drop the linked table, Just refresh it.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 8

quote:
You don't have to drop the linked table, Just refresh it.

How do you refresh a link?

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 9

From tools --> Add-Ins --> Linked Table Manager --> select tables you want to refresh.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 10

quote:
From tools --> Add-Ins --> Linked Table Manager --> select tables you want to refresh.

Now I know what you mean. Sure that works, but I prefer to quickly drop the link and relink again. I feel more confident with this

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

PcDave69 Grasshopper Points: 17 More actions · Answer 11

When I've had this error it was caused by setting a default on a bit column that already had nulls in records. To fix, I populated the nulls with the default.