VB Forum / Database Access / April 2005

very, very stupid question, but for some reason the following code
starts me on record 22 of my table, not 0... ???
Set db = DBEngine.Workspaces(0).OpenDatabase(App.Path &
"\Counting.mdb")

I've been searching the archives for the answer but I have found none,
so I've decided to post. I've written a vb.net app that:
1. creates a SQLConnection object.
2. opens a connection via this object.

I'm having a difficult time figuring out how I should do this. I have a
field in a SQL database that I need to add to a text file that matches other
fields. The biggest problem is, the only matching field that is common to
both is a birthdate field and it isn't unique, it's close ...

I hope someone can help me with my problem, working now about 2weeks
on it and still haven't found something.
I have an ADODB.Recordset and try to open a Table from an MS-SQL2000
Server. The Table has about 1.050.000 Entries.

I am using VB6 and an Access 2000 format database (created in Access
2003).  I am trying to use ADO to connect.  When I run the app, it stops
with a Compile error: Expected Function or Variable. I click OK and it
highlights 'Private Sub Form_Load()' in yellow and '.Open =' in ...

I'm using the DBGrid32.ocx control, but can't locate the help file
DBGrid96.hlp.
It was nowhere in the Visual Studio Tools 2003, where the DBGrid32.ocx was
found.

Hi
I have Ms. ListView in the MS.Access in the Form
I can change size and move columns by mouse
But I don't know how do it this that  Visual Basic should be remember

i wrote code in VB to connect and use a MSSQL db, it runs well on my develop
machine (winXP sp2) when i use it on a Win2003 server i have got a
problem....
i wrote:

I have a procedure that I run on SQL Server and am calling it from
within VB6 using ADODB connection.
My problem is that the procedure executes in about 1-2 seconds on the
server when called from Query Analyzer, but sometimes will timeout

hi, yesterday i posted this mail, no answer for now.
i see that the problem disappear if i login as administrator with no
limitation, because i'm not the administrator of the server i'd like to ear
any suggest to the source of the problem

I have a reference to DAO3.61 in my project - and, when I compile the
project, I get an error on this line:
Set MyRs = db.OpenRecordset(strExactTable)
Method or Data member not found - - I copied the files from another project,

Hello --
I am a newbie to IIS and SQL Server.  Please advise if this question should
be posted to another resource/newsgroup, and, if so, which one(s).
Using Win 2000,

[url]http://www.xpstyle-menu.com/[/url]
Office XP and .NET Style ActiveX Menu Control
Office XP and .NET Style ActiveX Menu Control is the easy to us
ActiveX control for VB that gives your application Office XP styl

I have a table called Button. It has the following fields: ButtonType,
CControl_ControlLabel, CControl_Height, CControl_Width.
I want to create a recordset, to later insert it into that table.
mDAORecordSet.Fields.Append "ButtonType", adVarChar, 255,

i have 20,000 records and dumping one database to another database by
doing some massaging using vb6 like adding new clulns...
its taking around 4 hrs time to process the 20,000 records.
pls tell me is there any best way to do this???