MECR123
asked on
Create an MDE file I cannot enter a password field
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
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
ASKER
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.