Data will not store

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

Guest

One of my databases is down.....

It is ODBC linked to an SQL database.
1. When I enter data into MS Access the data does not store.
2. When I enter the data into the SQL table it does store and it's available
in the MS Access database, so the ODBC should be fine.

I have refreshed all the tables, but data still does not store when entered.

Help



When new data is entered it does not store the data.
If I add data to the SQL table is does
 
hi Dan,
I have refreshed all the tables, but data still does not store when entered.
Click to expand...
Are you using the same credentials under Access and SQL Server?
Any nasty triggers?


mfG
--> stefan <--
 
Also, when I make a new form from the same table the navigation button for
adding a new record is disabled. The properties (allow edits, data entry,
allow additions) are all set to yes...
 
Any change I make in the SQL table stores fine and instantly is updated in
the MS Access table.

But any change I make in the MS Access database - I get the Recordset is not
updatable!!!!

Please help I have a team that cannot enter there data.

Thanks
 
hi Dan,
Any change I make in the SQL table stores fine and instantly is updated in
the MS Access table.
But any change I make in the MS Access database - I get the Recordset is not
updatable!!!!
Click to expand...
Access/Jet has not the necessary primary key information.

Check your linked table, if it has the same primary key set just like
the table on the server.
Contains the primary key any unprecise data type (float or real)?

mfG
--> stefan <--
 
Back
Top