activex exe or dll for vb ( require code)

I am new to this topic.
Want to make a client/server program. In server i shall be just requiring the last record of the table. there are 15 tables in the db. DB is in Access97 with password .
IN the client i shall be entering data. the data is to be added in the concerned table. The table will be the same every time.
I wanted an activex exe or dll which ever suits my need here so that i can access the db from client also.
OR SHOULD I LEARN ANY NEW METHOD OR TOPIC OR APPLICATION ?

For VB6? Use the Winsock control to communicate between client and server. Send whatever data you need to send back and forth using Winsock. (There's no "last record" in a database because there's no guaranteed order of storage. You'll have to keep 1 field with the date and time entered/modified if you want to know which record is the "last" one.)

Welcome to the forums. :wave:

Here is some info on Winsock

Thanks a lot. I shall be understanding winsock and shall try. thanks once again.