[AccessD] Access and SQL Server

I have been doing it that way since Access 2000 first introduced ADP files.
I never passed through the ODBC stage, just went straight to ADPs SQL
Server. I've done a variety of apps this way. The biggest was an app for a
large travel agency/event system. Another significant one was for PCB
management facilities in Ontario; another was a typical Time/Billing app;
another was a safety assessment engineering app that's going nation-wide
(that is, Canada) now.

I'm so into that mode it never occurs to me to use Access as the Back End
any more. If it's on the small side, I'll use SQL Express instead of the
full-blown product.

Arthur

On Mon, Feb 28, 2011 at 7:56 AM, Tony Septav <iggy at nanaimo.ark.com> wrote:

> Hey All
> Thanks
> I have got to try out Stuart suggestion for updating stored procedures in
> SQL Server using ACCESS.
> I am not finding any significant differences in speed when using ACCESS
> tables  and queries versus SQL Server tables and pass through queries, I
> assume that is because I am doing my testing on my local machine and not on
> a network (or Web).
>
> Are any of your developing full blown ACCESS/SQL Server applications for
> clients?  If so what type of an app is it?
>