I wrote a sub last year to copy tables from an archived backend into the live database.
It has been working fine for the past 10 months but now all of a sudden is giving me a Run-Time error '3251': Operation is not supported for this type of object.
Here is a bit of test code that I set up in a new database and I get the same error.
The fact that I am getting the error in a brand new database seems to indicate that some sort of office update is to blame but I am not sure how to verify that. I am using office 365.Code:Sub test() Dim dbPath As String Dim tblName As String dbPath = "S:\DataHome\BidBunker_DATA.accdb" tblName = "tblBookmarks" DoCmd.RunSQL "SELECT * INTO newTable FROM " & tblName & " IN '" & dbPath & "'" End Sub
any ideas? thanks in advance