ODBC Tables

[Guest]

I developed a new database the tables are linked ODBC to SQL tables.
I deleted my test data from the tables then tried to enter actual data and
the tables are not updatable, even the navigation buttons are disabled??
The SQL tables and Access tables look identical.
Any ideas, I'm about exhosted all of mine.

Thanks

 

[Stefan Hoffmann]

hi Dan,

I developed a new database the tables are linked ODBC to SQL tables.
I deleted my test data from the tables then tried to enter actual data and
the tables are not updatable, even the navigation buttons are disabled??
The SQL tables and Access tables look identical.
Any ideas, I'm about exhosted all of mine.

No primary keys in your linked tables. Drop them and link them again.

mfG
--> stefan <--

 

[Guest]

Is it a manditory thing to have a primary key between Access and the SQL db.
Because in the Access application I really don't need a primary.

 

[Douglas J. Steele]

Using ODBC, a table will not be updatable unless it has a unique index on
it. (It needn't be a primary key, but if it's a unique index, why wouldn't
you make it the PK?)

 

[Stefan Hoffmann]

hi Dan,

Is it a manditory thing to have a primary key between Access and the SQL db.

Yes, becaus Access/Jet needs to know which data rows are affected if you
insert, edit or delete data rows.

Because in the Access application I really don't need a primary.

Every linked table without a primary key is not changeable. Also linked
views are generally not changeable, if you don't create a virtual
primary key for Jet.


mfG
--> stefan <--