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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top