Avoid Hardcoding --Link tables in Access and Oracle

From: <coakleyj_at_hotmail.com>
Date: Thu, 27 Jan 2000 20:07:00 GMT
Message-ID: <86q8gu$od4$1@nnrp1.deja.com>

Hi all.

I have inherited an application that uses MS ACCESS and Oracle 8.0.5, with MS ACCESS tables linked to Oracle tables.

Now the DSN is hardcoded into the MS ACCESS Design, which makes it difficult/error prone in swopping between development, test and live databases.

I have dome some preliminary work with linking tables in Access, and it always seems
to require giving it either the DSN or the tnsnames entry at design time.

Is there any way to aoid this, and force the user to specify the source to connect to (much like the default Oracle Forms login) and pass this detail at runtime?

Thanks for the help

Coakleyj

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jan 27 2000 - 14:07:00 CST