Hard choice MSAccess or SQL

[Splater]

Hello,

I used some time ago to use an Acces data base with VB 6.0 and now I want to create a quite of agenda in VB .net 2005 and I saw these mdf data base.

Can someone tells me which data base would be better (access or this mdf), why and if it happens to be the mdf, please can you guide me with some links to tutorials ????

Thank you very much !!!
Splater

 

[zekeman]

Greetings Splater

This has been discussed here before as shown in the link below. Generally
I'd say go with the mdf because it's newer and therefore offers more
compatibility with the general sql world.

http://www.vbdotnetforums.com/showthread.php?t=18887&highlight=msaccess

 

[Splater]

Thanks for your answer !!!

I am not sure if it's possible to use this mdf but without installing a Mysql server, specialy when installing the release. So there is a way to use this mdf file like Msaccess only with the file ?

Splater

 

[zekeman]

Using/installing the server is not a big deal if you have admin priv., then use Visual Studio (VB I assume) Net ADO.Net to access the mdf. Getting the connection string is more difficult if you weren't the one that designed the database, however, once the server is installed, google the sqlcmd shell command to see how to list all databases that the server sees (and more).

Of course this all depends on other factors and in some cases, ms access my be better for some applications.

I hope this helps and please note that I'm still new to much of this.