sql table link

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?
 
S

Sylvain Lafontaine

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

tinkering with split databases 0
Why won't Access assign a Primary Key ID to my linked SQL Table? 2
linking an access front end db tbl to a backend tbl lnkd to SQL 2
Trouble with split database 3
Access 2007 FE/SQL 2005 BE - Fatal errors occurring 4
(Object invalid or no longer set) 5
Unsplit database 3
Linking Tables from SQL Server 1

Top