Access 2k code doesn't run under Vista/A2k7

[teddysnips@hotmail.com]

I have a new client who has an Access 2000 database that used to run
under Windows 2000 Pro. They have just "upgraded" to Access 2007
under Vista, and the old database stopped working - buttons on forms
did nothing.

When I first looked at it the problem seemed to be the change to the
signature of Docmd.Requery (fewer arguments) so I made the necessary
changes and the database compiled. I compiled and tested it on my
work system (also Vista, A2k7) and it worked fine.

When I copied the db onto the client's machine, it didn't work. I
checked that it compiled correctly (it did) but when I hit the
buttons, nothing happened. I put a breakpoint in the code and it
never hit. An example of the code (by the way, I didn't write the
code, and I don't know who did - I was just called in to help):

Private Sub Command171_Clic k()
On Error GoTo Err_Command171_ Click

Dim strReportName As String
Dim strFilter As String

Me.Refresh
strReportName = "rptEstimat e"
strFilter = "EstimateID = Forms!frmestima te!EstimateID"
DoCmd.OpenRepor t strReportName, acViewPreview, , strFilter


Exit_Command171 _Click:
Exit Sub

Err_Command171_ Click:
MsgBox Err.Description
Resume Exit_Command171 _Click

End Sub

A breakpoint on any of the lines is just not hit. In other words, it
looks like the code isn't running. I've tried creating a brand new
2007 database and importing all the objects - exactly the same
result. The code compiles, but doesn't run.

Any thoughts?

Thanks

Edward

[ARC]

Re: Access 2k code doesn't run under Vista/A2k7

I like how you put upgraded in quotes... :)

I wonder if they're not responding to the security message that's disabling
all macors, etc.? Do you know if they added the folder as a trusted
location?

<teddysnips@hot mail.comwrote in message
news:da4a3cc5-a1b6-4b7e-9efe-283513865876@b1 g2000hsg.google groups.com...

>I have a new client who has an Access 2000 database that used to run
under Windows 2000 Pro. They have just "upgraded" to Access 2007
under Vista, and the old database stopped working - buttons on forms
did nothing.
>
When I first looked at it the problem seemed to be the change to the
signature of Docmd.Requery (fewer arguments) so I made the necessary
changes and the database compiled. I compiled and tested it on my
work system (also Vista, A2k7) and it worked fine.
>
When I copied the db onto the client's machine, it didn't work. I
checked that it compiled correctly (it did) but when I hit the
buttons, nothing happened. I put a breakpoint in the code and it
never hit. An example of the code (by the way, I didn't write the
code, and I don't know who did - I was just called in to help):
>
Private Sub Command171_Clic k()
On Error GoTo Err_Command171_ Click
>
Dim strReportName As String
Dim strFilter As String
>
Me.Refresh
strReportName = "rptEstimat e"
strFilter = "EstimateID = Forms!frmestima te!EstimateID"
DoCmd.OpenRepor t strReportName, acViewPreview, , strFilter
>
>
Exit_Command171 _Click:
Exit Sub
>
Err_Command171_ Click:
MsgBox Err.Description
Resume Exit_Command171 _Click
>
End Sub
>
A breakpoint on any of the lines is just not hit. In other words, it
looks like the code isn't running. I've tried creating a brand new
2007 database and importing all the objects - exactly the same
result. The code compiles, but doesn't run.
>
Any thoughts?
>
Thanks
>
Edward