E
Earl Owens
I have a test MS SQL Server on a stand alone. I did a test
connection to the database I call input with an Access
project. The tables imported okay and I can read data.
Further I can change the tables (add or remove columns)
however I can not write new data to any table. I have
looked at add data/write permissions every where I can
think of. I use Windows Authentication to log on.
I tried, just to see what would happen, to connect to the
Northwind database with Access and I could write data with
Access there. I tried to duplicate everthing I could as to
how the northwind data base worked in the input database
with no success. What am I missing?
connection to the database I call input with an Access
project. The tables imported okay and I can read data.
Further I can change the tables (add or remove columns)
however I can not write new data to any table. I have
looked at add data/write permissions every where I can
think of. I use Windows Authentication to log on.
I tried, just to see what would happen, to connect to the
Northwind database with Access and I could write data with
Access there. I tried to duplicate everthing I could as to
how the northwind data base worked in the input database
with no success. What am I missing?