Hi
I have an Access database (which only I use) with a table.
I have a Word doc which uses this table as it's data source.
I launch the Word doc with via VBA from Access and it works well unless I've been tinkering with the form designs in Access, in which case I get the message:
Error has occurred: the database has been placed in a state by user xxxxx on machine yyyyyy that prevents it from being opened or locked.
It's no problem to get around this - I just close Access and re-open it.
However, is there a bit of VBA that could detect if Access is in this state before I launch the Word docs? - something like application.dirty = true or something?
Thanks!
I have an Access database (which only I use) with a table.
I have a Word doc which uses this table as it's data source.
I launch the Word doc with via VBA from Access and it works well unless I've been tinkering with the form designs in Access, in which case I get the message:
Error has occurred: the database has been placed in a state by user xxxxx on machine yyyyyy that prevents it from being opened or locked.
It's no problem to get around this - I just close Access and re-open it.
However, is there a bit of VBA that could detect if Access is in this state before I launch the Word docs? - something like application.dirty = true or something?
Thanks!