Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
token
Posting Yak Master
133 Posts |
 Posted - 2005-11-21 : 17:53:11
|
| hi,as a previous user of Access, i was wondering if SQL Server provided any means of creating a Form through which I can enter in data to be stored in a table?cheers,token |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-11-21 : 18:21:39
|
| You can do this via Enterprise Manager if this is just to enter data by you. If however you want to create an application, then you can use almost any programming language that can use a data provider of SQL Server. I'd recommend VB.NET or C#.Tara Kizeraka tduggan |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-11-21 : 19:09:52
|
| You can also create linked tables in an Access database that connect to your SQL Server. Access even provides Data Projects specifically for this purpose. |
|
|
|
token
Posting Yak Master
133 Posts |
Posted - 2005-11-21 : 19:16:06
|
| how can I make a form in Enterprise Manager? just point me in the right direction and I'll work it out.Cheers! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-11-21 : 19:17:52
|
| You can't. If you want to enter data, you can right click on a table, open table, return all rows. You can then enter data into that screen. When I said you could do it in EM, I meant enter data.Tara Kizeraka tduggan |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-11-22 : 01:57:48
|
| Use Query Analyser to enter dataIf you try to enter data thru EM, you will get error if there are duplicatesMadhivananFailing to plan is Planning to fail |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-11-22 : 21:28:32
|
| If you want a simple way to create forms, use Access. If you want something more robust, use .NET. You can go to ASP.NET and get starter kits, tutorials, and lots of great articles that should get you started quickly.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
token
Posting Yak Master
133 Posts |
Posted - 2005-11-23 : 19:38:27
|
| thanks for the advice!! |
|
|
|
|
|
|
|
|
SQL forms?