Interface with other NON-ACCESSS Database

[music_al]

I'm developing a database but need to reference a different database table (employees) from a different NON-ACCESS database.

I will never need to update the data in the external database, just read from it.

Im guessing I just need to query but what syntax is used when referencing an external data source ??

I'll get googling in the meantime....


Al

 

[music_al]

Ive not been given any details as yet and I was thinking I might have to pay someone to sort out that part of this piece of work.

What are the questions I should be asking the DB Administrator ?

 

[DCrake]

Is the external db a proprietory db?
Can you see it in your browser?
What type of extension does it have?
Can the original by exported from the source?

David