Solved Run-time error '3031': Not a valid password (1 Viewer)

[poh99]

Hi, I split my database. I set a password to my VBA and encrypt my backend access file. After which, when I tried to do a login from my frontend file, it shows me this error. Anyone can assist me.

There is no such issue before I did set any password

Run-time error '3031': Not a valid password

 

[theDBguy]

Are you entering the password by hand or using code?

 

[arnelgp]

relink all your tables in the FE and supply the correct password.

 

[poh99]

Are you entering the password by hand or using code?

I enter the code using the login form to access the database.

 

[poh99]

relink all your tables in the FE and supply the correct password.

I tried relink and still the same

 

[poh99]

I have attached my FE and BE file. The password to unlock VBA and BE is 123
One of the account login username and password is admin

Anyone know where is the issue?

 

[arnelgp]

there is some corruption on the BE.
it is exhibiting as A2010 format when
it should be returning as A2007 format.

 

[poh99]

How should I resolve it? I have already relinked.
Have stuck in this for the past week.

 

[theDBguy]

How should I resolve it? I have already relinked.
Have stuck in this for the past week.

Hi. Your sample file worked for me. All I did was delete your table from the FE and used the External Data tab to link it again using the correct/new password.

 

[poh99]

Hi. Your sample file worked for me. All I did was delete your table from the FE and used the External Data tab to link it again using the correct/new password.

It seems to work on my end as well for my sample file. Shall test it on my main file tomorrow and update again. Thanks

 

[gemma-the-husky]

there is some corruption on the BE.
it is exhibiting as A2010 format when
it should be returning as A2007 format.

Seeing this observation - maybe one user is causing the database to update to A2010, and then it's preventing other users using the linked data. Do any users have A2010 or later?

 

[poh99]

Seeing this observation - maybe one user is causing the database to update to A2010, and then it's preventing other users using the linked data. Do any users have A2010 or later?

I took over from my company database manager and he has been using MS Office 365. I also used MS Office 365. Is after I added in my company new requirement then it have this issue.

 

[gemma-the-husky]

What was the "company new requirement"?
Can you edit the code before that 3031 error is raised to show more detail?

 

[poh99]

I only added new forms (navigation tab) for different department user and split the database. Initially, the form allowed all department to access the database and the database is not split.

 

[arnelgp]

btw i used Passware Forensic to open the BE
and it it reports the error.

same error using _Stellar_Repair for Access].
unable to repair it.

 

[poh99]

To update, i tried the method that @theDBguy suggested on my company main file and it is working. I still cannot figure out why it was corrupted. Thanks all experts for your tips for me to resolve this error.

 

[theDBguy]

To update, i tried the method that @theDBguy suggested on my company main file and it is working. I still cannot figure out why it was corrupted. Thanks all experts for your tips for me to resolve this error.

Hi. Congratulations! Good luck with your project.

 

[poh99]

Hi, I got one question. If I made changes to my front end, do I need to create a new accde file? Or it will auto sync with the front end?

 

[theDBguy]

Hi, I got one question. If I made changes to my front end, do I need to create a new accde file? Or it will auto sync with the front end?

No, the ACCDB and ACCDE are separate files. You'll have to create a new ACCDE and replace the old one.

 

[poh99]

Alright, thanks for the quick reply. Now I know why it cant save my data.