hi Phill

your reply was very helpful, thank you.

we don't the process at the moment. what we are trying is:

VB 6 front end and SQL 2K back database. then we need to send this data to other department. In other department they use Progress front end and Progress database as back end. Once they finish their work, they send data back to our SQL 2K database. so currently we don't have any access to Progress database but we need in feature to complete above tasks. I am thinking we need read-write access as both databases need to read data and then write.

you said in your first reply i need "MS SQL Server DataServer on Progress Server", do i need to buy SQL dataserver separately or this is come with Progress server?