Database Dilemma

[zrenzi]

Hello,
I am reaching out for advice on which database to use for my home computer. I am a software engineer and I am currently using MS Access 2002 at work. Most of the interfaces I have wirtten in VB.Net 2005 deal with manipulating Access databases.
My new computer will have Windows Vista Home Premium. I was just wondering if it is worth buying MS Access or if there was a cheaper solution. Also, I was wondering if any of my code will have to be updated even if i do go with Access 2007. It looks like the database files have a different file extention.
Any insight would be most helpful. Thanks in advance


Zak

 

[cjard]

AFAIWA, access only works with vista 32 bit.. ?

Do yourself a professional favour, dump access and get on with learning SQL Server, or Oracle - both exist in free versions and make you a lot more attractive to employers.,

 

[JuggaloBrotha]

for home use programs, Access still has lots of potential and programming for Access is still really easy.

zrenzi, unless you have a reason to not get Access 2007 I would recommend getting Access 2007.

I have been hearing an awful lot about VistaDB being really good too, though I haven't used it yet (my work uses Access 2003, and I use Access 2003 at home too)

 

[HeavenCore]

I agree with CJard, i run sqlExpress on my home machine, just attatch whatever database i am working on, and its that simple, fully integrated with Visual Studio and stuff, seriously worth looking at m8.

As for Vista concerns, just install the latest service packs and it works fine.

 

[zrenzi]

Thanks to all for the replies. It is appreciated.