[AccessD] Mixed Office and the packageer

[Rocky Smolin]

Thanks Jim. Good stuff.  Will forward to the company.

r 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim
Dettman
Sent: Friday, May 27, 2016 10:08 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Mixed Office and the packageer

Rocky,

  Not sure of your client base, but keep in mind that A2013 dropped DBF
support. A2010 was the last "full" desktop version as A2013 dropped a number
of features besides the DBF.

  As far as I know Sage Key is still the only thing that will still give you
a truly isolated install.

  You don't need to convert to .accdb format unless you plan to use some of
the new features (multi-value fields, attachment data type, etc).  You
should however make sure your in JET 4.0 format.  Note that if you do switch
to the .accdb format, you loose workgroup security as well.

<<And what other problems are going to accrue to this move that I don't know
enough to ask?>>

1. Make sure you stay with 32 bit, and on that note I don't know that Sage
ever licked the 32/64 bit problem.   Within a Office rev, you can't mix and
match 32 and 64 bit.  It all has to be one or the other (ie. Excel 2010 64
bit and Access 2010 32 bit).   Also noted in the past couple of days on the
list that Office 2016 has some issues with older versions.

2. A2010 is the last version where you can live without the ribbon and use
your own custom bars, but there are add-ins for 2010 and 2013 to get back
some of the old menus.  Have never used any, so no input on that.

3. make sure your always in a compiled state.  A2010 and up tightened up on
syntax checking.  Some things could be gotten away with in the past, but not
now.  It was odd-ball stuff, but you may trip over it.

Jim. 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Rocky Smolin
Sent: Friday, May 27, 2016 10:59 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Mixed Office and the packageer

Dear List:
 
The guy who acquired my manufacturing system is considering moving to A2010
or more likely A2013.
 
At the moment it is still an mdb, compiled and distributed with a version of
A2003, and they are still using the Wise/Sagekey scheme I adopted lo those
many years ago.
 
I understand the packager in 2010 (and 2013) is quite robust and can produce
a run time version.  
 
Question is how well does that play if the client machine has a different
version of Office installed (BTW, switching to late binding is a task that I
think has come to the top of the list). 
 
And what happens to those who have O2003 installed?  
 
Should the front end be converted to accdb/accde or can it remain as an mdb
for the near term?  Same question for the back end.
 
And what other problems are going to accrue to this move that I don't know
enough to ask?
 
MTIA
Rocky Smolin
Beach Access Software
760-683-5777
www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com
<http://www.e-z-mrp.com/>
Skype: rocky.smolin
 
--
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