dba's moved linked table and I lost ability to edit

  • Thread starter Thread starter gwenzel
  • Start date Start date
G

gwenzel

It was working fine unti the table was moved to our
production environment. They claim that I have the
proper credentials but I can't change any data in the
table. All the appropriate attributes are checked read
only. Is there any kind of a tool to check this? Any
one run into this before?
 
I just love it when I hear from 'they' that you have all the appropriate
permissions, when in fact you don't. All users of an Access database must
have write privileges so that they can open the database for editing. If you
don't have write privileges then when you try to open the database, Access
can't open the .ldb (lock file) that controls optimistic/pessimistic
locking.

They must make sure you have not only read, but write, modify/change
privileges to the database itself as well as the folder that the database
resides in. This is at that permissions level of the network. If you have
Access security (internal to Access) set on the database itself this is
different and should not be confused with network level security.

Hope this sheds some lights.
 
Oh yeah, I forgot one other thing. Most likely you need to link your
database to the new location. Try opening and executing Tools | Database
Utilities | Link Table Manager. Until you do this, you won't get access to
your table's new location.
 
Thanks for your input. They have aggreed to meet with me
and I want them to open the databse perms with sql
enterprise manager and show me the perms on the tables!
 
Back
Top