MS Access ADP project in read only mode...

I have successfully created and connected to my database pulling over the tables yet when I go to edit a record or go into design mode it's in a read only for the edit and a splash telling me I will not get anywhere if I try to make changes to the index... also in the database tab everything is grayed out.  So I first made sure all my MS updates for Access were up to speed... SP2 and on the SQL side a connection can be made.  If anyone has a clue please respond.
EA_ENTAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
Advertise Here
 
MeLindaJohnsonConnect With a Mentor Commented:
On your Data Link Properties dialog box are you using Windows NT Integrated Security, if yes, then it is using whatever you are logged into your machine as, if you are using specific username and password, then you have to specifiy.  Attached is a picture of the dialog box.  when testing I usually use specific name and password but once I am ready to push out, I'll change it to windows nt and and compact the database. dialogbox.docx
0
 
MeLindaJohnsonCommented:
I assume the login has the appropriate permissions?  Did you save the password or do you have to enter it each time?
0
 
EA_ENTAuthor Commented:
I used "NT integrated permissions" for the connection ...
0
 
MeLindaJohnsonCommented:
So when you created the logins on your server you added doman\user and gave it the appropriate permissions?  I've had the same problem before and it always came down to the appropriate permissions for the user logging in.
0
 
EA_ENTAuthor Commented:
Also, I'm logging in as DBO shouldn't that take care of permissions?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.