469,945 Members | 1,379 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,945 developers. It's quick & easy.

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

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_Click()
On Error GoTo Err_Command171_Click

Dim strReportName As String
Dim strFilter As String

Me.Refresh
strReportName = "rptEstimate"
strFilter = "EstimateID = Forms!frmestimate!EstimateID"
DoCmd.OpenReport 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
Feb 29 '08 #1
1 1442
ARC
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?

<te********@hotmail.comwrote in message
news:da**********************************@b1g2000h sg.googlegroups.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_Click()
On Error GoTo Err_Command171_Click

Dim strReportName As String
Dim strFilter As String

Me.Refresh
strReportName = "rptEstimate"
strFilter = "EstimateID = Forms!frmestimate!EstimateID"
DoCmd.OpenReport 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
Feb 29 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

49 posts views Thread by Allen Browne | last post: by
2 posts views Thread by Ntl News Group | last post: by
13 posts views Thread by evancater | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.