SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 advice for newbie please
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

denman73
Starting Member

3 Posts

Posted - 07/19/2006 :  06:33:17  Show Profile  Reply with Quote
I want to convert an Access-based application to a SQL solution with either a web front-end or Windows forms (it’s used by 120 users). Can anyone give me any advice? General advice is great but also can anyone help with the following:
(a) In my Access app I have a function that allows users to paste a comment from one form into a field on another. Will I be able to achieve this using either windows forms or ASP.NET VB?
(b) What is the SQL version of autonumber so that new records automatically have an ID that is unique in the same way that Access generates numbers?

Any advice would be much appreciated! Thanks

chiragkhabaria
Flowing Fount of Yak Knowledge

India
1907 Posts

Posted - 07/19/2006 :  06:40:07  Show Profile  Visit chiragkhabaria's Homepage  Send chiragkhabaria a Yahoo! Message  Reply with Quote
quote:

In my Access app I have a function that allows users to paste a comment from one form into a field on another. Will I be able to achieve this using either windows forms or ASP.NET VB?


Yes, for the windows form you need to write a small code for it, but
in the webpages this is the defualt option enabled by the web browsers.

quote:

What is the SQL version of autonumber so that new records automatically have an ID that is unique in the same way that Access generates numbers?



There is a idenitity property, which will allow you to do same in SQL Server

Chirag
Go to Top of Page

denman73
Starting Member

3 Posts

Posted - 07/19/2006 :  08:53:04  Show Profile  Reply with Quote
Thanks Chirag!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.17 seconds. Powered By: Snitz Forums 2000