I had the same problem and apparently there's a bug in the Microsoft Oracle drivers.
I was able to get around the prompt for userID and password by creating a pass-through query that runs in the on load event for my form. This query then passes all the connection information in the the query...
Hello Sullaway,
Thanks for the tip. I actually finally got it to work. I did have the DoCmd. statement correct but the Allow Additions property was set to No. Thanks.
Hello,
I am trying to get my form, which is linked to an Oracle table, to open to a new record. I've tried the standard Do.Cmd.... connected to both a button and an event and both return the message "Can't go to the specified record" - you may be at the end of the recordset. does...
Hello
My small database has two tables ActionItems and Status comments. These tables are linked Primary Key and Foreign Key together. I have a main form and a subfom that displays the status comments which could be many. I would like to be able to add new status comments to the form...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.