John, flippin brilliant. I didn't even know that there was a LoadFromText function. What clever use of Access and coding. Nice.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, September 06, 2016 7:50 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Different versions of Access
Liz-
It uses SaveAsText to dump each object to a text file, then runs through the text file and removes stuff that could have gotten messed up with Name AutoCorrupt, the printer data, and the controls added by 2010. You can then use the same tool to try to import the text files (LoadFromText) into a new blank database that has AutoCorrupt turned off. I originally wrote the utility to fix Name AutoCorrupt issues, but expanded it to try to deal with the new controls that 2007 doesn't recognize.
John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
(Paris, France)
On Sep 6, 2016, at 4:39 PM, Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
John, I admit I am intrigued! So what does your FixBroken utility do?
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Sunday, September 04, 2016 11:19 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Different versions of Access
The short answer is yes, later versions of Access add controls that are unrecognized by 2007. All you have to do is open one form or report in Design view, then you're toast for going back. (You don't have to make changes or save.)
You can try my FixBroken utility in the Files section, but it's not guaranteed to work for databases modified in 2016. It was originally built to deal with 2010.
John Viescas, author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Access Applications
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (6) |
Tidak ada komentar:
Posting Komentar