Data Base with Access 2007

R

Roger Bell

Can anyone tell me if a Data Base designed in Access 2002 will run with
Access 2007?
It seems that the data base will load to the main menu but on selecting a
command button, it just stalls.

Is there any way around this?

Thanks for any help?
 
A

Albert D. Kallal

Does the code compile on the 2007 machine?

I would consider doing a de-compile,a nd then re-compiling the code. They
are different versions.

So, it should run, but try a de-compile. Then compact and repair, and then
compile the code, and THEN try running it.

Decompile is explained here:

http://www.mvps.org/access/bugs/bugs0008.htm


You could also de-compile it on the 2002 box BEFORE you copy it to the
target machine.

I always install the folwling registry edit that gives you a context (right
click) decompile option.

http://www.mvps.org/access/bugs/bugs0008.htm

The code should run without modifications, but since the application was
built and "compiled" on a different binary version, then it makes sense to
de-compile..and then force re-compile on the target machine. Note also the
above context right click is useful anytime during development you
experience a ms-access execution error (a Dr. Watson error....the so called
"ms-access has encounter an error). if you experience a error during the
development cycle, then I STRONGLY suggest the first thing you do (after
killing ms-access in the task manager) is to do a de-compile.

If you plan to a whole bunch of different versions of ms-access to run the
same application in a multi-user environment, you CAN do this. To have the
appcation use the same data you split the database. You then simply deploy
the correct front end to each machine that running the respective version of
ms-access. This allows you to run 3, 4 or even 5 different versions of
ms-access, but still have all users work on the same data.

I explain the concept of splitting here:

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm
 
A

Allan Murphy

Are you using VISTA with the Access 2002 having a fron tned and a back end?

Recently I had problem where my work upgraded from XP and Access 2000 to
Vista and Access 2003. A database in Access 200 format would "hang"
a menu item was selected. The problem was I had to relink the front end and
back due to the name change to the directory where the subdirectory resided
was changed.
HTH

Allan
 
T

Tony Toews [MVP]

Roger Bell said:
Can anyone tell me if a Data Base designed in Access 2002 will run with
Access 2007?
It seems that the data base will load to the main menu but on selecting a
command button, it just stalls.

This sounds like the macro security warning issue. When you open the
database initially are there any messages of some sort?

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/
 
R

Roger Bell

Thanks Allan,

How do you actually go about relinking the Back end to the Front end?

Do you need to recreate all the command buttons?

Thanks again
 
R

Roger Bell

Thanks Tony,

No there are no messages. The data base loads through to the Main Menu, and
then stalls when you click on any button. I have installed a version of
access 2002 on the machine and the data base opens up up this version and the
command buttons are accessible. However, when you run any reports, it takes
quite awhile for the reports to generate. The same data base under Windows
XP does not have this problem.

Thanks again
 
T

Tony Toews [MVP]

Roger Bell said:
No there are no messages. The data base loads through to the Main Menu, and
then stalls when you click on any button. I have installed a version of
access 2002 on the machine and the data base opens up up this version and the
command buttons are accessible. However, when you run any reports, it takes
quite awhile for the reports to generate. The same data base under Windows
XP does not have this problem.

Is this A2007 database also on Windows Vista? If so there are several
Vista specific performance issues at
Microsoft Access Performance - Speed up your Access 2000 Forms
http://www.granite.ab.ca/access/performanceforms.htm

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