when is table updateable / appendable?

N

Neil Jarman

Hi,

I'm using Access as a front end to SQLserver tables.

When I have certain joined queries, I can't update or create new records,
even though the two joined tables are linked by a primary key.

I know in my mind that the data should be updateable, and can't see where
I'm going wrong.

I'm not sure what rules are being broken, but is ther a reliable way of
understanding what I can and can't do in these cases?

many thanks,

NEIL
 
J

JohnFol

Hi Neil, this isn't meant to be sarcastic but there is a great page within
the help system of access that goes through most of the rules.

I did a search and found a help topic called "about updating data"
Might be worth a quick read.

If you still think the data should be updatable, try the same action in SQL
to rule out Access.
 
J

John Spencer (MVP)

I've found that MS SQL tables usually need a TIMESTAMP field for them to be
reliably updatable from Access.

AS A TEST
-- Copy the tables to your database as Access tables
-- see if you can update and append to them with your query.

If so and they don't have a TimeStamp field (this is not a date time field it is
a field that contain data of the type TimeStamp), then you have probably
diagnosed the cause of the problem and the needed solution.

Good luck
 
Top