Share via

converting access database file to executable file and spliting database

Anonymous
2018-08-27T14:19:27+00:00
  1. Hello,please can someone help me on the issue of converting ms access database to executable file,I tried several time by going through the back stage of access and click on "Make ACCDE" but it wont compile, it displays the message that "microsoft access was unable to create the .accde, .mde, or .ade file ".
  2. I also tried to split my database and pass worded the database in open exclusive mode ,the database was successfully split but each time I tried to open the front end it would go back to the back stage and still it would not open from back stage.
  3. Access Database  2013 could not be opened in access 2007,even though it was Save As  2007-2013 

What is the solution to all these issues?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

10 answers

Sort by: Most helpful
  1. Anonymous
    2018-08-28T11:05:51+00:00

    Hello,I am sorry for late response,back to question 2,I have not held down the shift key. Let me try it then.

    0 comments No comments
  2. ScottGem 68,810 Reputation points Volunteer Moderator
    2018-08-27T20:28:37+00:00

    Just to make sure, on question 2. Did you try holding down the shift key as you load the app.

    0 comments No comments
  3. Anonymous
    2018-08-27T17:08:41+00:00

    Thanks so much,question has been resolved as you have instructed.

    0 comments No comments
  4. Anonymous
    2018-08-27T16:51:44+00:00

    Your response to question 3 is taken.

    Back to question 2,I tried to open the front end for me to link the table but it would not open,rather it displays back stage and I tried also to open from the back stage, still  it would not open. For question 1 let me  try if I can figure it out as you have said. Thanks

    0 comments No comments
  5. ScottGem 68,810 Reputation points Volunteer Moderator
    2018-08-27T15:24:12+00:00
    1. An ACCDE is NOT an "executable file". It is a compiled file that still requires an Access License to run. If you are getting that message, it means the app can't compile due to some syntax error. Open the VBE then go to Debug>Compile. It will show you the syntax errors that need to be fixed first. 
    2. I'm not sure what you mean by that. When you split a database the tables are moved into a separate file and linked to the front end. If you password protect the back end you need to relink the front end with the password. 
    3. When developing an Access database you need to work in the LOWEST version your users will use. If some users have 2007, then ALL development has to be done in 2007. There are features in 2013 that are not compatible with 2007. Even though the base file format is the same, if you use any of the features 2007 won't be able to open it.
    0 comments No comments