J
jeffg22
Hi -
I have an Access application that opens and reads Excel workbooks.
The workbooks are formatted and contain data returned by remote users. A
few users seem to be turning Workbook Sharing on, so (for these users) the
'Allow changes by more than one user at the same time' checkbox in Tools ->
Share Workbook is checked.
When the Access app opens the affected workbook, I get a "Runtime error
'1004': Application-defined or object-defined error". This doesn't happen
when the Access app opens the same workbooks from users who don't turn
Workbook Sharing on. And the problem doesn't occur if I first manually check
each workbook and turn sharing off.
This, however, needs to be an automated process. How can my Access VBA code
turn off Workbook sharing on a workbook so it will open without error?
Thanks for your help.
- Jeff
I have an Access application that opens and reads Excel workbooks.
The workbooks are formatted and contain data returned by remote users. A
few users seem to be turning Workbook Sharing on, so (for these users) the
'Allow changes by more than one user at the same time' checkbox in Tools ->
Share Workbook is checked.
When the Access app opens the affected workbook, I get a "Runtime error
'1004': Application-defined or object-defined error". This doesn't happen
when the Access app opens the same workbooks from users who don't turn
Workbook Sharing on. And the problem doesn't occur if I first manually check
each workbook and turn sharing off.
This, however, needs to be an automated process. How can my Access VBA code
turn off Workbook sharing on a workbook so it will open without error?
Thanks for your help.
- Jeff