PDA

Click to See Complete Forum and Search --> : Within Access 2000, connect to a DSN

JohnSmith
Dec 8th, 2003, 06:57 PM
From within an Access 2000 database, can you access an external DSN? If so how can I do this? I want to take data from another backend...
M Owen
Dec 9th, 2003, 09:55 AM
Sure ... Ex:

Set MyConnect = New ADODB.Connection
Set MyRecSet = New ADODB.Recordset

MyConnect.CursorLocation = adUseClient
MyConnect.Open "DSN=Billing System;"
JohnSmith
Dec 9th, 2003, 07:42 PM
Do I paste all of the recordset and connectionstring into a module?
M Owen
Dec 10th, 2003, 07:12 AM
That is up to you ... I cannot tell you how you should design your program.