access 2013 error 3343

Question

when I use vba it happens very frequently

any suggestion ?

thanks

Answer 1

So you get that message when you are trying to re-open the file after making some changes in VBA? And the filename listed is the one you are trying to open? Does this only happen with one Access db or others? 

I would completely uninstall Office, then reinstall it.

Answer 2

most of my tables are stored in sql server database

few are local tables that actually use as temporary tables

the access app does not connected to  other server or other app

is it the local tables or it is connected to  references ?

what  can I do to avoid that error ?

Answer 3

The message indicates that an accdb file is corrupted. Are you linking to any file other then the SQL Server tables? Are you working on a local copy of your front end or is it stored on a network share?

Answer 4

thanks for your answer

the massage is " unrecognized database &'name of access file'.accdb "

it happens after coding forms with visual basic

compact and repair usually does not succeeding and I need to use the backup file

ן am using access for long time it happened only recently 

my app is linked to sql server 2014

I tried reinstalling office but no better results

I tried moving to new file and importing all forms and reports but still same problem

any idea?

thanks

Answer 5

What is the exact message. Please define what you mean by "use VBA"?