can not add or modify records

  • Thread starter Thread starter marwan hefnawy
  • Start date Start date
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
 
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.
 
Back
Top