VB Forum / Database Access / October 2005

I have written an access 2000 DB which uses ADOX to open and add fields
to an existing database.  I Can add fields no problem, I can modify
almost all the properties of the fields, EXCEPT the nullable property.  
The code below shows the different methods I've tried.  I generally ...

I'm looking for advice on the following problem.
I have inherited the development and support of an application consisting of
a Visual Basic 6 .EXE and an Access database.  We normally place both the VB
.EXE and Access database on a server.  The application is started from the

I am trying to use the Data Form Designer to create a form from a query in
my access database.  The query uses the "NZ" function and VB is returning an
error "Undefined function in expression".  Is there a way to work around
this problem or maybe an alternative to NZ?

I query a whole bunch of databases different SQLServers and bring back one
ADODB recordset from each server.  The recordsets are identical in schema.
What I want to do in my function is then to "concatenate" all the recordsets
into a single recordset to return to the calling ...

Hi everybody i have a winform app that uses sql 2000 for the database. And i
have a dataset too. I have null values in the database, and when i start my
app those null values of course show up in my dataset as 'null'. My question
is how do i convert those null values to be empty ...

I have a client /server architecture in vb6 with oracle 9i as the
database server.
everything else is working fine, client can connect to the server
server to the database etc....but the thing is that client is not able

I've got some files from a client that I would like to open up, but I'm not
sure what a ".dat" extension means. Anyone care to speculate on what
provider I could use to get to these?

Hi,  I have an application that requires me to create new, blank Access MDB
database files at runtime.  Right now, I have a blank MDB db as part of my
applications default install, and copy it when needed.  However, that seems
tacky.  If, for some reason, that file disappears, ...

VB6, SP6   on  XP SP2
I am getting reports of an occasional error 2147467259
Method ~ of  object ~ not found.
The code is unspecified error

I am using VB6 and Oracle ODBC driver.
I want to clear out the existing connections "immediately" without rebooting
the machine and without waiting for the CPTimeout to expire. (N.B. setting
the CPTimeout to zero in the registry does not take effect right away

how? thx

this may be a dumb question, but i developed an application and my
boss knows a little bit of sql so he wants me to create a program
where he can choose the tables and relations and so on, just like a
query designer in sql server or others and display the data.

Is it possible to generate an ADO Connection string for an SQL Server that
works across the internet (IIS)??
Is this a stupid question??  :p
ADVthanksANCE

I would like to get some data from SQL2000 database by a crosstab query. Can
I do this by ADO in Visual Basic? If yes, how to do it?
Thanks in advance.
Ivan

My code is like following
dim rs as new adodb.Recordset
rs.open "select * from articles", myConn
The problem is two of the columns in the table "Articles" are of type 'text'