Selasa, 06 September 2016

Re: [MS_AccessPros] Different versions of Access

 

I have maybe the same issue. But I know how to quickly fix it. I have code that emails reports through outlook in the databases. When I open the databases in a new version, I get weird messages related mostly to dates. So I go in and fix the reference to the outlook version that is currently on the machine. I do not want to change the binding because of the drawbacks. Once I fix the reference, all works great. I am trying to get IT to convert everyone at the same time to the new 2013 version. But they are busy and it seems to be one at a time.

 
Jim Wagner


On Tuesday, September 6, 2016 7:39 AM, "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@suddenlink.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 settings via email:
   MS_Access_Professionals-digest@yahoogroups.com
   MS_Access_Professionals-fullfeatured@yahoogroups.com

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

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





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: Jim Wagner <luvmymelody@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)

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