VB Forum / Database Access / April 2005

I have a VB6 application running on Windows 2000 Proferssional and SQL
2000 SP3.
Every once in a while I get a SQL error saying "[Microsoft][ODBC SQL
Server Driver]Communication link failure".  All my queries are very

I am using VB6 with an Access2002 sp2 database without any password
protection.  I have no problem to access the database until I try to print
reports. MS access password prompt appears.  It only happened to one of my
clients computer.  Need help.

Hello VB experts can you help with a problem with my syntax.
With the code below Im trying to update a field called 'Path' in a table
'tSchoolDetails' to 'dlgDialog.filename' (file selected in the common
dialog), I get the following

does anyone have vbRezQ by any chance?
would be most helpful as some b*&%$£D Erased my files
thanks
--------------=  Posted using GrabIt  =----------------

I need to write a program that can open different Dbase files.
If have write a routine to open a DBF ( see below).
if i use the connectionstring i get the error 'c:\Moeder.dbf' is not a valid
Path while

I'm wondering if someone can lend a hand with this.
I have a fairly simple VB6 application that's connected to an Access
database that contains one table.  I have the following bit of code:
Data1.RecordSource = "SELECT ColC FROM tblTable1 WHERE ColA = 'Total' AND

I am starting to play with stored procedures in VB and MySQL.  When I call
the procedure in VB, it returns a SQL syntax error. It looks it places a
space between the { and the procedure name, and that it causing it to fail.
Any suggestions on how to successfully call a stored ...

I am working on a VB6 project with Access 2000 and have a problem looking up
data.  There are essentially 3 lookups in the project, two by text, and one
by date.  I have tried everything I know to get the date working: maybe I
need to do something like a date conversion routine?  ...

I am beginner and get error when trying to compile.
Compile error:
Can't find project or library
pointing to error in code is

In:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvbdev00/html/
vb00j1.asp
I found the following recommendations:
---------begin snip-----------------

We are looking for a Visual Basic 6/NET developers
Project :
- Requirements and Use Case prototipation tools  
_ Internal Tools maintenence

Set DatSecondary = frmLogin.dB.OpenRecordset("select * from unit_type _
order by type_id")
units = DatSecondary.RecordCount
I KNOW that there are 10 records in this table...

I've just used the "Data Form Wizard" in VB6. This is a starting
point for me to learn something about data management  in VB6
So that's all I did... used the wizard. Didn't do anything else,
I swear.

Currently running a VB5(!) application using ADO into Jet.
Did some maintennance programming, and obviously I'm using slightly
different ADO to most client computers.
Works great on my XPsp2 machine.

I have a VB6 app that uses DAO.  A while back we went from DAO 3.5 to DAO
3.6 and old, old installs that were still using Access 2 databases needed to
be converted to Access 97.  On a couple of recent upgrades to users who have
XP Pro and appear to have a newer version of Access, ...