Hi,
I've been suffering with this for a while but i've finally had enough of it now.
If i try and save my project when there are more than 2 access forms that need changing (basically when it tries to save two access forms at the same time) it fails to do so and locks up.
I get a warning message 'unable to update, currently locked'. It then returns me to the save dialog and if i cancel or say no to all the dialog closes and then it becomes impossible to interact with access in either the main access window or the access VBA window.
If i click on the close button i get the following error message:
'You can't exit Microsoft Access now
If you are running a Visual Basic Module that is OLE or DDE you may need to interupt the module'
I'm sure i don't have one running and if i did i have no way of interupting it anyway. If i try and click on anything the app just makes an odd click sound back at me and i have to Crt-Alt-Del and End task to stop Access, restart it and then i've lost all my changes.
Its suprisingly difficult to remember this and sometimes even if you have made no changes to the other form it still happens.
There must be a way around this, i doubt even Microsoft would allow a problem like this to exist.
Please help
I've been suffering with this for a while but i've finally had enough of it now.
If i try and save my project when there are more than 2 access forms that need changing (basically when it tries to save two access forms at the same time) it fails to do so and locks up.
I get a warning message 'unable to update, currently locked'. It then returns me to the save dialog and if i cancel or say no to all the dialog closes and then it becomes impossible to interact with access in either the main access window or the access VBA window.
If i click on the close button i get the following error message:
'You can't exit Microsoft Access now
If you are running a Visual Basic Module that is OLE or DDE you may need to interupt the module'
I'm sure i don't have one running and if i did i have no way of interupting it anyway. If i try and click on anything the app just makes an odd click sound back at me and i have to Crt-Alt-Del and End task to stop Access, restart it and then i've lost all my changes.
Its suprisingly difficult to remember this and sometimes even if you have made no changes to the other form it still happens.
There must be a way around this, i doubt even Microsoft would allow a problem like this to exist.
Please help
