How can I automate an odbc connection

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: wtr100@xxxxxxxxx
Date: 16 Nov 2006 08:00:19 -0800

I have a MS Access database - inside the database are linked Sybase
tables via ODBC connection. Also inside the database are queries that
use a combination of local Access tables and linked Sybase tables.

I have a VBA module that runs the queries - below

[sample]
DoCmd.SetWarnings False

' q100_make_source_GRGR_BASE
DoCmd.OpenQuery "q100_make_source_GRGR_BASE", acViewNormal, acEdit

' q120_make_SOURCE_MEPE
DoCmd.OpenQuery "q120_make_SOURCE_MEPE", acViewNormal, acEdit
[/sample]

When the module is run a dialog box pops up prompting our operator to
provide the Sybase password. He only has to do this one time. Is
there a way to automate this?

.

Prev by Date: Re: Connect to dBase V files with ODBC?
Next by Date: Re: oracle odbc installation
Previous by thread: oracle odbc installation
Next by thread: Not an existing data source name. Invalid DSN.
Index(es):
- Date
- Thread

Relevant Pages

Re: office 2003 Word mailmerge with Access
... If you aren't able to see all of the queries then ... it's likely due to the connection method rather than permissions. ... Select the Access database as the data source again and when ...
(microsoft.public.office.misc)
Re: office 2003 Word mailmerge with Access
... Word 2003 uses a new default connection method, OLE DB, to connect to ... If you aren't able to see all of the queries then ... Select the Access database as the data source again and when ...
(microsoft.public.office.misc)
Re: Multi user VB6 Access Backend Database
... > I have a VB6 application which has to use an MS Access database as a back ... Usually use SQL Server. ... > Database', and the queries: ...
(microsoft.public.vb.database)
Re: Missing Objects in Database window
... >>I have an access database that has a number of tables, queries and reports. ... > and back will restore them - sounds like this is some other problem! ...
(microsoft.public.access.gettingstarted)
Re: access 2003
... I would focus on the queries behind the combo boxes. ... the Access 97 database, I wouldn't have thought any expressions would be ... When you select a customer and a job in the two combo boxes, ...
(microsoft.public.access.conversion)