A
alan
I am connecting an adp in access2003 to an sqlserver2000
database.
I can create a new table using the access/adp interface.
The table is then on the server.
I can delete/drop that table using the access/adp
interface.
I cannot add rows or edit rows via the access/adp
interface by opening the table in "datasheet" view.
I can add rows by writing sql (t-sql) "queries".
(and I can see these added rows via datasheet view).
How can add/edit rows in I "datasheet" view? Do I need to?
I have the same type of problem when I use the table name
as the RecordSource in a Form, i.e. I can see any existing
rows in the table - but i cannot add/edit rows.
anyone else have this problem?
alan
database.
I can create a new table using the access/adp interface.
The table is then on the server.
I can delete/drop that table using the access/adp
interface.
I cannot add rows or edit rows via the access/adp
interface by opening the table in "datasheet" view.
I can add rows by writing sql (t-sql) "queries".
(and I can see these added rows via datasheet view).
How can add/edit rows in I "datasheet" view? Do I need to?
I have the same type of problem when I use the table name
as the RecordSource in a Form, i.e. I can see any existing
rows in the table - but i cannot add/edit rows.
anyone else have this problem?
alan