Hi All,
I have a an Access 2013 accdb database being developed, however I now have a problem where it consistently freezes in the same place (I'm on 64 bit laptop, windows 7).
I have a specific form whereby a command button runs VBA to import 2 files, convert the data based on a set of rules and output a csv file. All files are imported/export through saved specifications. At the end of the VBA, a completion messagebox does display and I can click vbOK, the messagebox disappears then the database is left hanging, except for the ribbon. All VBA procedures have error handling. This appear consistent in that it freezes only on this form, in the same place, I can only exit the same way and no errors ever display.
I've decompiled, deleted binary sections from the form (via text file in notepad), compacted, debugged etc but nothing seems to fix this issue.
I've just attempted to import the database into a newly created blank database, selecting everything (even through "Options"). This is where I had the first error......"Not all of the import specifications could be imported due to name conflicts, conflicts exist in 1 of the specifications....etc". Oddly, the specifications are named differently(2 x import & 1 x export) (viewed via Saved Imports & Saved Exports).
After deleting these specifications and then re-attempting to import into a new blank database the same error occurs. I've tried this twice, once with importing the specifications, once without & recreating but to no joy.
Does anyone have any idea's?
Thanks
Tooley
I have a an Access 2013 accdb database being developed, however I now have a problem where it consistently freezes in the same place (I'm on 64 bit laptop, windows 7).
I have a specific form whereby a command button runs VBA to import 2 files, convert the data based on a set of rules and output a csv file. All files are imported/export through saved specifications. At the end of the VBA, a completion messagebox does display and I can click vbOK, the messagebox disappears then the database is left hanging, except for the ribbon. All VBA procedures have error handling. This appear consistent in that it freezes only on this form, in the same place, I can only exit the same way and no errors ever display.
I've decompiled, deleted binary sections from the form (via text file in notepad), compacted, debugged etc but nothing seems to fix this issue.
I've just attempted to import the database into a newly created blank database, selecting everything (even through "Options"). This is where I had the first error......"Not all of the import specifications could be imported due to name conflicts, conflicts exist in 1 of the specifications....etc". Oddly, the specifications are named differently(2 x import & 1 x export) (viewed via Saved Imports & Saved Exports).
After deleting these specifications and then re-attempting to import into a new blank database the same error occurs. I've tried this twice, once with importing the specifications, once without & recreating but to no joy.
Does anyone have any idea's?
Thanks
Tooley