Create Ade from Adp

• Paul Sp

  SSCrazy

  Points: 2314

  More actions

  August 15, 2005 at 5:43 am

  #68245

  Hi

  I have just changed from mdb to adp and now want to make an ade file for additional security.

  I created an new adp file in Access 2003.  When I came to use Database Utilities to convert to an ade file, it told me it was created in 2000 and needed to be converted to 2003 format.  I was surprised, but, as I had imported a couple of forms (created in 2000) and amended the code, I thought that this might have caused the 'problem'.

  So, I converted the db to 2003 format and tried again to create an ade file from it.  It just gave the very helpful dialog: "Microsoft Office Access was unable to create an ade database".

  I've been through Help - to no avail - I don't have references to other dbs either adps or mdbs.

  I have tried creating a fresh adp and importing forms etc into it.  Still no joy.

  Has anybody any ideas how I might get over this problem.

  Thanks

  Paul

• Richard Moldwin

  SSCommitted

  Points: 1872

  More actions

  August 15, 2005 at 5:52 am

  #582098

  I'm not sure what the problem is, but:

  Try creating a blank Ac2003 ADP file, setting the connection to your database using the built-in ADP connection manager.

  Then import all of your database objects (except for the database tables!!!- they are already present from your new connection, and will be made into duplicate copies if you "import" them) into the new ADP file.  Make sure you also import your CommandBars.

  Then set up all of your options and startup options, as before.

  Hopefully, you should now be able to create an ADE file from it.

  HTH,

  Rich

• Pham Tuan Phat

  SSC-Addicted

  Points: 459

  More actions

  August 15, 2005 at 6:01 am

  #582099

  To make the ADE file from an ADP, you must connect to a SQL Server database. If not, you can not do that.

   

• Paul Sp

  SSCrazy

  Points: 2314

  More actions

  August 15, 2005 at 6:12 am

  #582102

  Hi Rich

  I did try that, but have just gone through it again to check.  I was just about to import one form and try a one by one test, however I noticed that the database window title bar already says "Access 2000 File Format".  This is without doing any importing.

  The tables I am using on the SQL Server are the original ones (holding all of my data) used with my mdb - with mostly new sps and views. 

  I'm not sure what is going on here? 

  Many thanks

  Paul

• Richard Moldwin

  SSCommitted

  Points: 1872

  More actions

  August 15, 2005 at 3:24 pm

  #582291

  Ahah, I think I know the problem.  I use Ac2002, but that should not matter.  Go to Tools-->Options-->Advanced, and look at the setting for "Default File Format."  If it says "Access 2000," then that is likely your problem (I think Ac2000 still may be the default in Ac2003!). 

  I have no idea what the difference is between the formats, but I would:

  1) Open up a blank database and change the default format to 2003.  I think the format only applies to new databases that you create AFTER you change the default format.  Now close Access.

  2) Open Access, and create a new Ac2003 ADP, and verify that the format for your new database is Ac2003.  If it is Ac2003, then import all the objects into it.  If this does not work, I'll try to think of something else.

  HTH,

  Rich

• Ian Byles

  SSC Enthusiast

  Points: 174

  More actions

  August 16, 2005 at 2:50 am

  #582376

  Hi,

  This may be the problem,

  Whenever i get that error message when trying to create an mde/ade file, the problem has always been caused by a compile error in the vba code. Make sure you recompile the code before creating an mde/ade file.

  iano

• Paul Sp

  SSCrazy

  Points: 2314

  More actions

  August 16, 2005 at 7:57 am

  #582448

  Thanks Ian

  I have compiled the code.  I'm grateful for your contribution.

  Thanks Rich

  Another surprising find.  Who would believe a new installation of 2003 would have 2000 as its default file format.

  Anyway, I now have a fine young .ade.......

  Very many thanks, once again

  Paul

• Peter O

  Valued Member

  Points: 59

  More actions

  March 13, 2006 at 7:13 pm

  #626407

  Thank you!

• Jonathan Wallace

  SSC Enthusiast

  Points: 153

  More actions

  August 10, 2006 at 2:25 pm

  #654428

  Another thanks!

• Russell

  SSC Rookie

  Points: 45

  More actions

  September 24, 2007 at 5:45 pm

  #735827

  The only result that returned anything on Google while from searching for "Microsoft Office Access was unable to create an ADE database". Thanks - this pointed me in the right direction that with a little bit of finessing I could find a way to get my circumstances to work.

• PaulSp

  SSCrazy

  Points: 2499

  More actions

  September 26, 2007 at 3:07 am

  #736278

  Hi Russell

  I started this thread and became a big supporter of Access.adp. The ability to deal natively with SQL tables is fantastic. Access started as a little desktop database, but was grown enthusiastically by Microsoft. It really came of age for developers with .adps.

  However, from v2007, Access appears to have reverted to a desktop tool. No more support for the native use of SQL tables. My enthusiasm for developing in Access has evaporated. I am looking to move to VS2005. It seems such a shame when a company 'pulls the plug' on such a great developers tool.

  Best wishes

  Paul