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 cannot be null. Parameter name: key

We just upgraded to SS2005. After the upgrade, we can no longer create
subscriptions out of Execution Snapshot.
Try this experiment:
Create a report, with a simple SQL statement like "select * from CustomerDim
where CustomerPk = @.CustomerPk"
Go to Report Parameter, check the "Allow Null" box
Deploy the report
Go to the report on report server, render the report from Execution Snapshot
Now go to Subscription, and try to create a new subscription. The Parameter
CustomerPk will be grayed out, because of the Execution Snapshot
After you clicked OK, the subscription will return the error:
Key cannot be null. Parameter name: key
This error does not occur before the upgrade.
How can we create subscriptions out of Execution Snapshot in SS2005?
Thanks,
John WI've got the same problem. Did you find any solution?
Regards,
/Mattias
"LBJOHN" wrote:
> We just upgraded to SS2005. After the upgrade, we can no longer create
> subscriptions out of Execution Snapshot.
> Try this experiment:
> Create a report, with a simple SQL statement like "select * from CustomerDim
> where CustomerPk = @.CustomerPk"
> Go to Report Parameter, check the "Allow Null" box
> Deploy the report
> Go to the report on report server, render the report from Execution Snapshot
> Now go to Subscription, and try to create a new subscription. The Parameter
> CustomerPk will be grayed out, because of the Execution Snapshot
> After you clicked OK, the subscription will return the error:
> Key cannot be null. Parameter name: key
> This error does not occur before the upgrade.
> How can we create subscriptions out of Execution Snapshot in SS2005?
> Thanks,
> John W