Solved

Create an MDE file I cannot enter a password field

Posted on 2011-09-26
4
376 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
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…

839 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