VB Forum / Database Access / November 2003

I get  an error when I try to run a vb6 program after access 97 has been
converted to xp. The error says run time err 3343 unrecognized database
format.  Is there something I need to set in VB6 to recognize xp>

Hi...hopefully can help me with this.  I have written a front end to an
Access database and I want to make a modification.  I've changed the textbox
to a richtextbox so I can have formatting(bold, color, font, you know the
drill).  Anyway, I would like the formatted text to be saved ...

VB6E SP5
How do I set the orientation for a data report at design time? Portrait /
landscape.
Prima facie, it seems that the report takes its cue from the VB settings.

Is there a good tutorial about database normalization?
Is it the 3rd or the 4th normal form that is more used in the industry?
Thank you.

I am working with a recordset that has column names aliased. It seems that
the Recordset Find method has difficulty with spaces in the column name.
Example;
 With m_rs

Thank you in advance for any and all assistance.
I have a small program that I built in Access 97 and I'm trying to port it into
VB6 and the problem I'm having is that the ADO or DAO recordset are not
populating the combo boxes. What do I need to do to pull that information in

I'm starting on a new "simple" project.
In the first part of the project I will have to create a database with one
table, this table will have about 2114125312 entries.
Creating the "string" that will go in each of those records is easy (less

How do I insert a date that is stored in a variable into MySQL
Currently, I'm doing this:
'store the date taken from foxpro dbf table into a variable:
tmpDate = rsFoxpro("StartDate")

How do I store something that is of Logical value in foxpro dbf table to a
variable and VB.. and then how do I bring the write that value into MySQL?
For string I know its something like this:
String1 = rsFoxpro("Field1")

I'm looking for a function that runs sql-scripts to add new
SQL-SERVER-OBJECTS to the current DB.
The code should run from the interface.
So a form having a textbox that hold the script (path+name+extention) and a

I have a SQL statement which I am passing to open a recordset, the
error is failed to parse SQL statement.  I know the SQL statement
syntax is fine because I can run the SQL via Query analyser.  The most
obvious thing is that the SQL statement is long around 6400 characters

I have two identical tables - 'name' & 'name_view'.
Someone edits 'name'. I don't need the specifics of the
change, just need to know if the table has been changed. I
susspect there's something in the schema that I could

Does anyone make nested transactions with Vb6, ADO, OLEDB for SQL SERVER and
SQLSERVER
HOW?????

my question is, can i make a VB.NET program using an MsAccess DB and
install it on a computer which doesn't have MsAccess installed?  The
installation program would copy the DB file, but will it run if MsAccess
is not installed.

I am trying to join together 3 separate dbf files (common field is SITE_ID)
using the following sql statement in an asp page:
strSQL = "SELECT extents.*, usgsdata.*, usgsgage.* FROM usgsgage.dbf INNER
JOIN (extents.dbf INNER JOIN usgsdata.dbf ON extents.SITE_ID =