Using Access2000 database with VISTA and Access 2003

[PoppaSmurf]

I was asked to help solve this problem and I am seeking some guidance.

Prior to the company upgrading from Windows XP and Access 2000 to VISTA and Access 2003, they were able to open a database, that is Access 2000 format, to display a login screen, after entering a valid User Id and Password they click on the ENTER button to display a switchboard menu.

Now, this is the problem. Using VISTA and Access 2003 and the same Access 2000 database when they open the database the Login screen is displayed. They enter their User Id and Passsword then click on the ENTER button the database appears to hang and no switchboard menu is displayed.

There is code behind the ENTER button to validate the User ID and Password, if the User ID and Password are valid then the switchboard menu should be displayed

I do not have VISTA on my computer to test this condition. Any assistance would be appreciated.

PoppaSmurf

 

[Remou]

I do not think that this is to do with Vista, it is to do with Accss 2003, which blocks things all over the place. It has probably been set to block unsafe expressions without warning.

http://office.microsoft.com/en-us/access/HA011071651033.aspx

 

[PoppaSmurf]

Thank you.

There was no message displayed as per your reply.

I contacted the user to determine exactly what happens when they open the database. I was told "the login screen is displayed, they enter their user and password and it appears to hang" the only way to close the database was to click on the X in the top right hand corner.

PoppaSmurf

 

[Remou]

I am suggesting that Access 2003 has been set to not display the warning message. This means that it will fail without warning. Have a look at the macro security level:

http://office.microsoft.com/trainin...ID=RP011461881033&CTT=6&Origin=RC011461801033

 

[PoppaSmurf]

Thank you, to all who offered advice.

I found the problem, it was due to a LAN upgrade going from Windows 2000 and Access 2000 to VISTA and Access 2003. The database had a front end and a back end that work with the correct linking, BUT in the new configuration the name of the directory where the back end resided was changed. I assumed that the directory would not changed. Any way another problem solved.

Allan


PoppaSmurf