Are there forms in SQL Server 2000/2005?

[liamlaurent]

Hello All

Is there a way I can use forms in SQL Server 2000/2005 like is done is ACCESS?

I have several ACCESS DB's that I need to port over to SQL Server and I was wondering if I could retain the use of my forms in SQL Server 2000 or 2005

Liam

 

[gmmastros]

No. SQL Server does not have forms.

You can use the forms you created in Access, but have the data come from SQL Server instead. I'm not sure how you do this, but if you post this question in one of the Access forums, I'm sure you'll get an acceptable answer.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[liamlaurent]

Thanks for the info.

Liam

 

[yetanotherjo]

You can link the SQL tables to your Access front end and use the forms that you have in Access. If you use SQL 2000 use ODBC, if 2005 use Native Client.

 

[liamlaurent]

thanks yetanotherjo.

Liam