ChicagoPete wrote:
So my company just bought another company and they send me a flat text file
with 1.5 million records of customer name/orders/transactions etc - all in
one huge txt file. Just for fun... I imported this into Access 2007 and you
can view the single table, can't do anything with it, a simple parameter
search on one customer name locks up the server, Access not responding, white
screen blah, blah blah...

Pete,
One option when you have huge data files is to use SQL Server Express for the
back end, because it can handle up to (I think) 4GB in the free version.
Then you can create queries etc in the Access DB. Looks like you're directly
in Access, but the data is just in a different back end. If you index
properly on both sides, it's seamless. You get the simple GUI of Access and
the storage of SQL Server. You can also buy SQL Server Developer for
ridiculously cheap. Read about it here...

http://www.microsoft.com/sqlserver/2...developer.aspx

http://www.amazon.com/gp/search/ref=...qid=1271526398


For learning SQL Server, it's a STEAL.

Mary Chipman & Andy Baron wrote a book on using Access as a FE to SQL Server..
.. it's old but I think still relevant. You can get it for maybe 15 bucks at
Amazon.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201004/1