Access 2013 with a VB Front End

[garethEds]

Hi Everyone,

 

I'm having an issue with connecting a VBE2010 front end application to an Access database. I can do it if I hard code the file path and gubbins into the code but I want the user to have different Access files for different academic years.

 

So does anyone know how to get VB to dynamically connect to the database instead of hard coding it or connecting through the VB GUI?

 

Does that makes sense?

 

Gareth