VB Forum / Database Access / January 2005

I have vendore application written in VB and Access mdb as backend. As this
mdb file used as local (disconnected client) for each end user. This mdb file
are on the laptop and contains some confedential information. If this laptop
got stolen we are in big trouble.

I have an adodc and want to connect to a access db and bring across all
fields,  I have bound all the data.
The user will enter a number into a text box in the dialog screen, then the
next screen will come up with all the information if the number is in the

In attempting to use Visual Basic .Net standard edition I get error
message when using Wizard to attempt to connect to SQL Server dev
edition on same machine. This is not a limitation of that particular
edition VB .Net 2003 standard edition is it? Error message is that it

Novice vb6 and Access programmer. I volunteered at my local library to
create a scheduling program. There are 8 locations to schedule for 12 hours
a day. An employee changes location (1 employee at each location) every hour
(like playing musical chairs, don't ask me why). The ...

I'm running into an ado error when I try to do an ADO_Recordset.AddNew then
ADO_Recordset.Update.
Here's the code....
               adoRS = New ADODB.Recordset()

My question is simple.  How can I from VB on an ADO Connection retrieve the
SQL Server Process ID? It looks like ADO doesn't have a property, can I do it
through an API call?  The reason is to dynamically create a table with using
this unique process id for each instance of the ...

I work for a Public TV Station and have built two aoolications using
Access 2000 and VB5. The Access end is data entry and Editing while
the VB end produces a full screen display of one or more records which
can be scan converted and shown on air.

I have to connect my software to a dbf database.
I'm not practice with it....
I've always used mdb databases and ADO....
Now what have I to do????

I have to connect my software to a dbf database.
I'm not practice with it....
I've always used mdb databases and ADO....
Now what have I to do????

I am trying to use 'CompactDatabase' function to convert a database
myBase_97.mdb (Access 97) to myBase_2000.mdb (Access 2000) in a v6 programm
like this :
Call DBEngine.CompactDatabase(myBase_97.mdb, myBase_2000.mdb,, dbversion40)

I have two connections:
connct1="Provider =MSDAORA......)
connct2="Provider =MSDAORA......)
set c1 = CreateObject("ADODB.Connection")

I'm about to start an assignment for a client whose software uses
Crystal Reports 7.0. But he has no CD, and I have to find and purchase
it. 2 questions:
1- Based on my experiences, I have a tendency to buy the exact version

I'm new to VB.Net so propabally I do something totally wrong.
On my form I have a textbox (txtVoornaam) and I set the databinding
properties at designtime in the property palette to a field in my dataset.
   txtVoornaam.Text = dsAdressen.Personen.Voornaam

Hello Group!
Is there any way to assign a recordset with a combo box.
For instance,
Dim rs as New ADODB.Recordset

Anyone know what I'm doing wrong? I'm trying to connect Crystal Reports
v8.5 to an Ms Sql Server 2000 and keep getting the message, Unable to
open database. I get the message on the Report1.Action=1 command. I
connect using the command, LogOnServer("p2ssql.dll", "server", "db1",