Converting toi an ADE File

[JoeGriffin]

How do I convert my MS Access program to an ADE file rather to an MDE
file ?

 

[Brendan Reynolds \(MVP\)]

Only an ADP can be converted to an ADE. When you open an ADP, the 'Make MDE
file ...' option is automatically replace by 'Make ADE File ...'

 

[SA]

Joe:

You have to start out with an ADP project to convert to an ADE database
project. An MDB converts to an MDE. So if your db is starting as an mdb,
you first need to upsize the tables/queries etc. to a SQL server, then
create a newe ADP (importing forms, reports and modules and revising as
necessary from the mdb file; this process is not trivial and you are likely
to run into a lot of work in getting the same functionality; do you research
first on what gottchas are out there with ADPs and work through the
revisions in your MDB first as preparation to the conversion). Once you
have a functioning ADP project then you can convert that to an ADE.