How can I compile my FE.mdb into an mde file on Access 2007?

[Guest]

Hi I've just finished spliting my database to be FE and BE. The next step
from what I read is compiling FE.mdb to be "mde" file but I can't find it on
Access 2007. On "Database Tools" tab, I found only "Make ACCDE" so I wasn't
sure it would do the same thing as mde. And I do have to save FE.mdb for
future change, don't I?Thanks for any help.

 

[Albert D. Kallal]

Hi I've just finished spliting my database to be FE and BE. The next step
from what I read is compiling FE.mdb to be "mde" file but I can't find it
on
Access 2007. On "Database Tools" tab, I found only "Make ACCDE" so I
wasn't
sure it would do the same thing as mde. And I do have to save FE.mdb for
future change, don't I?Thanks for any help.

 

[Albert D. Kallal]

In a2007, the new file format is not a mdb, but is now a

accDB, or accDE.....

So, for all terminology in a2007, when we talk about a mde, we really should
be talking about a accDE.

You have to first convert your mdb to a2007 format (which you should be
using anyway).

Then, and only then can you create a mde.


For all versions of ms-access going back for about 15 years now you ALWAYS
had to ensure the mdb (or now accDB) file is in the SAME version of
ms-access are you CURRENTLY using BEFORE you attempt to create a mde (or now
a accDE).

 

[Guest]

Thanks a lot, Albert. After I make my FE.accdb to accde then I can copy
FE.accDE to other PC, don't I? And If I would like to save my database for
backup on my flash drive, which BE or FE file do I have to save? I' m new
with Access so please forgive me if I ask any silly questions. Thanks again
for your kind help.

 

[Albert D. Kallal]

Thanks a lot, Albert. After I make my FE.accdb to accde then I can copy
FE.accDE to other PC, don't I? And If I would like to save my database for
backup on my flash drive, which BE or FE file do I have to save? I' m new
with Access so please forgive me if I ask any silly questions. Thanks
again
for your kind help.

Well, you likely would save both the FE and BE on your jump drive....

Then, you can take them home, or to a diffent computer to work on. when you
need to deploy a "new" version of your application (or update code that has
bugs etc), then you simply give that user a new front end,but you don't
touch their data part (this much why we split).

note that the path name of the linked tables is a full path name. So, either
you have to keep the same path names on your development computer, or have
the user re-link the tables.

I have a article on split databases here, and I talk about a few other
issues (such as when you need to add a new table, you have to do this from
the back end now...).

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

 

[Guest]

Thanks a lot for your info. You have a great day! ^_^

 

[Guest]

Hi Nikki,

I'm quite impressed....a new user to Access (how long?), and you are
splitting your application and attempting to create a compiled version of
your front-end (FE). Very good!

I thought you might find these links helpful:

Cannot make .MDE (or accde)
http://www.access.qbuilt.com/html/conversion.html#CannotMakeMDE

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html

You are welcome to download a zipped copy of my Access Links Word document.
The first three pages includes lots of information that is very useful for
anyone working with Access:

http://home.comcast.net/~tutorme2/samples/accesslinks.zip


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html

 

[Guest]

Thank you so much, Tom for your helpful links. It helps me a lot and I hope
it would be very useful for other new users as well. I'm not that good as you
thought. ^_^ but try to be good someday. Have a good day!