By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,736 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

Enabling an Access 97 database for use with Access 2003

P: n/a
We have an Access 97 database app that we'd like to enable (not convert) for
Access 2003. We still have users running 97 and are not prepared to upgrade
everyone who uses this database to the 2003 version yet. We're getting an
error message when we try to do this which reads as follows:

"There were compilation errors during the conversion or enabling of this
database. The database has not been saved in a compiled state. The
performance of this database will be impaired because Microsoft Access will
need to recompile the database for each session."

The MS Knowledgebase doesn't provide much guidance on this issue.

Because we cannot enable the database for 2003, the 2003 users cannot get
into the database while 97 users are logged into it (this is unacceptable).

Anyone have any suggestions on how to troubleshoot this issue?

Thanks in advance for any help.

Terry Block
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"Terry Block" <tb****@ncia.net> wrote in message
news:Jw****************@monger.newsread.com...
We have an Access 97 database app that we'd like to enable (not convert) for Access 2003. We still have users running 97 and are not prepared to upgrade everyone who uses this database to the 2003 version yet. We're getting an
error message when we try to do this which reads as follows:

"There were compilation errors during the conversion or enabling of this
database. The database has not been saved in a compiled state. The
performance of this database will be impaired because Microsoft Access will need to recompile the database for each session."

The MS Knowledgebase doesn't provide much guidance on this issue.

Because we cannot enable the database for 2003, the 2003 users cannot get
into the database while 97 users are logged into it (this is unacceptable).
Anyone have any suggestions on how to troubleshoot this issue?

Thanks in advance for any help.

Terry Block

Starting with the A97 version:
Have you split it front end / back end?
Can you get the code to compile in A97?

Both of these things are pretty essential. Multi-user databases should be
split so that each user has their own copy of the database front end with
forms, reports, code etc and a shared back end which contains the data.
You should also make sure that the code compiles - if not, you may have all
sorts of (horrendous) coding errors.

Once you have this sorted, you can provide different front ends to different
users depending on what version of Access they have, but the shared back end
data should be in A97 format.

Fletcher
Nov 12 '05 #2

P: n/a
Also,

Take a look at tools from FMS to help with this kind of thing. They may
even have a white paper.

www.fmsinc.com

Seth B Spearman

"Terry Block" <tb****@ncia.net> wrote in message
news:Jw****************@monger.newsread.com...
We have an Access 97 database app that we'd like to enable (not convert) for Access 2003. We still have users running 97 and are not prepared to upgrade everyone who uses this database to the 2003 version yet. We're getting an
error message when we try to do this which reads as follows:

"There were compilation errors during the conversion or enabling of this
database. The database has not been saved in a compiled state. The
performance of this database will be impaired because Microsoft Access will need to recompile the database for each session."

The MS Knowledgebase doesn't provide much guidance on this issue.

Because we cannot enable the database for 2003, the 2003 users cannot get
into the database while 97 users are logged into it (this is unacceptable).
Anyone have any suggestions on how to troubleshoot this issue?

Thanks in advance for any help.

Terry Block

Nov 12 '05 #3

P: n/a
Thanks very much. The database does compile in 97, but I hadn't split it, so
I'll do that and develop a new front end for the 2003 users.

Terry

"Fletcher Arnold" <fl****@home.com> wrote in message
news:c2**********@hercules.btinternet.com...
"Terry Block" <tb****@ncia.net> wrote in message
news:Jw****************@monger.newsread.com...
We have an Access 97 database app that we'd like to enable (not convert) for
Access 2003. We still have users running 97 and are not prepared to

upgrade
everyone who uses this database to the 2003 version yet. We're getting an error message when we try to do this which reads as follows:

"There were compilation errors during the conversion or enabling of this
database. The database has not been saved in a compiled state. The
performance of this database will be impaired because Microsoft Access

will
need to recompile the database for each session."

The MS Knowledgebase doesn't provide much guidance on this issue.

Because we cannot enable the database for 2003, the 2003 users cannot get into the database while 97 users are logged into it (this is

unacceptable).

Anyone have any suggestions on how to troubleshoot this issue?

Thanks in advance for any help.

Terry Block

Starting with the A97 version:
Have you split it front end / back end?
Can you get the code to compile in A97?

Both of these things are pretty essential. Multi-user databases should be
split so that each user has their own copy of the database front end with
forms, reports, code etc and a shared back end which contains the data.
You should also make sure that the code compiles - if not, you may have

all sorts of (horrendous) coding errors.

Once you have this sorted, you can provide different front ends to different users depending on what version of Access they have, but the shared back end data should be in A97 format.

Fletcher

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.