Access front-end query design view with backend SQL server

[Lifeseeker]

Hi there,

I am hoping to have this Access 2003 front-end linked up to a SQL server which stores the back-end table.

What I am wondering and I really hope it works this way is.......if users can access the standard query grid through Access front-end with the tables now stored on the back-end on the server.

Will users still be able to use the query grid to do query as they normally would in Access 2003's query design view?

I am new in this arena, and am hoping that I can get some input from experts.

Thank you

 

[pbaldy]

If the tables are linked, sure (though I never let users into tables or queries directly).

 

[MSAccessRookie]

As Paul points out, if all of the SQL Server Tables are linked, then there should be almost no difference to the user at all. As far as users accessing the Query Design View, there should also be no problem with that either.

I have worked in environments where power users requested the right to create their own Ad-Hoc Queries, and management approved. I have never been in the position of telling people what they can and cannot do, so I have always reminded them of the potential issues that could arise, but never formally objected. That way, the senior users were left satisfied, I was eventually left with the tasks related to retooling the Ad-Hoc Queries, and converting them to production level.

 

[Lifeseeker]

As Paul points out, if all of the SQL Server Tables are linked, then there should be almost no difference to the user at all. As far as users accessing the Query Design View, there should also be no problem with that either.

I have worked in environments where power users requested the right to create their own Ad-Hoc Queries, and management approved. I have never been in the position of telling people what they can and cannot do, so I have always reminded them of the potential issues that could arise, but never formally objected. That way, the senior users were left satisfied, I was eventually left with the tasks related to retooling the Ad-Hoc Queries, and converting them to production level.

Thank you.

By the way, what are ad-hoc queries?

Queries that users would like to do on the fly?

 

[MSAccessRookie]

Ad Hoc refers to an On Demand Style of Query that may or may not be reusable. When Queries turn out to be reusable, there is often an opportunity for you to integrate them into the application. Even when Queries are not reusable, they can still allow users access to information that the normal system might not provide.