Rabu, 24 Juli 2013

[MS_AccessPros] Deleted forms and queries - some questions and thougths

 

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)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar