Thanks Liz & Bill for your comments, on my unfortunate action.
I had a backup of about one day a old and I restarted from there.
But, rethinking the situation, I have the feeling Microsoft leaves us Access-users alone on this issue.
Other MS-programs have auto backup functions (especially in Word) that create a backup every 10 minutes or so.
Why not in MSaccess? Have you, MSaccess MVP's, ever asked to build in this feature?
I can imagine this is too time consuming, but why not make an backup at each close of an msaccess session?
A second question is : It know it is possible to undelete data from a table.
How does MsAccess store query data and form data? Also internally in tables? Then an undelete might be possible from there, too.
I can read the system tables MsysObjects and Msysqueries. Couldn't one restore at least queries from there?
The system tables are read-only which is a good safeguard, but a recovery procedure could use that information.
Third question: How is the code behind forms and from modules stored in the database? I do not know a system table for this,
But I know there is something like a codeproject object, could one manipulate data from there?
Fourth question: the new accdb format, does that have more options for recovery (mine was an MDB)?
What advantages does that format have anyway?
Just a few questions, I'd like to have your opinions on
Onno
Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar