ODBC Connection String Security

[entonne]

Is there a way to encrypt a connection string either in Access or VBA?

Here's the situation if it helps any and please offer any alternative ideas that may come to mind:
We have an Access front-end (Front End A) that multiple users access over the network to print out reports. Front End A queries tables in Front End B (another Access Database) to produce its reports. Front End B is "refreshed" each day by copying certain tables from the oracle back-end.

The performance of Front End A is horrible to say the least and my boss has asked me to fix it (I just came aboard). So after some reading I decided to use a pass through query and the performance changed dramatically: a report from Front End A which took a minute and twenty seconds now runs in ten seconds. The only drawback is my password is in the connection string for all to see. I suppose I could put it into VBA and lock it somehow, but that doesn't seem to secure either. And I can't have everyone enter in their own password because not everyone has one or doesn't have access to certain tables. So I was thinking of some way encrypting the connection string...or maybe creating a read only oracle account that I could give everyone the password to?

Thanks!
Jason

 

[SkipVought]

You ought to set up a read-only account in Access for this application and use this account instead of yours.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}