Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 23rd, 2004, 01:49 PM
Registered User
 
Join Date: Aug 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Connect query w/ database(dao dsnless connection)

I am not very familiar with dao dsnless connection. Could any one take a look at the following and give me any insight?

I have the following SQL

set date=1/1/2003
Select Country name, short_name, maturity_date
    From Country, asset_master
    where maturity_date > Cast( date as char(20))
    and weighting number <> 0
    and country_name= 'Argentina'
    or country_name= 'Brazil'
    or country_name= 'Russia'
Order by Security Type Desc

And I want to connect this query table to a database call "DB1"
using dao dsnless connection. userid:'user',password :'pwd'
and display the result of the above query into a worksheet.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert ADO connection to DAO database dr_morose Access VBA 0 November 17th, 2004 05:44 PM
Connect query w/ database(dao dsnless connection) omnicap1 Access VBA 0 August 23rd, 2004 01:50 PM
Connect query w/ database(dao dsnless connection) omnicap1 Access VBA 0 August 23rd, 2004 01:48 PM
To connect Database with Connection Pool sudipta JSP Basics 0 June 8th, 2004 02:03 AM
How to connect .dbf file with ADO & DAO with code cbpanchal VB How-To 4 July 28th, 2003 10:14 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.