sql table link

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My backend DB is sql server 2000. I have a single table that is not editable
on the frontend with an .mdb and linked tables. The table is editable from
within sql. I've not seen this before. Is there some setting within Access
causing this?
 
Probably a missing primary key on the table. Other possibilities: using a
BIGINT as the primary key, having a nullable bit field, some out of range
decimal field or a trouble with a float or a real field.
 
sylvain is right, every table has to have a primary unique key in sql when
using access as an front end. If you don't have a key you could use an
autonumber and assign this a key (not really fasionable but it will help you
updating your records).

hth
 
Back
Top