Encryption issue

[mafhobb]

Hello.

I have a split database that is working perfectly. I have it already installed in a network environment and I now need to protect the back end. My front end is an accdb for now, but eventually I'll turn it into an accde

I go to the back end and encrypt it with a password. Then I go to the front end and delete the table links and redo them. The front end asks for the back end password and then proceeds to list the back end tables so I can select them and create the link.

The process appears to work fine and the tables appear as linked tables on the front end.

However, when I try to get data from the tables (either directly by clicking on the table shown in the FE or through a FE form) I get the error "Not a valid password"

I have gone through the process four times and I am sure that the password is correct. Also, I have opened the backend directly with the same password.

What could be happening? why does the front end show the tables as linked but it cannot open them?

Any help is appreciated...I am very close to go live with this db and this is killing me!

Thanks

mafhobb

 

[pr2-eugin]

When you say,

Then I go to the front end and delete the table links and redo them.

are you saying you are deleting the Tables listed? I hope you are.. That should normally sort it out.. See if there are any hidden tables.. Try the process one more time by deleting all the tables listed, Compact and Repair and then relink them.. See if that works..

 

[mafhobb]

Hi Pr2-eugin,

There are no hidden tables. I do delete the original links before I relink to the encrypted tables. I have tried to compact and repair at different stages...no luck. I can see the tables listed with the linked symbol (small blue arrow) after going through the process and entering the encryption password for the BE, but I cannot open them from within the FE. The BE opens fine by itself.

I have also tried to relink to a backup of the BE that's not encrypted, and that has worked fine.

Any more suggestions?

mafhobb

 

[way2bord]

Make a backup.
Move Backend to your desktop.
Decrypt backend. Repair / Compact.
Create a new database (blank frontend).

Test A. linking tables
Add table links to the front end. Do you have any problems?

Test B. encrypted linked tables
Delete all linked tables from the front end. Close the frontend / open backend. Encrypt the backend with a simple password. Close Backend. Open the frontend. Add linked tables to frontend - it should ask you to enter the simple password. Try to open a linked table. Do you still have problems opening the tables?

 

[mafhobb]

Yes, did all that and nothing worked...but...I figured it out.

My password was too long. The minute I shortened it to 13 characters, it worked fine. I also removed a parenthesis although that did not seem to make a difference.

Thanks for everyone's help!

mafhobb