[AccessD] Access and SQL Server

My advice for small databases is to simply upsize your big mac and be done with it.  Oh... that's my 
McDonalds order.

Upsize your tables to SQL Server and be done with it.  Easier said than done in some cases, quite 
trivial in others.

My point really is that for *small* databases (back ends), simple ODBC links to the data sitting in 
SQL Server will get you there instantly.  Then you can play around with more esoteric things like 
binding the forms and combos to pass through queries and the like - assuming > A2K of course.

The bigger problem I found was understanding enough about SQL Server security to make the process 
painless.

John W. Colby
www.ColbyConsulting.com

On 2/28/2011 1:09 PM, Tony Septav wrote:
> Hey All
> Thank you all again, I am quickly learning many things from your responses.
> I am just an old fart trying to play catch up with you guys (Oops and gals).
> I am trying to learn how to do things with a SQL Server back end, by trying to duplicate what I can
> do with an old MDB back end application. I am finding at times when doing my research on the
> Internet that I will read "Do it this way" and then next read "No don't do it that way do it this
> way". Also when I complete one task I think "Now how can I do this slighty different", this becomes
> quite frustrating, after 2 to 3 hours of reading other forum responses and basically finding no
> "hits", I will find some esoteric little example, usually not on topic, that finally simply
> describes how to do what I was looking for.
> Anyway this is my problem to solve, thank you again for your all your help. Onward and upward. This
> is a scary path.
>