Search results for query: *

hi - i'm opening up an access db and want to have a count of all the records in the recordset, here's part of my code getting that recordset: sql = "SELECT * from Job" Set fEmpRS = fEmpDB.OpenRecordset(sql) is there a set way of knowing how many are in a recordset? thanks!

Hi - I have a couple of questions.. any response is appreciated! First, I am accessing an Access 97 database with VB 6.0. I should first tell you that I;m currently running Access 2000 but since there was too big an issue making it work with VB 6.0 in Access 2000, I'm pressed for time so I'm...

in access or vb? i didn't see references in either

ok, here's the thing. the ADO connection works great, but the problem is i'm doing this project for a prof. to teach a class and it has to be a DAO connection. is there just no way to get a DAO to work with access 2000?

gwinn7 - I know you asked what my string was with the ADO... here it is: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\WINDOWS\Desktop\vbproject\EmployeeDB.mdb;Persist Security Info=False

Hi - thanks, but I guess I don't know much about this. What's mdac 2.5 or 2.6 and how do i implement it?

Hi - Is there a way to access an Access 2000 database with VB 6.0? I keep getting the error, unrecognized database format.. thanks!

Hi - I'm trying to access an Access 2000 db through VB 6.0. I keep getting the error "Unrecognized database format". Any ideas how to fix this? Thanks!