Access 2003 and SQL Server 2005

[Guest]

I know this issue has been posted a number of times, but I haven't seen any
work around solutions. Perhaps there just isn't any, but if anyone has any
suggestions, here's the issue:

Our office has a number of users who use Access 2003 ADPs to create/modify
views and reports on tables contained in SQL Server. We recently upgraded to
SQL Server 2005, and it appears that APDs can no longer be user to
create/modify views in SQL Server.

How can I continue to provide to our users the ability to create/modify
views and build reports on data in SQL Server 2005 using Access as a front
end? Do I have to convert to MDB's and use linked tables? If so does this
mean that any views users create cannot be stored in SQL Server?

It looks like I'm screwed here, so any suggestions are welcome.

Thanks.

 

[Robert Morley]

It's an unusual case that database users are allowed to create their own
views, so you probably won't find much. About the only thing I can think
of--and I somehow doubt it was what you were looking for--would be to create
your own query designer (even a simple one wouldn't be an easy task) which
would then send the appropriate commands to SQL 2005 to create the view.
Doesn't that sound like fun?


Rob

 

[Robert Morley]

Oh, and of course, there's the obvious...give them all SQL Enterprise
Manager (or whatever they've called it in 2005...I have no first-hand
experience yet).



Rob

 

[Brendan Reynolds]

There's always "Microsoft SQL Server 2005 Express Edition with Advanced
Services". Whew, what a mouthful! But it's pretty cool - SQL Server 2005
Express Edition with SQL Server Management Studio Express (replaces
Enterprise Manager and Query Analyzer) and Reporting Services - and its all
free.

http://www.microsoft.com/downloads/details.aspx?FamilyID=4c6ba9fd-319a-4887-bc75-3b02b5e48a40