SQL 3

[JoaoTL]

Hi, is there any link that provide me some sugestions how to use UPDATE, INSERT and DELETE Querys in a SQL server Database?. I need to Upsizing a MDB but i dont have a clue how to star because all this Queries types were not converted.

Another think, it is better to use ADAO or DAO in SQL server. This MDB is not to run under ASP.

Thanks Best Regards

---
JoaoTL
NOSPAM_mail@jtl.co.pt

http://www.jtl.co.pt

http://www.jtl.co.pt/Access

 

[aalmeida]

You can Start Here:

http://msdn.microsoft.com/library/default.asp?url=/nhp/Default.asp?contentid=28000409

I'm sure you'll find all the info you need.
I hope it helped you. AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[JoaoTL]

Thanks aalmeida for you link sugestion, it is perfect. Rigth now i am using MSDE that i think have a 2GB limit, my question is if MSDE work exactly like SQL Server.?

Thanks Again Best Regards

---
JoaoTL
NOSPAM_mail@jtl.co.pt

http://www.jtl.co.pt

http://www.jtl.co.pt/Access

 

[balves]

It's always better to use ADO.

 

[tlbroadbent]

In my limited expereince with MSDE, it performs just like SQL Server. There are papers available at Microsoft that note the differences in versions. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[JoaoTL]

Thanks very much for helping. I will work on your answers and try to make this work. Best Regards

---
JoaoTL
NOSPAM_mail@jtl.co.pt

http://www.jtl.co.pt

http://www.jtl.co.pt/Access