how to get all tables by editing dsn file "data source file"
By having the next dsn file:
[ODBC]
DBQ=C:\\SLA.mdb
C:\\SLA.mdb
DefaultDir=C:\
Driver={Driver do Microsoft Access (*.mdb)}
DriverId = 25
FIL=MS Access
MaxBufferSize = 2048
MaxScanRows = 8
PageTimeout = 5
SafeTransactions = 0
Threads = 3
UserCommitSync = Yes
[Microsoft Office]
DefaultTable =开发者_运维百科table1
how could I edit it to have my other table "table2", be shown when Microsoft Query editor opened?
This should work for you:
[ODBC]
DRIVER=Microsoft Access Driver (*.mdb)
UID=admin
UserCommitSync=Yes
Threads=3
SafeTransactions=0
PageTimeout=5
MaxScanRows=8
MaxBufferSize=2048
FIL=MS Access
DriverId=25
DefaultDir=C:\
DBQ=C:\sla.mdb
However you can use a wizard to make these if you want to. Here is how:
- From the run box type in "odbcad32" and hit enter. (You can also get to this from Administrative Tools>Data Sources (ODBC)).
- Click the "File DSN" tab.
- Click the "Add Button"
- Select "Microsoft Access Driver".
- Click Next.
- Type in the path to where you want to save the DSN File (ex: C:\sla.dsn), or just click "Browse".
- Click next.
- Click Finish.
- Click the "Select" button.
- Select your Database and click "OK".
- Click "OK" one more time to close the prompts.
- DSN should now be ready to use.
精彩评论