Access 2003 and SQL Server 2005

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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? :P


Rob
 
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
 
Back
Top