"Access2007" modifies the database password and queries the input SQL statement

Access is a non-stream database, the reason why he is not in the company because of its compatibility, size, etc. have not met the requirements of software operations,

But you also have to be aware that some projects require access as a database.

Access is a fully graphical operation of the database, the program Ape came out just to be very uncomfortable.

Because you don't know how to modify the database password-this is second, you can't find the part that gives you input SQL statement operation data.

After all, for the program ape, the ability to enter code to manipulate the computer is the most important.

First, modify the Access2007 database password

The upper-left corner has a button that opens the Access database, just as you open the. doc document in Word, and the Access database file has the suffix. mdb,

To get all of the database operations permissions on an Access database, you must open it exclusively, such as.

There must be a Cao here. Microsoft, for what security issues, incredibly default is a eunuch way to open

After opening, click "Database Tools" in the Upper tab bar and select "Revoke Database Password"/"Establish database Password" to

II. Input SQL statements

In the Upper tab bar, create, select query design, and a wizard dialog box pops up.

No need to look at, directly close can, who TM to your wizard, I just want to input SQL statements, ri!

Then the tab bar will automatically bounce to the "Design" tab, click the View button, directly select the SQL view, you can finally enter the SQL statement

Note, however, that this is a castrated j-sql statement, which is exactly the same as the T-SQL statement, the usual most standard SQL statement, but only the insert into,delete,select,update and the less significant procedure Body declaration statement. And it is not supported to execute multiple statements at once. Real Grass mud horse, what rotten database!

"Access2007" modifies the database password and queries the input SQL statement