I've looked at this from every conceivable angle, and still I come up with a big ZERO. Yet, even if I don't want to bug you too much, I would be grateful if you come up with some other ideas. It might be a problem in the future if I will have to modify the database on site when the customer already has data in it, because there ADOX comes handy, but I will think about it when it comes. Quite honestly I am thinking to bypass ADOX considering that the same can be done without it. I shouldn't use it to develop commercial products but hell I paid good money to Microsoft for the italian one.Īnyway the problem is still there, even if I tried to delete the reference and point again to it, and also changed the order of the references (sometimes it affects the behavior). Now I have reinstalled again Office, this time the US version. I also tried to move the function to a brand new module thinking that maybe that specific module could be corrupted (never heard about it but when you are desperate.). I thought about it so I retyped all the declarations. dll, specifically the one which provides the ADOX functionality (Msadox.dll).Īnd yes the intellisense works. Please if anyone can help because I am now out of resources.Įverything looks fine - the only logical explanation, in my mind, would be a corrupt. 2.8 for DDL and security" and it points to the, I guess, correct Msadox.dll. The reference to the adox library is "Microsoft ADO Ext. The error information on crash are the following but to me they don't mean anything:ĪppName: msaccess.exe AppVer. I then installed service pack two of office 2003 and no better. I tried reinstalling it, import the whole db into a new access file, apply the functions to different tables, empty or not. When it gets to the line "set tbl=cat.tables(strtable)" access crashes. This function has always worked perfectly. StrSql = "DELETE FROM "Ĭat.ActiveConnection = CurrentProject.Connection
#Adox camera value code
I am having a problem running the following code downloaded from the tips of Allen Browne:įunction DeleteAllAndResetAutoNum(strTable As String) As Boolean
0 kommentar(er)
