Is there an VB API call that will return the drive and path of a database if I provide the DSN name?
For example, I have a Microsoft Access 2000 database located on a network drive: f:\apps\dbs\vstats.mdb. On a client machine I have a DSN for this database named "STATS".
I would like to programatically retrieve the network drive and path to the vstats database from the STATS DSN.
Any help on this would be appreciated. ---------------------------------
Art Madden
amadden@tampabay.rr.com
For example, I have a Microsoft Access 2000 database located on a network drive: f:\apps\dbs\vstats.mdb. On a client machine I have a DSN for this database named "STATS".
I would like to programatically retrieve the network drive and path to the vstats database from the STATS DSN.
Any help on this would be appreciated. ---------------------------------
Art Madden
amadden@tampabay.rr.com