Creating databases from VB2005 Express or VB2005

12 Dec 2006 11:08 AM

max

Hi all,
I'm new in this great NG, so forgive me if my questions seem funny or
tedious. I have also already searched old messages, but I can't get the
answers I'm really looking for.
I need to write an application which uses a db, just a simple db with some
queries and reports. I know VB implements sql express, I tried to make
something, but, for beginners, working with sql it's not so simple. More, I
seem to understand that sql express doesn't support reports. Or maybe is
VBExpress that has this limitation...
I was wondering if working with VBExpress to develop an Access db is quite
simpler. But I don't know if it would be possible and how.
Can you give me any info about it, how to start, and some link/books to
study for my starting point?
I'm sorry for these very annoying questions, but I'm a really beginner in
db's. And sorry for my english.
Thanks!
Max

12 Dec 2006 12:53 PM

BK

Welcome to the NG.

Sql Express works easy enough as does Access. We install Sql Server
tools which gives you the option of installing a local Sql Server
(MSDE?) that works well. We also use MySql since it's easy to setup
and maintain.

Reports are separate from the database, you should be able to create
Crystal reports that use data from just about any data source.

As for books, there are plenty out there and I'm sure someone will
throw a few names out for you.

Hope this helps

12 Dec 2006 8:03 PM

Miro

Ive created a vb.net prog that creates an access table thru code.

There isnt much out there in books on this anymore. I used the ADOX .com
dll.

Let me know if thats what you are looking for and Ill see if i can find the
link / code of what you need. -send me an email.
Im a beginner too, and I used it as a good learning experience to remember
some "old" and use it with the "new".

Miro

Show quoteHide quote

"max" <m**@max.max> wrote in message
news:h5wfh.21914$P04.7834@tornado.fastwebnet.it...
>
> Hi all,
> I'm new in this great NG, so forgive me if my questions seem funny or
> tedious. I have also already searched old messages, but I can't get the
> answers I'm really looking for.
> I need to write an application which uses a db, just a simple db with some
> queries and reports. I know VB implements sql express, I tried to make
> something, but, for beginners, working with sql it's not so simple. More,
> I seem to understand that sql express doesn't support reports. Or maybe is
> VBExpress that has this limitation...
> I was wondering if working with VBExpress to develop an Access db is quite
> simpler. But I don't know if it would be possible and how.
> Can you give me any info about it, how to start, and some link/books to
> study for my starting point?
> I'm sorry for these very annoying questions, but I'm a really beginner in
> db's. And sorry for my english.
> Thanks!
> Max
>
>