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

--

AG
Email: npATadhdataDOTcom




From: Jörn Bosse on
Am 02.06.2010 15:12, schrieb AVG:
> Has anyone tried using Access 2007 linking to tables/views in SQL Server
> 2008 R2 Express?
> Any problems?
>

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
From: AVG on
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(a)gmx.de> wrote in message
news:86nb0gFf50U1(a)mid.uni-berlin.de...
> Am 02.06.2010 15:12, schrieb AVG:
>> Has anyone tried using Access 2007 linking to tables/views in SQL Server
>> 2008 R2 Express?
>> Any problems?
>>
>
> 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



From: Jörn Bosse on
Am 06.06.2010 14:51, schrieb AVG:
> 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?
>
No i don´t think so, the table-desing would be the only "problem"
The rest ist pretty similar to SQL2005 and there should be no problems.

Jörn
From: AVG on
Thank you.

--

AG
Email: npATadhdataDOTcom


"J�rn Bosse" <joernbosse(a)gmx.de> wrote in message
news:hug5p7$k7c$03$1(a)news.t-online.com...
> Am 06.06.2010 14:51, schrieb AVG:
>> 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?
>>
> No i don�t think so, the table-desing would be the only "problem"
> The rest ist pretty similar to SQL2005 and there should be no problems.
>
> J�rn