Enabling an Access 97 database for use with Access 2003

[Terry Block]

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

[Fletcher Arnold]

"Terry Block" <tb****@ncia.ne t> 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

[Seth Spearman]

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.ne t> 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

[Terry Block]

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.co m> wrote in message
news:c2******** **@hercules.bti nternet.com...

"Terry Block" <tb****@ncia.ne t> 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