Search results for query: *

What about an AdoCommand object? adoCommand.CommandText = sqlStr adoCommand.CommandType = adCmdUnknown adoCommand.CommandTimeout = 15 #If AtClientSite Then adoCommand.ActiveConnection = ConnectObj #Else adoCommand.ActiveConnection = ConectObj.ConnectionString #End If...

I've connected using this method: ChDir "C:\" openString = "Driver={Microsoft Access Driver (*.mdb)};" & _ "Dbq=database.mdb;" & _ "DefaultDir=C:\;" & _...

This is an interesting bug. I have no technical explanation as to why this bug occurs but when I got it my solution was: ChDir "D:\Inetpub\wwwroot\HR\Db\H3.mdb" before doing the connection. Please let me know if this works for you.

Are you using WISE installer or installing thru VB? Usually to get this TLB file to install correctly, you allow the user to install Microsoft Data Access Components 2.0 (MDAC 2.0) available at: http://www.microsoft.com/data/download.htm 2.0 is pretty old so you might have to use 2.1 or later.

I would have to know exactly what the error is. If you send the project (bas frm vbp) files and the MDB file and i reproduce your error i will let you know the solution. send as attachment to cescobar@accela.com with a reminder of why you sent it.

The quickest way to learn SQL is by example. Open your database then create a new query using the Query Wizard. Pick the tables you wish to update then choose the type of query (Append, Delete, etc). To answer your 1st question: "How does one update a particular record with a unique...

Does anyone know how to retrieve their password from an Access 2000 Database? I've looked at examples on PlanetSourceCode but they did not work.