Back-end encrypted with Password Issue

[MrVillareal]

Hello,

I encrypted my back-end with password after splitting my database but after that my front-end disappear and shows only the backstage view of access. Please you help.

Thanks in advance.
Marvin

 

[HiTechCoach]

The current linked tale have a stored password that is blank. The only way to replace the password with your new password is to replace the linked tables.

1) delete all the linked tables from the front end.
2) Create linked tables and this time it will ask you for the password. You may want to check the box to save the password.

WARNING: The password is not difficult to retrieve once you link the tables and store the new password.

 

[MrVillareal]

Thansk Mr. Boyd.

After splitting my database, open BE at exclusive mode, and encrypt with password then when I open my FE to do your suggestions it shows only the backstage view. But if I try to do splitting manually and encrypt BE with password it works.

 

[HiTechCoach]

Thansk Mr. Boyd.

After splitting my database, open BE at exclusive mode, and encrypt with password then when I open my FE to do your suggestions it shows only the backstage view. But if I try to do splitting manually and encrypt BE with password it works.

Interesting.

I want to see if I can reproduce the issue.
Which version of Access (2007, 2010 or 2013)?
Is the original database in the .accdb or .mdb format?

I only need to split a database when I first take over one built by someone else. When I do I have to split a database, I have always done it manually. Whenever I start a new Access application it is already split. Even if I know it will be for a single user.

 

[MrVillareal]

I want to see if I can reproduce the issue.
Which version of Access (2007, 2010 or 2013)?

I used 2010 version.

Is the original database in the .accdb or .mdb format?

Its .accdb

Thanks.

 

[HiTechCoach]

Thanks for the info. I will see if I can reproduce the issue.