Database Access & Read on Remote Server

[adamcox]

Using VB5 and Access 97 how can I read a database table on a remote server, scroll through the records until I find a field with a certain user defined value, then get the value from another field in that same record into a text box or label?

[Clunietp]

what do you mean by "remote server"?

Is this a server on the internet or server on your LAN?

[adamcox]

It's a remote server on the LAN (Running NT Server 4.0)