VB Forum / Database Access / January 2008

im using VB6 and Access 2003
pdcon.Open
   pdrs.Open "Select * from PatientsDetail Where RedgNum=" &
txtRedgNum.Text & "", pdcon, adOpenDynamic, adLockOptimistic

hello i have installed a program that was made in visual basic 6.0 that
utilizes MS access 2003 . however, when i try to save or view the data (which
it calls up the MSaccess  file which it saves to), I get the error
Error 3170: Can not find installable ISAM

I'm just at the point of giving up on this aspect!!
I'm using Visual Studio 6 (so VB 6) to develop my app.
I have a good looking icon for my app, which is a white circle with bits
inside it, and with XP I get a good finish rather than the crappy Win98/Me

I'm using VB6 to dev.
My app doesn't have the standard windows menubar, as I've created my own to
make it a bit more graphical, but my problem is that because of this I can't
seem to have a title in the taskbar for my app.  I get a grey box with my

I you all! Thanks for reading!!!
I'm trying to download a text file through the download dialog box using Ado stream:
 set adoStream = Server.CreateObject("ADODB.Stream")
 adoStream.Open()

I've been unable to access the newsgroup Vb.database.dao using NNTP
newsreader.  However, I can access it through the browser.
The message that appeared is :
The newsgroup 'msnews.microsoft.com/microsoft.public.vb.database.dao' was

I'm using VB6 to dev.
My app doesn't have the standard windows menubar, as I've created my own to
make it a bit more graphical, but my problem is that because of this I can't
seem to have a title in the taskbar for my app.  I get a grey box with my

I have a stored procedure on a SQL server 2005 database. Application
accessing it is a VB6 program. The app returns the records fine. What
I would llike to do is after the recordset gets returned is to resort
it to one of the columns returned. Data is currently being sorted from

This has just started happening with one of my apps, the program is a VB6
frontend to a
mdb backend connected with DAO. The mdb and exe are in the same folder on
the HD of a laptop

I have a database with a field that contains a string with folder paths like
so:
[fldPath]
c:\folderA\folderB\folderC\

I am the most basic of beginners. My problem is my data reports quit updating
while vb6 is running. This happened to all my vb6 programs that have
connections to ms acess tables. (I only use one at a time) If I close the
program and reopen it the data table will be correct and i ...

I am using VS2005 vb.net.  I have a dataset.xsd file where I have
added a dataAdapter and built my queries using the built in Query
Builder.
I am connecting to an Access database with the following connection

Hi, I need to build a VB 6 comercial software, but the client can have the
option to choose what database he wants to use:
MSSQL Express
Oracle

Access 2000 VBA. I have a table-bound recordset that I can update just
fine (verified using Debug.Print commands) but it does not update the
table. When I have added new records to the recordset, I open the
table and it still has the same data it had when I started. Does

We have a client that is using a Jet 4.0 (2000) database on a server. This is
accessed by both Terminal Server users (10 users), and also networked users
within the same office (12 users). They are getting constant corruption (say
up to 10 times a day). All service packs are up ...