Solved

Create an MDE file I cannot enter a password field

Posted on 2011-09-26
4
350 Views
Last Modified: 2012-05-12
Hi.
I have an created an access Database in Access 2007 and then converted to a 2003 database. This is because some of the users only have 2003.

My first form is a login form where the user will enter their user ID and a Password – if a valid password is entered (checked against a password in a table) then this will display the next form appropriate to this user. The password field is setup with the Input mask set to password on the properties sheet.

The issue I have is that when I convert to an MDE file I cannot enter a password – This field is not enabled. This works perfectly when I am in the .MDB file.
thanks
M
0
Comment
Question by:MECR123
  • 2
4 Comments
 
LVL 84
ID: 36598223
Converting to a .mde file should have no effect on your ability to use that field, so I assume something else is going on.

How are you converting to .mde? Do you have another instance of Access 2003 on the same machine? If so, and if you did this by just switching from 2007 to 2003, then I'd encourage you to reboot the machine before opening the 2003 instance and creating the .mde file.


0
 

Author Comment

by:MECR123
ID: 36598268

thanks - Yea a strange one indeed

I am making the MDE file by going to database tools and Make MDE.

I have also tried creating a ACCDE file from within Access 2007 and I have the same issue.  Again works file in a .MDB format.

I only have access 2007 on my PC





0
 
LVL 3

Accepted Solution

by:
John_Arifin earned 125 total points
ID: 36598332
You have to convert to MDE in the Access 2003, because it is not backward compatible.
Reference: http://msdn.microsoft.com/en-us/library/Aa167800, under the Protecting Your Code with MDE Files topic
0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 125 total points
ID: 36598394
Also see this article:

http://support.microsoft.com/kb/926712

A snippet from there reads:

"Because of the changes that Access 2007 makes to a database when the database is saved an .mde file, .mde files cannot be converted to a file format from an earlier version of Microsoft Access."

In other words, you could make a .mde file and open THAT file with 2007 or 2010, but not with earlier versions. At best you'll have troubles with the database. At worst, you won't be able to open it with 2003 or earlier. As JohnArifin said: Get a copy of 2003 and use that to build your .mde file. That is the ONLY reliable way to do this.

Finally: The "Make MDE" button should never have been on the 2007 ribbon, IMO. It is confusing, and has no real bearing on the process being executed.
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

747 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now