June 13, 2009 at 9:41 am
i jst want to know whether there is any way that i can create forms in sql server like we do in Ms Access.
any help would be appreciated.
June 13, 2009 at 10:53 am
Welcome on SSC 🙂
No, it's not possible to create Forms like in Access with SQL Server. You can create reports with Reporting Services.
To create forms use a client-side technology like .Net (C#/VB.Net/...) or MS-Access.
Flo
June 13, 2009 at 11:00 am
thank you so much..
June 13, 2009 at 11:02 am
and is there any way to combine access forms with sql?
June 13, 2009 at 11:06 am
For sure ;-)!
I'm not up-to-date with Access (long time ago) but you can use ADODB or maybe today ADO.NET to connect to almost any kind of database server.
Flo
June 13, 2009 at 11:06 am
smsam1 (6/13/2009)
and is there any way to combine access forms with sql?
I believe you can do that by linking Access to SQL. I haven't done it so I cannot tell you how.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 13, 2009 at 11:12 am
Alvin Ramard (6/13/2009)
smsam1 (6/13/2009)
and is there any way to combine access forms with sql?I believe you can do that by linking Access to SQL. I haven't done it so I cannot tell you how.
Hi Alvin
Usually it is possible to link SQL Server to Access via "adp" Files. But there seems to be a problem with using this feature for SQL Server 2008 (just googled)
http://blogs.msdn.com/access/archive/2009/01/21/adp-s-and-sql-server-2008.aspx
Anyway, connecting via ADODB/ADO.NET is possible and Access can be used a client application.
Flo
June 13, 2009 at 11:12 am
thank u for ur replies..
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply