Sabtu, 10 September 2016

Re: [MS_AccessPros] Different versions of Access

 

Steve-

It's in the 0_Utilities and Add-Ins folder.

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

On Sep 10, 2016, at 02:35, Steve5 thaw5@suddenlink.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John,

I don't see the FixBroken utility in the Files section. Can you point me to it?

Thanks, Steve

On 9/6/2016 11:15 AM, Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] wrote:
 

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


On Sep 5, 2016, at 02:53, Steve thaw5 thaw5@suddenlink.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I have a database that I created in Access 2007 and have worked on it 
with my home desktop and my work laptop. Recently upgraded the desktop 
to Access 2016 and the database appears to function properly on it.

But I am unable to open the database on the laptop, seeing an error 
message which reads "An error occurred while loading 'here it inserts 
the name of a specific form'. Do you want to ! continue loading the project.?" If I click Yes, I get another error message: Material & Log 
cannot change the design of frmItemDisplaySpreadsheetStyle. The minimum 
required version to change the design is 14.0.0000.0000.! "

I haven't made any design c! hanges since upgrading the desktop. Does just 
opening the database in Access 2016 make changes to the database so that 
it is incompatible with Access 2007?

Any workarounds or fixes for my problem?

Steve


------------------------------------
Posted by: Steve thaw5 <thaw5@s! uddenlink.net>
------------------------------------


------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
   http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email s! ettings:
   Individual Email | Traditional

<*> To change settings online go to:
   http://groups.yahoo.com/group/MS_Access_Professionals/join
   (Yahoo! ID required)

<*> To change setti! ngs via email:
   MS_Access_Professionals-digest@yahoogroups.com 
   MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
   MS_Access_Professionals-unsubsc! ribe@yahoogroups.com

<*> You! r use of Yahoo Groups is subject to:
   https://info.yahoo.com/legal/us/yahoo/utos/t! erms/







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: John Viescas <johnv@msn.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (8)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


.

__,_._,___

Tidak ada komentar:

Posting Komentar