G
Guest
I have a Microsoft Access Project (MS Access 2003) with an existing SQL
Server DB (SQL Server 2000) with a variety of different tables. I can enter
data directly into all tables in Enterprise Manager, I can enter data into
all tables with SQL in Query Analyzer or as a stored procedure in the
Microsoft Access Project. However, I can only enter data into one table in
Microsoft Access and none of the others. I have tried entering the data in
the datasheet view or by means of a form, but the data entry option is not
available in any of the tables except for one. What would cause this? I have
a need for users to update data in tables by means of a form within the
Microsoft Access Project, but the add record option is not available for any
of the tables except one.
Thank you for your help,
Tommy Watrous
Server DB (SQL Server 2000) with a variety of different tables. I can enter
data directly into all tables in Enterprise Manager, I can enter data into
all tables with SQL in Query Analyzer or as a stored procedure in the
Microsoft Access Project. However, I can only enter data into one table in
Microsoft Access and none of the others. I have tried entering the data in
the datasheet view or by means of a form, but the data entry option is not
available in any of the tables except for one. What would cause this? I have
a need for users to update data in tables by means of a form within the
Microsoft Access Project, but the add record option is not available for any
of the tables except one.
Thank you for your help,
Tommy Watrous