Solved

Create an MDE file I cannot enter a password field

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

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…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Familiarize people with the process of utilizing SQL Server functions 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 Ac…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

929 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

9 Experts available now in Live!

Get 1:1 Help Now