DSN with Access XP

[gscheepers]

Hi,

One of our databases uses a DSN connection to an Oracle server. We've just upgraded to Office XP and I converted the old Access database which was Access 97 to Access XP. Since I've done this, I get prompted for the password each time I open the database.

This is the current line of code that I have to connect to the oracle database:

Set db = wrkJet.OpenDatabase("", False, False, "ODBC;DSN=Personnel;UID=Personnel;PWD=person;&quot

Has anything changed in Access XP regarding DSN or is their something wrong with my code.

Thanks, Gerhard Scheepers
BA - LETEC

 

[petersdaniel]

Gerhard,

Under the Access 2000 and XP(2002) platform, you need to be utilizing ADO (ActiveX Data Objects) versus the old DAO methods.

Microsoft has a good overview document on the migration from DAO to ADO here..

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndao/html/daotoado.asp

Hope this helps