Advanced Linking Question

[Guest]

I was hoping someone could help point me in the right direction. I am
looking to link two tables from two different databases (Access) and they are
secured databases. The reason for this is that I am using Crystal Reports to
connect to them, but Crystal doesnt like it when I connect to two seperate
secure databases with different security files.

I was hoping to create a new database (called Crystal Reports Data
Repository) that had both secured linked tables in it and this would solve my
problem. I can do it for one table by opening the secured database and then
creating a new database and get external file and choose linked table. Works
great, but I cant get the second secured table linked.

Any suggestions would be great.

Thanks,
Bob

 

[Joan Wild]

I was hoping someone could help point me in the right direction. I am
looking to link two tables from two different databases (Access) and
they are secured databases. The reason for this is that I am using
Crystal Reports to connect to them, but Crystal doesnt like it when I
connect to two seperate secure databases with different security
files.

It's the fact that there are two mdw files involved that's the problem.

One option is to create a user (same name and PID) in each of the mdw files.
Give this user the necessary permission in each of the secured databases.
You can then use either mdw, log in as this user, and create a new mdb and
link to the tables.

 

[Guest]

Dear Joan,

I sincerely appreciate your response!! It worked like a charm and I was
thinking I was going to have to create a seperate database just to connect
them to crystal. Now I am using one MDW with the same user name and PID to
connect via Crystal. That is a really cool little trick. I had tried this
in the past with the admin user....but the PID was not the same......

This is cool.....thanks again!!

Bob Millington