VB Forum / Database Access / December 2003

Okay can someone help me out.. I don't see it..
the addNew failes..
Dim Cnxn As ADODB.Connection
  Dim rsBoeken As ADODB.Recordset

Does anyone have an example how to write code that will do the following on
startup?
1.       Check to see if FILE DSN already in system ( IF EXSIST QUIT )
2.       If it doesn't create the new FILE DSN

I have a program set up that connects to a SQL Server
database using Windows XP/2000 integrated security.  It
works fine on my computer, but I now want to let everyone
use this program.  How would I capture the Windows logon

I have an app using VB6 and Access 97 that is multi-user
and has been running fine since 1997.  Right now the
Access database in on a server running Windows 2000
Server. Most of the user machines are running Windows 98.  

I have an ado control with an access dbase and i want to make a button that
when its clicked a specified wav or mp3 file will be played in accordance
with each record  on the access database. Does anyone know how do do this?
Jeroen

I am creating a table in Access through VB. I want to
change the "Allow zero Length" attribute of a column
to "Yes". How can i accomplish this through VB/Query.
Thanks,

h
I am using the Data Environment in VB6 to query an Access 2000 db.  I'm running W2K at SP5 with MDAC at v2.8
Most of my queries work just fine - but I keep getting errors when trying to execute some specific queries (which have worked fine in the past) - code snippet below
This ...

when i addnew a record to a recordset ,i got this error
how can i do?
thanks !

Sir,
 i have made an odbc connectivity with excel file as abc
through control panel.  but while opening record set
through this dsn, i am getting error saying that table not

    We have a (VB6) application that acts as a front end to a SQL Server
    2000 database. The app is running on Windows 2000. Since the customers
    that recently installed Service Pack 4, one of our forms started to
    generate the error: "Binding Collection Error - Field not updatable:

I need to open an adodb recordset from a proprietary data source and copy the results into a sql table on an msde 2000 platform. Unfortunately being msde I don't have access to setting up a linked server or to scheduling a DTS package. I figure I can open one adodb recordset and ...

I've got a datagrid which is fed by a dataset and allows
me to perform standard record navigation and maintenance
what I want to do though is filter these result based on
the text which appears in one column of the database

I'm working on an application that involves massive
databases. (Up to now our test data has been "small" and
the data adapter, data set, approach works fine.) But I'm
concerned that reading massive amounts of data from the

I have an ado control with an access dbase and i want to make a button that
when its clicked a specified wav or mp3 file will be played in accordance
with each record  on the access database. Does anyone know how do do this?
Jeroen

I made a program where wav files will be played from the database, with the
full path.LIKE
i = mciSendstring(open d:\sound.wav type waveaudio",0&,0,0)
i = mciSendstring(play d:\sound.wav ",0&,0,0)