Results 1 to 6 of 6
  1. #1
    linoreale is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Oct 2014
    Posts
    10

    convert to mde

    Hi,
    I'm using Access 2007.
    I converted my access application to an mde file. When I open it, the main form shows but buttons don't work.
    I.e. if I push the "exit" button, nothing happens. On the click event of the exit button there is "docmd.close" code.
    What Can I do for comletely use an mde file?


    Thank you and Regards

  2. #2
    CJ_London is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    why are you converting to mde (2003) from 2007? Usually you would publish an accde file instead. It may be it hasn't compiled it correctly. Suggest go back to your original file (.accdb?) go into the vba editor and compile the code, then publish to accde and see if that works

  3. #3
    linoreale is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Oct 2014
    Posts
    10
    Quote Originally Posted by Ajax View Post
    why are you converting to mde (2003) from 2007? Usually you would publish an accde file instead. It may be it hasn't compiled it correctly. Suggest go back to your original file (.accdb?) go into the vba editor and compile the code, then publish to accde and see if that works

    Hi Ajax,
    thank you for your reply,
    I worked on A03 for a long time, but only recently I upgraded to A07, since a couple of months, and I don't know all of its features.
    I'm going to publish an accde file as you suggested and try it.
    Kind regards

  4. #4
    linoreale is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Oct 2014
    Posts
    10
    Hi,
    just created an accde compiled binary file from my (working) .accdb database, but doesn't work yet.
    It seems not execute vba code inside buttons, but I can see tables and queries and use them.
    What is wrong?
    Thank you very much

  5. #5
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Quote Originally Posted by linoreale View Post
    Hi,
    I'm using Access 2007.
    I converted my access application to an mde file. When I open it, the main form shows but buttons don't work.
    I.e. if I push the "exit" button, nothing happens. On the click event of the exit button there is "docmd.close" code.
    What Can I do for comletely use an mde file?
    Thank you and Regards
    Perhaps there is a corruption issue. Can you post the VBA that is used for the "exit" button?

    If there is corruption, you may want to import all of the objects into a new file (from the original old file) using Access 2003. Then, try again with 2007.

  6. #6
    CJ_London is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    It seems not execute vba code inside buttons, but I can see tables and queries and use them
    Have you enabled the code?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Convert to DD:HH:MM:SS
    By denknee in forum Programming
    Replies: 2
    Last Post: 10-06-2014, 04:55 PM
  2. Convert seconds to DD:HH:MM:SS
    By rockcliff15 in forum Access
    Replies: 6
    Last Post: 04-23-2012, 01:27 PM
  3. Can you convert .mdb to .wdb??
    By DeeMax45 in forum Access
    Replies: 2
    Last Post: 01-22-2012, 06:11 PM
  4. Horizontal DB convert
    By williamtak in forum Access
    Replies: 2
    Last Post: 12-09-2010, 08:05 PM
  5. How to convert a db to txt
    By Joliet_Jake in forum Import/Export Data
    Replies: 5
    Last Post: 11-01-2010, 12:07 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums