William Benson (VBACreations.Com)
vbacreations at gmail.com
Mon Jul 18 21:30:52 CDT 2011
There might not be so many folk who have bothered to move to Ac2007 formatted databases, let alone to Ac2010 platform. While others are still quiet on the topic, I will put forth my half-penny advice. I did it to have strange bugginess stop showing up when my database got too big and I didn't know it -- only to find that I still seemed to have a 2 GB limitation even after it became an accdb file. Goodness knows why, and it is quite frustrating. One thing I would recommend but it is because I am an Excel programmer and may not know the difference in how Access works versus Excel... is to call every function somehow, in debugging mode, at least once - just in case there are things which the compiler only checks at runtime, and only when the code in that particular routine executes. This can be a real chore. Things that lie on the other side of IF conditions which almost never happen are especially burdensome to check, and error handling for very off-chance exceptions. But if you are needing to be that sure about things, you have to force every condition so it gets tested at least once (and even then you will only have feedback on the conditions you thought to check). There are some controls which if you have used them in an Ac2007 database you might not find them there any more, like Calendar control. Data Access pages were minimally supported in 2007 (could not create but could still run) and in 2010 will not function. Anyway, I would just be parroting what I read here, were I to go on. http://technet.microsoft.com/en-us/library/cc179181.aspx -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darrell Burns Sent: Monday, July 18, 2011 5:08 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access2010 vs Access2007 I have to worry about it...I don't want the users seeing warning messages or getting "bitten". -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Benson Sent: Monday, July 18, 2011 12:16 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access2010 vs Access2007 I wouldn't worry about it. After all how ya gonna learn the differences if you don't let them bite you? Just kidding, hope you get a less smart-arse answer soon. On Jul 18, 2011 2:26 PM, "Darrell Burns" <dhb at flsi.com> wrote: > Hi folks. > I bought a new dev machine with Win7 and Office2010 32-bit. It > installed the > Access 14.0 Object Library. The "default file format" in Settings is Access > 2007. > My app runs on my client's Win2008 R2 Server and all the workstations > run Win7. However, their Access references point to the Access 12.0 > Object Library. As a result, when I upload my app to their server and > open it up I > get a warning message that "some of the features may be incompatible", even > though I haven't used any of those features. > Do I need to scale back to 12.0 on my side or upgrade the client to 14.0? > And how would I do that? > Thanx, > Darrell > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com