Access 2007 with Windows 8 Runtime Error 2486

[WickyScratch]

I am currently working on an Access 2007 application for a non-profit with a low budget.

I was just informed that they are having issues on two machines that they upgraded to Windows 8 from 7. I was not advised that there would be OS upgrades when the project was scoped and started.

They receive runtime error 2486 in a "Resize" event. There *IS* an "Open" event as well.

I wonder if maybe the code is processing too fast, and if maybe I need to add a timer of some sort within?

The code it errors on is the Docmd.RunSQL line in the following:

Dim tbl As TableDef

        For Each tbl In CurrentDb.TableDefs
            Select Case Left(tbl.Name, 3)
                Case "tmp"
                    DoCmd.RunSQL "DROP TABLE " & tbl.Name & ";"
            End Select
        Next tbl

 

[CJ_London]

a couple of things to try

use docmd.deleteobject...
use currentdb.execute...

Also, I presume this is a multiuser environment - is someone else accessing the table preventing its deletion?

Have you tried decompile/recompile and then compact?

If they have upgraded from win7 to 8, is it possible they have installed 64bit office rather than 32bit? (or perhaps the other way round?)

 

[WickyScratch]

It is multiuser, but on a small scale. The table that is being deleted is a local temporary table that is part of the front end. The application works as written on all of the non-Windows 8 machines, which is what is baffling me.

I'll ask about the 32 vs 64 bit, though. I know she had to re-enable macros, but then encountered this issue.

Thanks!

a couple of things to try

use docmd.deleteobject...
use currentdb.execute...

Also, I presume this is a multiuser environment - is someone else accessing the table preventing its deletion?

Have you tried decompile/recompile and then compact?

If they have upgraded from win7 to 8, is it possible they have installed 64bit office rather than 32bit? (or perhaps the other way round?)