471,071 Members | 1,173 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,071 software developers and data experts.

openReport over ODBC to Oracle

Hi, I could need your help.

I am working with ACC97 as frontend and Oracle9 as database. All Queries are made as pass-through-queries. Everything looks fine, but I can't handle the OpenReport to the remote Database.

When I start the DoCmd.OpenReport, the ODBC-View pops up and I have to fill out the popup manually. But I like to set the database-name and the pwd only one time during the opened access.

Is it possible, to give the Connection string to the openReport Command ?

Or is there an other feature?

Thank you for helping me
Jul 14 '06 #1
1 2252
MS Knowledge Base Article KB101084 does not EXACTLY deal with your issue but does shed some light as to where you might look to troubleshoot.

It states: "For Microsoft SQL Server, Sybase SQL Server, and ORACLE Server databases, your SQL database administrator can choose to disable this feature, requiring all users to enter their login IDs and passwords each time they connect to a SQL database."

The "feature" they are referring to is: "In Microsoft Access, when you link (or attach in Microsoft Access 2.0 or earlier) a SQL database table, you can choose whether you want Microsoft Access to store your login ID and password locally. If you do not, Microsoft Access prompts you for your login ID and password each time that you connect to the SQL database containing the table."

The bold part (above) seems to indicate that there might be a system setting that would if turned off, makes you login each time you access the Oracle back end

Hope that helps - best regards,
Jul 15 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by SerGioGio | last post: by
4 posts views Thread by Andreas Lauffer | last post: by
1 post views Thread by Crazy Cat | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.