• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 380
  • Last Modified:

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.
0
EA_ENT
Asked:
EA_ENT
  • 3
  • 2
1 Solution
 
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
 
MeLindaJohnsonCommented:
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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now