sql - Access Database corrupted? -


i have database living on network drive 10-20 users on front ends @ 1 time. lately have been getting lot of weird errors.

after research seems 1 table in particular on corrupted. i've tried "compact , repair", freezes. tried selecting/deleting records read "#error" , "not valid bookmark" error, hit ok, "not valid bookmark. cycle repeats 10 12 times stops.

enter image description here

at moment can't export data. access freezes.

the "#error" field has taken on maybe 3-5% of database.

how can salvage of data possible , prevent happening again?

is there can use in sql or vba delete corrupt records?

i didn't have error on local tables yet, try following:

  1. be sure nobody working in database (there should no .laccdb file in database folder)

  2. copy database file. make sure things won't worse.

  3. use start > run... window open database parameter "/decompile" (for example "c:\program files\microsoft office 2007\office12\msaccess.exe" "c:\access\yourdb.accdb" /decompile)

  4. use "compact , repair" again.

if still doesn't work, create new database , import tables of database. if doesn't work, too, don't have idea how save tables. hope made recent backup of db.


Comments

Popular posts from this blog

Rendering JButton to get the JCheckBox behavior in a JTable by using images does not update my table -

javascript - Using jquery append to add option values into a select element not working -

Android soft keyboard reverts to default keyboard on orientation change -