How to develop a program that supports both access and sql server databases.

nikejitui

It is possible to use different databases according to the configuration file

苹果小刀

The data layer can be done separately!
PetShop about Oracle and SQL SERVER

不大不小虾米

The answer is very simple. You first import the data in the access to SQL, and then do a good view

Then you can use your combined stuff in the view;

renalex

Set a variable to judge the connection between access and sqlserver (connect if sqlserver fails)

懒懒鱼

Equipped with two sets of SQL Command!

迷途精灵

You can use xml or database or text file to save your flag, mark which database to use, generally speaking, the initial setting should use access, there are places in the interface that allow users to modify the database connection, including allowing users to enter username and password And save after setting.
Choose different connection methods according to different settings when using

bme_acai

Configuration file interface Two sets of data logic

vagadog

The ones upstairs are mine.

讨饭猫

Try to use standard sql

nikejitui

Thank you very much.