Search results

<< John in your experience what is the upper limit of MDB FE with ODBC links to SQL Server? (Is it ... 2 GB / 50 concurent users?) >> I can show you how to do 2GB and 50 concurrent users with an mdb back end! The upper limit is much higher with SQL Server, unless you're talking about the...

<< Can I get good performance (assume good client / server design) if all queries are built using the Access query grid and stored in the MDB? >> A qualified Yes. By "good client/server design" I assume you mean never opening a recordset on an entire table and always using indexed fields in...

I would have written the query: SELECT * FROM ciapp WHERE "4" BETWEEN ciapp.appfrom AND ciapp.appto; John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out SQL Queries for Mere Mortals...

Peter- << MDB with ODBC links is most likely a safer choice for the future. >> Yes. << I am assuming if I use MDB linked to SQL I can keep using DAO and don’t have to learn ADO? >> Well, it's a mixed bag. All form and report recordsets are DAO, but you should probably use ADO and the...

Peter- I would start with Microsoft Access Developer's Guide to SQL Server by Andy Baron and Mary Chipman. http://www.amazon.com/dp/0672319446?tag=viescaconsulinc Although written for Access 2000, it's chock-full of good advice that's still applicable. As I browse around on Amazon, SQL...

"By George, he's got it!" John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France)

Exactly. That's the whole point of my Building book. If you get it to run well using an mdb solution, it'll upsize painlessly to a true backend server should the need ever arise. Too many developers try to take a slow 5-user mdb application and upsize it with horrendous results. If it runs...

I agree, Bob. Microsoft now recommends using Access with linked tables to use Access as a front end to SQL Server. They've all but abandoned ADPs. John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out SQL...

<< If the filter / where criteria / query criteria (do they cause JET to act the same?) are on an indexed field(s) the file server returns only records that match the criteria? I wasn't quite sure what you mean by blocks John. >> By "blocks" I mean 2k or 4K pages from the file system. Yes...

ADPs are dead technology. The feature hasn't been updated since 2002, so they don't really support SQL Server 2005 and later. They can be handy for providing a GUI to manage table / SP / Function designs, but you'll get some annoying error messages (all bugs) if you use it with SQLS 2005 or...

Bob- A friend in the U.S. who monitors this forum sent me the link to the post, so I couldn't resist a response. John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out SQL Queries for Mere Mortals...

<< John preaches that we should always limit the underlying recordsourse of forms and combo boxes using filters. However since MDB is a file server does this make any difference? >> Absolutely! Note also that I recommend filters only on indexed fields. Even though Access is a desktop database...