can not add or modify records

M

marwan hefnawy

I'm new to access projects
I can not add, modify, or delete records from the MS SQL DB through the MS
access project.
Is there some settings that I should make?
Thanks.
I' using access XP , SQL server 2000 SP3
 
L

Lynn

Have you checked your permissions on the tables, views,
sp, etc in SQL.

Also, make sure your control source has dbo. in front of
it on the Access side on all forms.
 
Top