2007 - 2010 code issue

[jcaptchaos2]

I know there is issues with creating access databases in 2010 and then not being able to open them with 2007 but wanted to know if there is a way to not my code stop at the debugger on this part of the code when running it on a machine with 2007. I tried installing access runtime 2010 on the pc with office 2007 but the code still stops here. It runs fine with any machine that has 2010.

Set MyDatabase = DBEngine.OpenDatabase _
("N:\Fishbowl Databases\Time Clock Min.accdb")
Set MyQueryDef = MyDatabase.QueryDefs("Payroll Time Detail by Dept-Shift")

 

[Ralajer]

JC,
Not sure I fully understand your requirements.

wanted to know if there is a way to not my code stop at the debugger on this part of the code when running it on a machine with 2007

But you can test what version of the software is running using Application.Version and handle for each case

    If Val(Application.Version) < 12 Then
        MsgBox "Running version earlier than 2007"
    ElseIf Val(Application.Version) = 12 Then
        MsgBox "Running 2007"
    ElseIf Val(Application.Version) = 14 Then
        MsgBox "Running 2010"
    End If

 

[jcaptchaos2]

Rob,
Thanks fo in.r replying, I think it may be just a security issue on our server, I will check when I get in tomorrow as when I tried to run the macro on another pc with 2007 it was with another user log