Convert accdb to mdb, but queries and modules are not there

[Herbert Chan]

Hello,

I have microsoft office 2007 at home and microsoft office 2000 at work. I
created a database at home that is to be used at work. The database has
tables, a few queries and a module containing some vba macros that I intend
to use at work.

After completing the design of the database at home with all the tables and
queries and modules created, I saved the 2007 accdb as 2000 mdb. I then
opened the 2000 mdb with the microsoft access 2007 at home, only the tables
were there, and all the other queries and modules were not there.

How can I convert 2007 accdb to 2000 mdb with all the queries and modules
also transferred to 2000 mdb?

Herbert

 

[Albert D. Kallal]

Hello,

I have microsoft office 2007 at home and microsoft office 2000 at work. I
created a database at home that is to be used at work. The database has
tables, a few queries and a module containing some vba macros that I
intend to use at work.

Do you mean vba and some macros? Macros are SIGNIFICANTLY a different beast
and animal the that of VBA code. The new type of embedded macros in 2007
are not supported in previous versions. In fact, there is a SLEW of features
in 2007 that previous versions don't have.

It works fine for me. MAKE SURE YOU RIGHT CLICK on the nav pane, and go
"show all all groups"

As simply sensible issue here, you want to use the 2000 format with 2007
when developing so you don't start using a bunch of features that 2000 does
not have.

How can I convert 2007 accdb to 2000 mdb with all the queries and modules
also transferred to 2000 mdb?

It should convert. However, you will loose embedded macros, as that feature
does not exist in 2000. When you do a save-as and save as 2000 format, can
you
see the modules and code in the 2000 format on the 2007 box? (by default
when
I opened up the mdb file the nav pane was on the "tables", but right
clicking
show all groups did display all forms, code, modules etc.

Do a test form with a box on it that when you click on the button it says
"hello" to you....test that? Does that a2007 sample then convert to a2000?

Also, clear up the issue of macros and VBA

we have:

VBA - supported 2000-2007
Macros - supported 2000-2007
Embedded macros - ONLY supported in 2007.

I don't think needs repeating that it makes sense to develop in the lowest
common version here and move up...not try to move backwards.

However my 2007 accDB files did convert fine to a2000, and all of the code
etc. did convert. As mentioned, on a2000 I could see all modules/code etc,
but when I opened them in 2007, I did have to right click on the nav pane to
display all groups...

Perhaps this just an issue of the new interface and you not being familiar
with the nav pane?

 

[Herbert Chan]

Thank you very much.

The problem is indeed just that I don't know I have to right click to show
all the objects in the a2000 mdb files. That's a great relief.

Thanks.

Herbert