[AccessD] Access and SQL Server

Jim Dettman jimdettman at verizon.net
Tue Mar 1 09:47:30 CST 2011


  Not sure if I posted this in the past, but there are some great tid-bits
in here on the use of an SQL backend:

http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

  Download "The best of both worlds..."

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, March 01, 2011 08:42 AM
To: Access Developers discussion and problem solving
Subject: Re: [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.
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list