Search results

Yeah, you're rigth, but try to explain that to my client! :D

I'm not sure if it should, but i'll test it next time I can access the Oracle Database... the 16th of June! :( Since then, I'll just try yo get more info on this one... thanks a lot, Pat! :)

Here it is: Public Sub OuvrirConnexion() Dim Conn Set Conn = New ADODB.Connection Dim strConn As String strConn = "Server=myserver; DSN=myDSN; UID=myusername; PWD=mypassword" ' The connection works, I have no doubt about it. If I don't provide a password, it prompts for...

Still have a problem... Well, it does in some way, and thanks for the code :) , but I still have an unsolved problem, an AOP (Access Oriented Problem ;) ). I made some queries that uses some linked Oracle tables. The Oracle DB is secured by a username and password. When I run a query, an...

Hi, I try to connect to an Oracle Database using VBA, but i'm prompted to insert my username and password, which is a bad, bad thing! Does anyone knows the syntax to put the username and password in my connection string?

Newman, you're disapointing me :D

Hi! I need to execute an update query, but I have to do it while the database is closed, overnight. Is there a way to do it with, for example, a VBSccript? I plan to use the Windows Scheduler to trigger the script. Thanks a lot!

Hi! Here's my problem : I have a form with a subform in it. The subform must have 4 rows when displayed on screen, but 10 when I print the form. Is there a way to do it? :confused: