Author Topic: Access NOOB - or what should I do?  (Read 2420 times)

0 Members and 1 Guest are viewing this topic.

Glenn R

  • Water Moccasin
  • Posts: 1932
  • What idiot child of married cousins wrote this?!
Re: Access NOOB - or what should I do?
« Reply #15 on: January 30, 2007, 07:01:39 PM »
Duh,

I've started using SQL Server 2005 Express (the free one) and it's fantastic. By default, it doesn't allow network connections, however if you download and install SQL Server Management Studio Express, it's a front end to allow configuration of the dbase as well as user access and accounts. Essentially the main difference between express and the full biccy is that express will not address a dbase greater than 4gb and it will only use 1 CPU in a multiple CPU machine. I've found the dbases I'm creating with severall hundred thousand entries is nowhere near the limits.

Have a search also on Microsoft for their webcasts - there is an excellent starter series there on using SQL Express and VB.NET and C# and I'm sure you could use VBA with OLEDB to get access to Express if you really wanted.

Hope this helps.

Cheers,
Glenn.
Me

Tuoni

  • Gator
  • Posts: 3031
  • A programmer in this life, once again!
Re: Access NOOB - or what should I do?
« Reply #16 on: January 31, 2007, 04:17:12 AM »
With ADO you can address an excel spreadsheet as though it was a database, using SQL.

You can output to a word document using VB(a) by adding the reference to MS Word and then using ObjWord.selection.typetext?

Kheilmann

  • Guest
Re: Access NOOB - or what should I do?
« Reply #17 on: February 02, 2007, 01:32:34 PM »

A great source for Access and SQL help is www.utteraccess.com