recordset updatable for me, but not for other users 
Author Message
 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



Sat, 25 Aug 2001 03:00:00 GMT  
 recordset updatable for me, but not for other users
I had sometime the same problem, installation of NT4 SP3 and jet 3.51 had
solved this problem
Quote:

>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




Sun, 26 Aug 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Recordset not updatable

2. Updatable property in ADO recordset -- It's not there

3. Q: Recordset not updatable !

4. recordset not updatable

5. SQL Server JOINed recordsets not updatable?

6. Recordset is not updatable - why?

7. Why is my recordset not updatable?

8. Command-based ADO recordset NOT UPDATABLE????

9. Recordset not updatable after call Stored Procedure

10. Recordset not updatable (VB6/Access97)

11. Why are ODBCDirect recordsets not updatable?

12. How to make recordset updatable

 

 
Powered by phpBB® Forum Software