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...
Printable View
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...
Sure ... Ex:
Set MyConnect = New ADODB.Connection
Set MyRecSet = New ADODB.Recordset
MyConnect.CursorLocation = adUseClient
MyConnect.Open "DSN=Billing System;"
Do I paste all of the recordset and connectionstring into a module?
That is up to you ... I cannot tell you how you should design your program.