Tips for using. ADP files

Use Case :

originally: there are two access , A1 wrote the Program , all data linktable from A2 (A2 only used as a database ) .

now you want: A1 temporarily retained (the program is too complex ), set A2 Replace with sqlserver2005 .

problems and skills :

1:AccessImport dataSqlserver2005. Whether data types can be smoothly mapped; whether primary keys, auto-incrementing columns, and so on are correctly set.

2 : A1 Medium Linktable To Sqlserver Then, whether the program is normal. Because Access And Sqlserver The syntax is slightly different, such as a query statement of the date type.

 

Steps:

Pilot import data

1 : create a new access database.

2 : select the menu: file \ New \ select Project (existing data)

3:Datalink propertesInsideConnectionTab

SelectSQLServer:. \ Sqlexpress

SelectSQLDatabase Name

4: At this timeProjectProject, you can manageSqlserverDatabase.

The data table added here will be created directlySqlserver.

5: File\ Get external data \ Import

 SelectAccessFile(. Mdb)

Select the data table to import.

Note:: The data types have been converted during the import.

 

Below isLinktableToSQL ServerUpper

6: In the targetAccessProgram, file\ Get external data \ linktable

SelectODBCData Source

(If you want to create ODBC Data source, Control Panel \ Management tools \ ODBC Data Source \ Add one Sqlserver )

Select thisSQL Server, Select a table,Linktable

Note: : SQL The statement must be in Access . ( Access And SQL )

 

Conclusion: Normal