VB Forum / Database Access / November 2006

helo everybody! i have a problem with my codes.i want to protect myy
page with a password.
if someone can help!!
here the error:

VB 6 Pro front end to Access 2000 9.0 useing DAO
I am trying to copy files from one "Source" table to another "Target"  table
based on a date range, so I can archive records from year to year. I stored
my dates in Access as  text  01/01/2005. I searched on the web and came up

I'm getting the wonderful "[ADODC]:  no RecordSource specified. [ADO]:
Command Text was not set for the command object" message!
Here's the very extensive code:
Dim SQL As String

vb6, ado, .mdb format, no access, win2k
sql newb <g>
assuming sql such as "Select F1, F2 From TableName Order by...."
with this order by statement

Help!
I found some code in this forum to do just this (dated 2002).
But when I run it the code appears to insert a gif image into the
database, but when I view the database Access tells me is has 'long

Hi, I'm getting the following error calling an Oracle procedure (within
a package) from VB6 using ADO:
PLS-00306: wrong number or types of argument in call to p_test
My PL/SQL code is as follows:

I'll better start by informing that I'm newbie into DB v/s VB.
What I need to do is to read from a different tables in a Access-DB and copy
the information into an array. For each table there is one array.
Could someone please instruct me, with example, on how to do it.

I am trying to access an MS SQL Server over a Novell network from a VB.net
program and I can't get the connection string to work. It works on other
clients that use Windows networks. Anyone know what I need to do differently
for Novell.

I have a boolean field that I added to an existing table in an Access
database. When I open Access it shows up as a text box with either -1
or 0 as a value. How can I change this in code so that when I add the
field it shows up as a check box instead? I know I can open the

I want to create datareport in vb6.0.
i want pagesettings of that report as A3 landscape, bcoz my table
fields are 20.
I m not able to change report size from default a4 portrait paper.

[posted earlier in other group]
Hi All,
I'm using the following code to delete one or more records from a DAO
recordset.

hello every boby i'm trying to delete a row in my table but i got an
error which i cant locate in my codes...if no one can help. here is the
codes:
[code]

Good day:
I am having the most difficult time with what should be a simple task.  
I want to fill a recordset using a stored procedure.  The recordset does not
even open.  The error message is ...cannot complete operation on closed

I need to install VB6 Enterprise on a machine that already has VS 2003 and
VS 2005 installed ... is this going to be a problem with over-writing newer
files ?
TIA

IDE: Visual Studio 2005
Language: VB.NET
Fox Pro Driver Version: 9.0.0.3504
Problem: I currently have a problem altering a DBF file.  I do not get