Sharing Issue

[Max]

Have a linked table from an mdb on another PC. When trying to update a
record in this table using the command line: Set
rb=CurrentDB().OpenRecordset("MyTable"), I get run-time error 3734: 'Database
has been placed in a state that prevents open or lock' when the table is open
for editing in its own database.
Default Open Mode for both databases is Shared. Didn't see anything in KB
that helped.

Thanks in advance.

 

[Margaret RM]

Hello,

I have this same problem. Did you get it resolved? I have researched the
error 3734 but can get no useful information. I have checked everything like
you - the database is 'shared', all users have rights to the folder, the
macro security is set to low, the database has been compacted and repaired,
etc etc.

I would appreciate any help you can pass my way.

Thanks,

Margaret

 

[Max]

No answer to this post. I have tried it again under the Access Security
topic, with the title Error 3734 on Linked Table. Am still hopeful of some
help here. Will keep you posted.

 

[Margaret RM]

Thanks. I put a new post under General Questions. I will let you know if I
hear anything.
Margaret

 

[Margaret RM]

Hi again,

I got someone else to look at it and when we unchecked all the Startup check
boxes it seemed to unlock it or change it from exclusive to shared. I don't
understand why it made a difference but it did. I think the Allow
Toolbar/Menu changes option was the key but I don't really know. Hope that
helps. Margaret