ODBC Tables

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

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
 
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.
Click to expand...
No primary keys in your linked tables. Drop them and link them again.

mfG
--> stefan <--
 
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.
 
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?)
 
hi Dan,
Is it a manditory thing to have a primary key between Access and the SQL db.
Click to expand...
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.
Click to expand...
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 <--
 
Back
Top