Button stops working

I have access 2007

I create simple form that has one button. It has only one vb script that
makes a msgbox appear.

The button and code works fine, but after i save the access file, it stops
working!

Only way to get it back working is rename the file to accdb - accdr, so it
opens the file in "read" mode and the button works. In work mode it doesn't.
No errors, just doesn't do anything.

Is this a bug or what?

I have some tables in the file that are linked via ODBC, but they shouldn't
have anything to do with the button.

I tried creating the file from scratch, but the problem repeats itself again.
First the button works and msgbox appears, then it stops working. All by
itself!

I'm going crazy with this problem.
I can send the example file if somebody provides email, so they can study it.

make sure you have the location of your file as a Trusted location in the
Access security

"Poppe" wrote:

I have access 2007

I create simple form that has one button. It has only one vb script that
makes a msgbox appear.

The button and code works fine, but after i save the access file, it stops
working!

Only way to get it back working is rename the file to accdb - accdr, so it
opens the file in "read" mode and the button works. In work mode it doesn't.
No errors, just doesn't do anything.

Is this a bug or what?

I have some tables in the file that are linked via ODBC, but they shouldn't
have anything to do with the button.

I tried creating the file from scratch, but the problem repeats itself again.
First the button works and msgbox appears, then it stops working. All by
itself!

I'm going crazy with this problem.
I can send the example file if somebody provides email, so they can study it.