Access 2003 to 2002?

[Jack G]

I made a database using Access 2003, split it into front and back-ends, and
now I'm discovering that computers with Access 2002 won't work with it. I
had thought that 2002 and 2003 were compatible, but apparently not.

I don't see any option for "Save As to 2002." Is there some other way to
get it to work with the older version?

Thanks,

Jack

 

[Douglas J. Steele]

There is no difference between the Access 2002 and Access 2003 formats.

What exactly do you mean by "won't work with it"? What are the symptoms?

 

[Jack G]

When trying to open the front end created in 2003, a message comes up on the
computer with 2002 (SP3) saying, "This database is an unrecognized format.
The database may have been created with a later version of Microsoft
Access..."

The file I'm trying to open is an .mde file, not a .mdb -- is that type
compatible with 2002?

Jack

 

[John Vinson]

The file I'm trying to open is an .mde file, not a .mdb -- is that type
compatible with 2002?

No. You must create the MDE using the version of Access with which
you'll be using it.

John W. Vinson[MVP]

 

[Douglas J. Steele]

That's likely the problem: MDEs are a lot fussier.

Unfortunately, I don't remember the solution to this issue, and since the
thread's got some length to it, it's possible no one else will read it.

If you don't get someone else suggesting a solution in the next few hours,
you might repost the question, mentioning it's an MDE at the outset.

Sorry about that.

 

[Jack G]

Thanks, Ive now tried opening the .mdb in 2002 but it reports a missing dll
resource - apparently the one that has the "mid" function in it. I guess
I'll try moving the missing dll over from my 2003 machine and see what
happens.

If that works, it will only be a minor annoyance to create two versions of
the .mde file (one for 2002 and one for 2003) after revisions are made to
the .mdb.

Jack

 

[gls858]

Thanks, Ive now tried opening the .mdb in 2002 but it reports a missing dll
resource - apparently the one that has the "mid" function in it. I guess
I'll try moving the missing dll over from my 2003 machine and see what
happens.

If that works, it will only be a minor annoyance to create two versions of
the .mde file (one for 2002 and one for 2003) after revisions are made to
the .mdb.

Jack

Could be missing a reference. Open a query go to design view then look
for an icon for new object class module then references. Check the list
and see if anything is marked as missing. They also should be in the same
order as the machine where the database works.

There's probably a better way to get to the class module maybe someone
here can post it if there is. The icon looks like multicolored lines joined
into a square

 

[John Vinson]

There's probably a better way to get to the class module maybe someone
here can post it if there is.

Yep...

Ctrl-G to open the VBA editor; Tools... References from the menu.

John W. Vinson[MVP]

 

[gls858]

Yep...

Ctrl-G to open the VBA editor; Tools... References from the menu.

John W. Vinson[MVP]

Thanks John.

gls858