Data will not store

D

Dan @BCBS

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
 
S

Stefan Hoffmann

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 <--
 
D

Dan @BCBS

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

Dan @BCBS

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
 
S

Stefan Hoffmann

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 <--
 
D

Dan @BCBS

Very strange - somehow my Primary key became not primary....
All I did was make it primary in the SQL table and everything is fine....
Wish I knew how that happen...

Thanks
 
S

Stefan Hoffmann

hi Dan,
Very strange - somehow my Primary key became not primary....
All I did was make it primary in the SQL table and everything is fine....
Wish I knew how that happen...
Click to expand...
Using the link manager or using TableDefs(Item).Relink may drop this
information.


mfG
--> stefan <--
 
Top