VB Forum / Database Access / July 2009

After re-installing Windows XP Home Edition and clicking on VB.exe in the
VB98 directory of Microsoft Visual Studio, this error message comes up>
"Can't find DAO350.dll"

I am going through the book Microsoft Visual Basic 2008 - Build a program
now.
I having trouble with the car tracker program everytime I am to access its
database I keep on getting this message

VB6 using DAO on a networked mdb file.
I have queries returning hundreds of records that are therefore slow
to return. Being that the user only sees a display of about 15 at a
time I want to limit the return to 15 and have a "next" button to get

I am using VB6 to open ms access database via ODBC, my DSN is "Local"
using password (have set inside DSN).
My code is:
   strConn = "ODBC;DATABASE=;UID=;PWD=;DSN=Local"

I was wondering if anyone had any thoughts on how I could optimize,
improve or outright replace my SQL query - It is currently taking a
long time (1-2 minutes) to select 65 records with sub-selects taken
from a table of about 600-700 records. Here's the (reduced) query:

I am having problem in using sql server 2005 DB in my VB6.
It says PRovider not found .i am using "SQLNCLI10" as provider in my
connection string..
cn.ConnectionString = "Provider=SQLNCLI10;" _

Olaf-
The "CreateTableFromRsContent" is suppose to create a table from a
recordset, correct?
If you set (temp table) as true, does this mean it goes away as soon

I have such a problem. No usefull info on Internet :(
I have a table with several fields, and some of them are of type Date,
having format "Short Date".
At this time I want to add one new colums of type Date, with with short date

Say you have 10 years worth of data. Your data fields consist of:
DayNum (Day Number, 1-366)
High
Low

Just so I get these things clear in my mind.
Q. Can you get data out of a TABLE without having to create a
recordset?
Q. What if you just wanted to access a single cell in the Table?

I have a weird problem involving vb6 and MS Access. I'll explain in
detail the problem to see if any Access guru can shed some light into
this issue. Just in case if it helps, It started happening when we
installed a new software in the computer. I have been doing some

I don't know which newsgroup to go to but this seems the closest.
I think my Visual Basic might be messed up? I can't open programs that
use an Access-based file system like Adobe Photo Album, Asset Manage
etc... (programs that don't require Access installed) and when I open

I'm trying to formulate a SQL statement that will fulfill what I need
to accomplish.
Here is what I have:
Table: dtaTable

What happened to good ole' Olaf? Been missing.
Here is an SQL statement Olaf helped me with:
   SQLString = "SELECT
CLng(Last(Month,ID))||'/'||CLng(Last(Day,ID))||'/'||Year as Date, " &