VB Forum / Database Access / March 2004

I use ADO to fill an excel sheet with data from SQL Server.
I'd like to specify the field format for each one in the table.
How can we do it using ADO (CREATE TABLE ???)
Emmanuel CHONION

I am running the following code and get a runtime error 3265 when attempting to load the second record, the first seems to work.  The procedure deletes the contents of a table them attempts to reload values from an array
   For J = 0 To
       tmpStr = frmSysDefaults ...

I want to port my VB Access DAO application  into a VB ADO Access
application in order to have the same code able to handle a MS Access DB as
well as a SQL server 2000 DB. One of the things is to dimension a recordset
variable that is able to hold a DAO recordset as well as a ADO ...

I am considering to port a VB-Access to a VB MS SQL Server 2K. The main
reason for this is to achieve a robust database application that can be
accessed by more than 10 users and also from the internet. One of the main
goals is also replication/synchronisation facilities. Does SQL ...

I am writing a vb6 program that allow a user to change their SQL password using "sp_password".  How do I set this up using vb6.  I am ado not rdo.  I saw the example for rdo.  Can anybody give me some pointer as to how to do this.

I am trying to connect to Lotus Notes from Access using the following
code.
With cnnLotusNotes
         .Provider = "Microsoft.Jet.OLEDB.4.0"

I have a component in vb 6, which return a recordset to ASP page.
If recordset count < 22 records, it work OK. But if record count >= 22
records, it doesn't work!!
Please Help me.

I'm using the Microsoft ODBC Text Driver to select records from a CSV file.
One of the fields is numeric (unquoted), and when it contains large numbers
(10-digits), the dataset returns null values for those fields.  Any idea
how to get that data to show.

I am currently trying to insert a line into a foxpro table using VB6.  When
I run the insert statement, no error is generated but the line is never
inserted.  Also, If I open the table and then try to insert, there is still
no error (I would expect one since the table is opened by ...

i want to retrieve and open a Acrobat (*.pdf) file from an Access Database, that's stored on a OLE Object Field
I saw the example on http://support.microsoft.com/default.aspx?scid=kb;EN-US;q194975, but it hapens that the file that is written to disk it's different than the one ...

Sorry for the blank subject line in the earlier post.
I would like to know if theres any code which can enable me to unset the
password from my Access 2000 Database using VB?
Thanks,

I have an Access 2000 database containing an ODBC table linked to a SQL Server
2000 database (using a system DSN).
No problem opening the table Using Access 2000 itself.
No problem even within a VB program (EXE) accessing that table using the

I'm adding some database fields to an existing Crystal report.  Some of the
fields I've added don't display, either in preview or in the printed report.
I've checked the Access table holds valid data (it's simple text).  I've
checked the format of the field on the report (it's just ...

I am reading the article from MSDN.
It says not to use Jet and many other databases.
"Microsoft recommends that when you develop new applications, you avoid
using these components."

I have a VB6 app that loads some info from a default .mdb which resides in
the installation directory.  I use:
Set g_conn = CreateObject("ADODB.Connection")
g_conn.Open "provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.path &