I want to be able to make my program flexible where it can connect to either
Access or SQL Server. As of now, I set my connection directly to an Access
mdb using the Access provider.

Can anyone tell me the best way to go about doing this or point me in the
right direction?

Thanks in advance,
Eric