know nothing about MsSQL

Hello,
I use Access as my database. Can someone direct me to a good source to
determine if I need to upgrade to MsSQL and costs involved?
Thanks,
Dave
If you know nothing about MSSQL then what makes you think you might want to
upgrade? Is there something Access isn't doing for you?
David Portas
SQL Server MVP

know nothing about MsSQL

Hello,
I use Access as my database. Can someone direct me to a good source to
determine if I need to upgrade to MsSQL and costs involved?
Thanks,
DaveI searched around a bit and can't find much on this topic. This article
appears to have some rough guidelines:
http://builder.com.com/5100-6388_14-5035130-1.html
I'm cross-posting this reply into microsoft.public.access in hopes that
you'll get some better info there.
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:6146AFDF-A9D3-433F-A4FB-A43A53D2A50B@.microsoft.com...
> Hello,
> I use Access as my database. Can someone direct me to a good source to
> determine if I need to upgrade to MsSQL and costs involved?
> Thanks,
> Dave|||Don't know for certain, but there's probably something in Mary Chipman and
Andy Baron's "Microsoft Access Developer's Guide to SQL Server"
http://www.amazon.com/exec/obidos/ASIN/0672319446/ref=ase_mcwtechnologies/104-2234668-9725519
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:OuWdnaF5EHA.2180@.TK2MSFTNGP12.phx.gbl...
> I searched around a bit and can't find much on this topic. This article
> appears to have some rough guidelines:
> http://builder.com.com/5100-6388_14-5035130-1.html
> I'm cross-posting this reply into microsoft.public.access in hopes that
> you'll get some better info there.
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>
> "Dave" <Dave@.discussions.microsoft.com> wrote in message
> news:6146AFDF-A9D3-433F-A4FB-A43A53D2A50B@.microsoft.com...
> > Hello,
> > I use Access as my database. Can someone direct me to a good source to
> > determine if I need to upgrade to MsSQL and costs involved?
> >
> > Thanks,
> > Dave
>|||If you know nothing about MSSQL then what makes you think you might want to
upgrade? Is there something Access isn't doing for you?
--
David Portas
SQL Server MVP
--|||"Brian" wrote:
> 3. The SQL Server Desktop Engine is free, and is a serious piece of
> classy technology.
Well after all it is just SQL Server with some stuff clamped down.
I would recommend this to lots of people, if only it came with Enterprise
Manager! There are a few shareware replacements, but IMHO, they suck.
Maurysql

Key column information is insufficient or incorrect. Too many rows were affected by u

I have edit sql server 2000 table record by vb or direct enterprise mangafer and i have recived one message "Key column information is insufficient or incorrect. Too many rows were affected by update." any guys know this problem pl send the solution

Manish jain

ThanksThe Name Of Allah
hi

In the following table, for example, the error message appears if you attempt to delete one or both of the rows containing "abc" by using SQL Enterprise Manager with the following steps:
1. Right-click on the table.
2. Click on Open table, and then click on Return All Rows.
3. Highlight the rows, and then press the Delete button.

Character_Column1 Character_Column2
abc abc
abc abc
zxy zxy
fgt art

Eng. Maged