Posted to microsoft.public.excel.programming

[email protected] troy@sigwing.net is offline

external usenet poster

Posts: 3

Wondering why the following ADO connection to Access isn't working...

Dim MYdb As ADODB.Connection
Dim MYrs As ADODB.Recordset

MYdb.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents
and Settings\tsigwin\Desktop\Work Log .mdb;USER ID=admin;Password=;"
MYrs.Open "Select * from Work Log.Work Log", MYdb, adOpenDynamic,
adLockOptimistic

Any ideas?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ado connection to access vs. sql server?	Loane Sharp	Excel Programming	7	November 16th 04 05:08 PM
Excel/Access connection via ADO	Loane Sharp	Excel Programming	1	August 10th 04 01:17 PM
Excel/Access connection via ADO	Loane Sharp	Excel Programming	1	August 10th 04 12:15 PM
ADO Connection stopped working	Tod	Excel Programming	2	July 10th 04 05:25 AM
ADODB Connection to Access	Cindy	Excel Programming	1	February 27th 04 11:51 AM

All times are GMT +1. The time now is 10:11 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us