VB Forum / Database Access / February 2008

while using an Access 2007 .accdb file I can access the dao. object very
easily.
the following code in VBA works well :
Function getrecordcount(strTableName As String) As Long

I have a new project to use VB as front end.
I would like to know does professional version support ADO and SQL server
backend and web base application?
If yes, then how much will be cost?

I have an Microsoft Access Subform, where I delete some Records at once.
To enumerate the deleted records, I take two RecordSetClone of the form.
The first before deleting. (Set rstBefore = Me.RecordSetClone)
The second after deleting. (Set rstAfter = Me.RecordSetClone)

In one of my VB6 programs, there are several text boxes on a form that
are tied to an ADO Data control with the following SQL statement to
connect the Data control to a table in an SQL Server database:
Adodc_Projects.RecordSource = "SELECT * FROM Projects ORDER BY JobNum"

I am a beginner and having difficulty understanding some database connection
related issues. I started off with VB Express 2005/2008 and have moved to VB
2008 Professional (The trial edition currently).
1. In VB Express when connecting to a database I was given a choice as to

I am running an Update routine that calls a function.  It appears that the
function never executes because I receive:
Must Declare The Scalar Variable @Country.  
Code:

Writing a VB6 program to update VFP tables.  I need to update some date
fields and get the error 'function not implemented' when using syntax such
as:
update table1 set datefield1=ctod('2006/04/16') where criteria1=value1

I'm trying to backup a database but I want the process to be run in
the background so it doesn't lock up my program. I am doing the
following inside a class, it backs up the database in the background
just fine but it never fires ExecuteComplete. Any idea why??

Guys,
I have declared 2 dataRows and assigned New daraRows as below.
Dim aRow as DataRow
aRow = OutFormat.DataSet.Tables("demotbl").NewRow  '*** Point 1

I have a program written with VB6, using DAO and Intrinsic Data control
The Setup is written in InstallShield 2008 and includes the MDAC 2.6 merge
models.
Normally all works fine, but on some of my customers installations (German

I have a VB.net app that connects to a remote SQL server via TCP/IP. Most
folks can connect just fine. However some enterprise users are in a
corporate environment that will only allow connections through a corporate
proxy server.

Iuse ADO and I would like create automaticly a table in access with a text
file I use
semi-colon (;)
exemple

SQL Server 2005, VB.NET 2005...
In a cross database query, when I insert a set of records, then in a
subsequent query attempt to update those records, the update fails to see
the newly added records.

I am trying to extract user data from Active Directory and locate it in an
offline Access database for reporting. The problem I have is when I came
acrsoss an object where an attribute is empty.
I tried to trap this with an isDBnull call (as below) but this does not

  I've been on the newsgroups for days now looking for an answer to
this problem. While I've had limited success reading dbf level 7 files
something always goes wrong once I make it more complicated. For
instance I was able to read in a dbf table using ODBC and even able to