
recordset updatable for me, but not for other users
I have a split database, hosted on an NT4.0 server. My forms are all
UNBOUND, so there is no open table at the time of this error. I am using
LINKED tables. There is no Access security in place (ie, we all log in as
Admin - hey *I* didn't do it!! I inherited it :-).
With an unbound form open, upon a button click, I have code that,
essentially, does this:
dim db as database
dim rs as recordset
set db = currentdb
set rs = db.openrecordset("linked_table", dbOpenDynaset)
rs.addnew
rs!Field1 = "Something-or-another"
rs.update
So long as it is ME logged in (to the NT network), this runs FINE. But my
users get:
"Database or object is read-only."
I have set up the directory's NT Permissions with ALL USERS having
FULL-CONTROL - just like myself. I suspect something with the NT
File-system's OWNERSHIP. I am the owner of the file in the NT File System.
Any ideas?
Kirby L. Wallace