2007 Comparison To MDE

[Arturo]

I have never used 2007, but am starting a class in two weeks to get familiar
with it. In the meantime I have a question.

In the pre-2007 versions of Access you created in the MDB and converted it
to MDE. What are the comparisons in 2007? What do you create it in, and what
do you convert it to in order to get the file that is comparable to an MDE
file?

Thanks for your help?

 

[Dirk Goldgar]

I have never used 2007, but am starting a class in two weeks to get
familiar
with it. In the meantime I have a question.

In the pre-2007 versions of Access you created in the MDB and converted it
to MDE. What are the comparisons in 2007? What do you create it in, and
what
do you convert it to in order to get the file that is comparable to an MDE
file?

Thanks for your help?

Do your development in the ACCDB format, and convert it to ACCDE for
distribution. The ACCDE format is the Access 2007 equivalent of the MDE
format.

 

[Daniel Pineault]

Although the terms have changed slightly, in 2007 you can convert your accdb
over to a accde.

For some more information on the subject check out:

http://office.microsoft.com/en-us/access/HA100678311033.aspx?pid=CH100645711033

http://www.databasedev.co.uk/convert_to_accde_format.html
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Tony Toews [MVP]]

I have never used 2007, but am starting a class in two weeks to get familiar
with it. In the meantime I have a question.

In the pre-2007 versions of Access you created in the MDB and converted it
to MDE. What are the comparisons in 2007? What do you create it in, and what
do you convert it to in order to get the file that is comparable to an MDE
file?

You can also continue to use the MDB/MDE format. Especially if you
are using User Level Security.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[Dirk Goldgar]

You can also continue to use the MDB/MDE format. Especially if you
are using User Level Security.

But I don't believe Access 2007 can create an MDE, though it can run one.
Am I wrong about that?

 

[Tony Toews [MVP]]

But I don't believe Access 2007 can create an MDE, though it can run one.
Am I wrong about that?

I think so. I'm 99.9% sure it can. But it would take me 3 or 4
minutes to test that.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[(PeteCresswell)]

Per Dirk Goldgar:

The ACCDE format is the Access 2007 equivalent of the MDE
format.

Does anybody know if it supports ODBC links to DAO tables?

My recollection of MDE is that I was unable to create a work DB
on C: and link to tables there - had to do everything on the
server with #Temp tables.

 

[David W. Fenton]

Per Dirk Goldgar:

Does anybody know if it supports ODBC links to DAO tables?

Eh? There's no such thing as a "DAO table" any more than there is
such a thing as an "ADO table" or an "ODBC table." DAO is a data
access interface, not a data storage format.

You can create linked tables to all formats that Access/Jet/ACE
supports links to, including the various ISAMs that ship with
Access.

 

[David W. Fenton]

But I don't believe Access 2007 can create an MDE, though it can
run one. Am I wrong about that?

Do you have access to A2007? If so, why did you not just fire it up
and try it out so you could post an answer instead of asking what is
a pretty stupid question?

Even in an ACCDB, the ribbon choice for creating an ACCDE says "MAKE
MDE"!

Again, after a bazillion previous times:

MDB is a native format in A2007. It is not an old format supported
for backward compatibility, but one that is fully supported by the
ACE and A2007.

For instance, CurrentD.Properties("AccessVersion") returns "08.50"
for MDBs created in Access 2003, and "09.50" for MDBs created in
A2007. That demonstrates that it's not just backward compatibility
with the older versions, but that it's an A2007 MDB. Likely there's
no differences that would trip up A2003 (which is why the menu
choices to create it say it's compatible with A2002-03), but it's
still an MDB that is specific to A2007.

 

[David W. Fenton]

I think so. I'm 99.9% sure it can. But it would take me 3 or 4
minutes to test that.

I just tested. It works.

Of course it works! MDB/MDE is a native format for A2007. And the
ribbon command for it says MAKE MDE even when you have an ACCDB open
in the UI.

 

[Dirk Goldgar]

Do you have access to A2007? If so, why did you not just fire it up
and try it out so you could post an answer instead of asking what is
a pretty stupid question?

I have to start up a different computer to run A2007. It was inconvenient
to do that at the time, so I asked my friend to tell me if my understanding
was wrong. Turns out it was, or at least partly so. A2007 can make an MDE
from an MDB in A2002-2003 format, but not from one in A2000 format. That's
probably the source of my misunderstanding. Access 2007 is like Access 2003
in this respect -- and probably Access 2002 as well, but I don't remember
for sure, and I don't have a copy of Access 2002 installed to test it.

Even in an ACCDB, the ribbon choice for creating an ACCDE says "MAKE
MDE"!

Not in my copy of Access 2007, it doesn't. Does it say that in yours?

Again, after a bazillion previous times:

MDB is a native format in A2007. It is not an old format supported
for backward compatibility, but one that is fully supported by the
ACE and A2007.

I never said it wasn't; I just thought (mistakenly) that Access 2007 would
only make an ACCDE, just as Access 2003 will only make an MDE out of the
latest (A2002-3003) file format, even though it fully supports both the
Access 2000 file format and the Access 2003 file format in every other way.

For instance, CurrentD.Properties("AccessVersion") returns "08.50"
for MDBs created in Access 2003, and "09.50" for MDBs created in
A2007. That demonstrates that it's not just backward compatibility
with the older versions, but that it's an A2007 MDB.

This is incorrect. Here are the values returned for
CurrentD.Properties("AccessVersion") in several different database formats
created by Access 2003 and Access 2007:

Program Version Database Format Property Value
Access 2003 Access 2000 File Format 08.50
Access 2003 Access 2002-3 File Format 09.50
Access 2007 Access 2000 File Format 08.50
Access 2007 Access 2002-3 File Format 09.50
Access 2007 Access 2007 File Format 09.50

So the value of the AccessVersion property is 08.50 for the Access 2000
(MDB) file format, 09.50 for the Access 2002-2003 (MDB) file format, and
also 09.50 for the Access 2007 (ACCDB) file format. The value 09.50 doesn't
mean anything at all about whether the database was created by Access 2007.

 

[(PeteCresswell)]

Per David W. Fenton:

Eh? There's no such thing as a "DAO table" any more than there is
such a thing as an "ADO table" or an "ODBC table." DAO is a data
access interface, not a data storage format.

You can create linked tables to all formats that Access/Jet/ACE
supports links to, including the various ISAMs that ship with
Access.

Mea Culpa.

Replace "DAO" with "Jet".

 

[David W. Fenton]

Per David W. Fenton:

Mea Culpa.

Replace "DAO" with "Jet".

You can't use ODBC connections to Jet/ACE data stores from within
Access. If you're using Jet/ACE, it would be incredibly silly to add
an ODBC layer when you can use it directly.

 

[David W. Fenton]

[]

Even in an ACCDB, the ribbon choice for creating an ACCDE says
"MAKE MDE"!

Not in my copy of Access 2007, it doesn't. Does it say that in
yours?

Yes, indeed it does.

I just did some checking. The database I was using that showed that
was created from the Contacts template. Its name is Contacts.accdb,
but I guess it's not really an ACCDB, because just now I opened it
again, and the ribbon said MAKE MDE. But when I created a brand-new
empty ACCDB, it said ACCDE.

But now that I open CONTACTS.ACCDB again, it says MAKE ACCDE.

I haven't a clue what's going on, but I certainly did try it more
than once, and saw it just now. But at this point, it's behaving
correctly, with MAKE MDE for MDBs and MAKE ACCDE for ACCDBs.

Perhaps it's got something to do with the dueling configurations,
but it's certainly the case that both instances of Access that I
checked this in (last night and tonight) were ones that I had to
wait on the installer to reconfigure, so they should have been fresh
configurations with everything appropriately registered.

This doesn't inspire me to place any confidence in A2007.

[]

This is incorrect. Here are the values returned for
CurrentD.Properties("AccessVersion") in several different database
formats created by Access 2003 and Access 2007:

Program Version Database Format
Property Value Access 2003 Access 2000 File Format
08.50 Access 2003 Access 2002-3 File Format
09.50 Access 2007 Access 2000 File Format
08.50 Access 2007 Access 2002-3 File Format
09.50 Access 2007 Access 2007 File Format
09.50

My mistake -- I checked it on a database that I thought was in A2003
format.