I have a set of source code, how can I tell if it is sql or access?

Just look at the database connection string in the file and you'll be able to tell it.

If access can be written like this, there are other ways to do so.

dim oconn,strconn

set oconn=

strconn= "driver=;" &uid=adminaccount;" &

pwd=password;"

strconn

SQL can be written like this:

dim oconn,strconn

set oconn=

strconn="driver=;" &

server=myservername;" &database=mydatabasename;" &uid=myusername;" &

pwd=mypassword;"

strconn

It's access, you can look for this file, which has the specified database name.

To see if you can see the source program, you can analyze it through its specific SQL statements.

See how the program connects to the database.

Enter an incorrect numeric ID and let the program report an error from the error message Whether it's access or mssql

It's simple, figure it out for yourself haha.

What do you want to view with Tu Qingsen?

If it is access, click the file in double positive, and then double-click the table name;

Access does not have a query analyzer for sqlserver, but you can go to a "access query analyzer", which is similar to the function of sqlserver query analyzer;

If you use a third-party development language to query access, it depends on the type of development language.

You use IIS to run it to see if each page can run and whether the function can be realized, if you don't do any configuration, you can use most of them are access.

See the generated suffix if yes. MDB is access.

Generally, just look at the connection string and find the connection string! The connection string is different for different databases.

Usually MySQL databases will have this syntax [MySQL Connect(.]'localhost','Username','Password'Or something like that!

You tried. If you can't open it with access, it's not access.。。 It's something else. Ha ha.

There's no conflict between these two things, right? It depends on how you use it, if you have installed it, which one you want to use, you can use which import is over

It depends on what you're going to use it for.,If it's going to be for commercial use.,It's recommended that you don't transfer.,But if you're handing in homework or other demonstration use.,It's okay to convert it to access.,Because it's better to use the ** made with access.,You don't need to adjust any settings to use it.。 There is also the fact that it is actually very simple to turn up, just right-click to export the data, and then just follow the prompts to set it.