Question related to DAO and FEUpdater

G

G-Man

I am using the FDUpdater tool to split Access 97 FEs and BEs. I am now
looking, finally , at the 2003 conversion of these databases. Setting the
actual conversion aside for now, I have an issue regarding the DAO when I use
a particular upgrade path. The situation below deals with the entire Office
97 and Office 03 install packages, but I am only focusing in on Access

On all boxes I am looking at (other than my test box, #3), it looks like
Access 97 was installed prior to 03.

Scenario #1 - On most machines, Office 97 was completely installed. Office
2003 was later installed, with the Option to NOT install Access 03 and to
leave Access 97. Default directories. On these machines, FEUpdater was added
and Access 97 FE/BE's via this tool have been operating just fine. You'd
expect this, because Access 03 was never installed in the first place. This
is where most machines are now. In addition, subsequently adding Access 2003
also seems to not harm the process.

Scenario #2 - There are also a few machines that were imaged slightly
different. On these machines, it *APPEARS* that with backward compatibility
in mind, these machines had Access 97 installed first, by itself (from the
Office 97 CD) and immediately had Office 2003 installed, complete - - - with
the option to KEEP Access 97 on the machine. But the directory location for
the 03 install was changed from the default Program Files\Office to Program
Files Office 2003

Again, these machines seem to operate fine in the FE/BE FEUpdater
environment opening Access 97 FEs.

Scenario #3 - But on a third variation test machine, I installed Office 2003
complete FIRST in it's default directory and then added Access 97 by itself
(with Spell Check). On this machine, when I try running the FEUpdater ini
for any 97 FE, I get a DAO error in the Auto FE Updater.

"The following error occurred while attempting to determine the Access/Jet
version of the file . . . . . (while using DAO Version 3.6). Error 3041:
Cannot open a database created with a previous version of your application."

I can manually open an Access FE without any problem, in Access 97. But when
I go thru the Updater . . .I get the error. Help me understand this please.

In addition, In Scenario #1, Even once Access 2003 is added to the mix
later, FE Updater seems to know which version of Access to open, even without
specifying a
startup in the ini file. This seems to be the case regardless of which
program I had open last, Access 97 or Access 2003. Since I may have a few
variations on where that exe is . . . . is this true??? Or will I possibly
develop problems.

Allot to digest, I know. But I have about 40 machines I need to think this
thru. The FE Update program has been marvelous in helping me bring Scenario 1
into full swing, with and subsequently getting Access 03 on the boxes.

You may be thinking, just convert en mass to Access 2003 and be done with
it. But I have specific reasons I need to be able to control FE conversions
sort of one DB at a time.

Thanks for taking the time to help me through this. I'm sure I need to
understand more about DAO in the midst of all this.
 
T

Tony Toews [MVP]

G-Man said:
Scenario #3 - But on a third variation test machine, I installed Office 2003
complete FIRST in it's default directory and then added Access 97 by itself
(with Spell Check). On this machine, when I try running the FEUpdater ini
for any 97 FE, I get a DAO error in the Auto FE Updater.

"The following error occurred while attempting to determine the Access/Jet
version of the file . . . . . (while using DAO Version 3.6). Error 3041:
Cannot open a database created with a previous version of your application."

I can manually open an Access FE without any problem, in Access 97. But when
I go thru the Updater . . .I get the error. Help me understand this please.

I did find a minor bug in that logic. Please email me directly at
tony at granite dot ab dot ca and I'll email you a new version of the
Auto FE Updater.

Otherwise I have to recreate your scenario here to see if I can
duplicate the problem. That error message, the Error 3041, etc, etc,
doesn't make a lot of sense to me why it's happening.

Have you also installed Office SR-1, SR-2 and Jet 3.5 SP3 on that
system?
In addition, In Scenario #1, Even once Access 2003 is added to the mix
later, FE Updater seems to know which version of Access to open, even without
specifying a
startup in the ini file. This seems to be the case regardless of which
program I had open last, Access 97 or Access 2003. Since I may have a few
variations on where that exe is . . . . is this true??? Or will I possibly
develop problems.

You should be fine. The FE Updater is checking the versions of the
FE MDB/MDE and ensuring that the appropriate version of Access is
installed on the system and then it's supposed to start up the
appropriate version of Access.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
G

G-Man

I did find a minor bug in that logic. Please email me directly at
tony at granite dot ab dot ca and I'll email you a new version of the
Auto FE Updater.

Will do!
Otherwise I have to recreate your scenario here to see if I can
duplicate the problem. That error message, the Error 3041, etc, etc,
doesn't make a lot of sense to me why it's happening.

I can duplicate it pretty easy given the situation I described. Let me know
if you would like me to experiment some more.
Have you also installed Office SR-1, SR-2 and Jet 3.5 SP3 on that
system?

I have installed only Office 97, Office 2003 and Office 2003 SP2 with
nothing else. I'm still kind of ignorant to JET updates. So whatever comes
with those versions is what's there. Dont have Microsoft Update, so would not
be getting any other MS product updates. Only Windows Updates via a WSUS
server on rtheir WAN
You should be fine. The FE Updater is checking the versions of the
FE MDB/MDE and ensuring that the appropriate version of Access is
installed on the system and then it's supposed to start up the
appropriate version of Access.

I was hoping you would say that! I just wanted to make sure specifying the
pathe to the exe wasn;t how I should lock things down. it appeared the FE
Updater was version smart. Great.
 
T

Tony Toews [MVP]

G-Man said:

No email here yet.
I have installed only Office 97, Office 2003 and Office 2003 SP2 with
nothing else. I'm still kind of ignorant to JET updates. So whatever comes
with those versions is what's there. Dont have Microsoft Update, so would not
be getting any other MS product updates. Only Windows Updates via a WSUS
server on rtheir WAN

You really, really do want all the updates. They fix some pretty
serious bugs. Once patched you should ensure they stay patched along
with any new machines by verifying the version of key dlls.
http://www.granite.ab.ca/access/verifyjetsp.htm

Microsoft Access Fixes, Patches and Updates
http://www.granite.ab.ca/access/msfixes.htm
I was hoping you would say that! I just wanted to make sure specifying the
pathe to the exe wasn;t how I should lock things down. it appeared the FE
Updater was version smart. Great.

It's not perfect but adequate.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
G

G-Man

Got it. Thanks. I will backup before installing, but can I assume it will be
a painless upgrade . . . everything else about your program is!!
 
T

Tony Toews [MVP]

G-Man said:
Got it. Thanks. I will backup before installing, but can I assume it will be
a painless upgrade . . . everything else about your program is!!

Yup, that's an easy program to install. Just unzip and throw it in a
folder on the server.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top