Recent content by Benny Lim

Hi anybody, I am linking MSAccess to Oracle via ODBC but whenever I run the query it prompt me for User ID and Password. How to over it? Anybody please help????

I like MSAccess. :) Simple and useful.

Hope this can be useful for you. (Form) Function ObjectExists(strObjectType As String, strObjectName As String) As Boolean Dim db As Database Dim tbl As TableDef Dim qry As QueryDef Dim i As Integer Set db = CurrentDb() ObjectExists = False If strObjectType = "Table" Then For Each tbl In...