Try using DataView. If you use FrontPage you will find it under
Insert/Database/dataview. This will bring data  from the database  but with no
control whatsoever. So next thing would be for you do is to write some code to
give the page some actionpower. ASP.NET VB or ASP.NET C#.
If you have access to infopath and a web  service that could be a solution. I
tried that one but i failed to write the web service. In the end i made my form
in ASP.NET C# .
I will look into this and if i have a better idea i will let you know.

Is FrontPage available for download ,if not any other option to go for.

Frontpage comes as part of your Office'2003 installation. Its just an office
component.

FrontPage 2003 does not come automatically with Office 2003. Take a look at
www.microsoft.com/.../default.mspx

Yes , it depends on what licencing agreement you have with Microsoft.
Nevertheless, the licence for Frontpage is like 100$/host. Not that much when
you compare to the cost of SPS. I really cannot imagine my life without it. It's
so usefull that i consider it to be priceless.