I inherited some programs written by a previous employee. We have recently upgraded all our PCs from NT4 to XP SP2 and have upgraded Office97 to Office2003. The code connects an Excel spreadsheet to an Access database and extracts data from the mdb file
This program works perfectly on some PCs but not others.
Can anyone tell me where to start looking?
Dim DB As ADODB.Connection
Set DB = New ADODB.Connection
Dim RS As ADODB.Recordset
Sheets("Calculation").Activate
sFile = Cells(2, 7)
DB.Open "Driver=Microsoft Access Driver (*.mdb);DBQ=" & sFile
I would be very grateful for any assistance.
This program works perfectly on some PCs but not others.
Can anyone tell me where to start looking?
Dim DB As ADODB.Connection
Set DB = New ADODB.Connection
Dim RS As ADODB.Recordset
Sheets("Calculation").Activate
sFile = Cells(2, 7)
DB.Open "Driver=Microsoft Access Driver (*.mdb);DBQ=" & sFile
I would be very grateful for any assistance.
