VB Forum / Database Access / December 2004

Hello - I'm in the process of writing an application that needs to support
MySQL and SQL Server using VB6.  I'm wondering if anyone can offer me any
tips or gotchas to look out for.
I'm also looking for best practices in how to setup the configuration for

Is there any special trick for inserting a guid value into a "Replication  
ID" field in Access 2000?
I'm trying to do this using ADO:
con.execute "INSERT INTO my-table (guid) VALUES ('" & guidvar & "');"

I'm using ADO from ASP VBScript to write to an ntext column in an SQL Server
table.
The string size is 20555 and I use AppendChunk to add chunks of 1000
characters (20 chunks + 555 leftover).

Hi , I am using MDI form as the menu for my program. I
have 2 form which both need a connection to database MS
Access. This is my coding to connect to database.
Dim MyConnR As New ADODB.Connection

I'm used to program in Foxpro, and a bit novice in VB. In Fox macro
sutstitution can be used for variable names, file names, and code snippets.
Example:
cVariable = "HotelName"

What is everyones' opinion on writing VB code and having every
subroutine/function instantiating a new instance of a connection object and
opening the connection to the database?
I'm currently supporting a VB6 program that has about 25+ of these within

I am having a problem, and I was hoping that someone here could help me.  I
have an Access database define that contains two tables.  There is a third
table defined in the Access database which is linked to a SQL Server table.
While I am in the Access environment, I can query ...

I have a question.
Is it possible for my DataReport, after the Activate event, to set the Zoom
from 100% value to 75% value automatically?
thanks for your help!

I am brand new at using Visual Basic .Net.  I am constructing an application
that is using an Access database.  I am trying to write orders to a table and
I am getting an error that is staing that syntax error arose on the INSERT
INTO command.  I was wondering how to debug this ...

I am trying to connect to a SQL server 2000 machine (with SP3). This machine
is not on the domain. I have an application (written in VB 6) that tries to
connect to this machine (from a WinXP box that is on a domain) using SQL DMO
(need to do this to determine if the user trying ...

can anyone pls tell me what to do?
i have done all the connections that need
to be done, but this error keep comming-up
(error 3265)

How can I create  a new sql server user in VB alongwith rights
priveleges of db_datareader and db_readwriter.

I have several calls thruout my application to guery an access database with
more than one table, and it works fine, but in the log-in screen I am trying
to load default settings and it is not working.
Using win98, VB6 & Access2000.  The VB application, in the form load event,

i am trying to get a string as follows from sql server
select 'hello this is firstline ' + char(13) + 'this is second line'
in the results pane of the query analyser the second line comes below the
first line as expected

When I close my application (in VB6 with Access 2000), I still have
processes runnning.
Actually, it only occurs when I print a report, otherwise the application
ends normally when I close the last window.