UNCPath or absolute?

[Dimst]

Hi,

Is it possible in access 2000 to make an uncpath instead of an absolute path to a odbc datasource?

in the select statement and other properties the referred database, for example database_test, is mentioned; the query is then like

select database_test.iCustomerID from database_test.Customer.

I rather have

select iCustomerID from
Customer

I know of course that i can change the SQL statement, but the problem remains, the error that the "database_test" as set by property cannot be found.

As far as i have searched i haven't found the possibility to change it.

The reason i would like this is that i have to change between for example:
database_test
database_test2
and
database_test3

(several testpurposes...)

Thanks in advance

-Dims

"Wearing sunglasses won't help taking my brightness away"

 

[SkipVought]

Hi,

Check out

http://www.carlprothman.net/Default.aspx?tabid=81

http://www.connectionstrings.com/

Skip,
[sub]
To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white] [/sub]

 

[Dimst]

Thanks for the answer, it can help me a lot by my db!

-Dims

"Wearing sunglasses won't help taking my brightness away"