How to connect with purticular databasefile (.mdb) while load the app c#?

[vmkrishna534]

Hi i am new to developing,deve loping a win form application with sq l server2005,in client system after install the application i created the folder for storing the database of running application,lik e that i have every year database separately,My doubt is how to connect the particular year database while loading the app?

please give me any idea?

[Rabbit]

You shouldn't have every year in a separate database. That severely denormalizes your data. Instead, they should be in one database with a field that indicates the year.