Has anyone tried using Access 2007 linking to tables/views in SQL Server
2008 R2 Express?
Any problems?

--

AG
Email: npATadhdataDOTcom

Am 02.06.2010 15:12, schrieb AVG:
Well,

if you use SQL2008 you cant, edit or create tables from Access. You have
to do this in the SQL-Database. if you would use 2005, you could solve
this problem easy from Access 2007.

Regards
Jörn Bosse

Jörn,

Thanks for the reply.
I would be using SSMS for creating & altering tables, views, procs, etc.
Also referring ot SQL Server 2008 R2, which just came out.
Any problems with forms, subforms, etc. bound to tables & views?

--

AG
Email: npATadhdataDOTcom


"Jörn Bosse" <joernbosse (AT) gmx (DOT) de> wrote

Am 06.06.2010 14:51, schrieb AVG:
The rest ist pretty similar to SQL2005 and there should be no problems.

Jörn

Thank you.

--

AG
Email: npATadhdataDOTcom


"Jörn Bosse" <joernbosse (AT) gmx (DOT) de> wrote

On Sun, 6 Jun 2010 08:51:21 -0400, "AVG"
<NOSPAMagiamb (AT) newsgroup (DOT) nospam> wrote:

Probably a bit too soon to tell. So you'll be on the bleeding edge.
<smile>

If you can though you might want to see if you can install SQL Server
2008 (non R2) Express on your own system. Then create a test system
to see if any strangeness exists just in R2.

Tony

Tony Toews <ttoews (AT) telusplanet (DOT) net> wrote in
news:d3c516lq8cpqqu8hi4lcs36ukgq8ov7mjl (AT) 4ax (DOT) com:

It's 64-bit only, right?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Thanks for the reply Tony.
I am currenty converting a large system from Access 2000 fe/be to Access
2007 fe/SQL Server 2005 Express be. When I get to the point of final
testing, I plan to try R2 Express. I was just wondering if anyone had
already tried it.
Typically, I stay away from new things until out for a while, but at the
rate this project has been growing, it would save some pain to not have to
worry about the 4GB limit. Since I won't be using any of the 'new' features,
I'm just hoping that they didn't 'break' the old stuff, like they did with
Access 2007.
I actually found a bug in Access 2007 where it doesn't construct a proper
where clause when requesting an inserted record for a form bound to an
updatable SQL Server view. I have on open case with MS for over three months
now and they are still scratching their heads to find a workaround - never
mind a fix.

--

AG
Email: npATadhdataDOTcom


"Tony Toews" <ttoews (AT) telusplanet (DOT) net> wrote

No, there are both 32 and 64 bit versions.
http://msdn.microsoft.com/en-us/library/ms143506.aspx

--

AG
Email: npATadhdataDOTcom


"David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote

"AVG" <NOSPAMagiamb (AT) newsgroup (DOT) nospam> wrote in
news:4c1380ce$0$4974$607ed4bc (AT) cv (DOT) net:

You're right -- I should have just checked what I'd already
downloaded from MSDN! It's Windows Server 2008 R2 that is
64-bit-only, I think.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/