Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Can Microsoft Access .accde extension be changed to .mde without any problems

Posted on 2014-02-03
3
Medium Priority
?
470 Views
Last Modified: 2014-02-03
I've just switch our frontend to accdb and I want to make the mde with the old extension so I don't have to change all the .bat files and user profiles that manage their shortcuts.

Is this ok to do?
0
Comment
Question by:J.R. Sitman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 11

Accepted Solution

by:
Guru Ji earned 1400 total points
ID: 39829579
The internal structure of MDB/MDE and of ACCDB/ACCDE is completely different.

When you change the file extension from ACCDE to MDE , the internal structure remains ACCDE as before. It does not matter Access because Access knows how to open the file. However, future versions of Access may fail opening it.
0
 
LVL 58
ID: 39829627
Yes, you can change it.

It's just when using Access, you need to be aware of the file types.  

Jim.
0
 

Author Closing Comment

by:J.R. Sitman
ID: 39829867
Thanks
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question