using multiple databases e.g. access, mysql

[donnacha]

Hi folks,

I have written a 3-tier VB application using MS Access, but would also like to be able to use other databases such as MYSQL or SQL Server without having to change my application.

 

Does anybody have an example of how this can be done without too much pain.

 

Thanks for any help

[Derek Stone]

Create different data access layers (DALs) that conform to one interface.

 

public interface IDataProvider {

   bool UserExists();

}

public class MySqlProvider : IDataProvider {

   public bool UserExists {

	

   }

}