Access
ss . Access, , SQL Server. .
. , , . , , . ., Access.
. Access, SQL Server . , . , . Access , . ( , , .)
Access .
. Access. ( .) Access adp.
19. , Access.
SQL Server Access? , Access, 19.
, . , , . , Access SQL Server .
( , , ). , , . , SQL Server, , Access.
. " SQL Server" . , SQL Server.
Access , , . accdb , Windows.
|
|
SQL Server . , , . , , . , SQL Server , . , , .
, , , SQL Server, . . . SQL Server Management Studio (. . 20.2), . (, , , SQL Server , .) Access. Office → Server (Office → ) ( Server () , Access).
.
■ Connection (). Data Link Properties ( ), Access. SQL Server. , - SQL Server , , . , .
Access , "Disconnected" (" "), Access . , Office → Server → Connection (Office → → ) .
■ Server Properties ( ). , , (SQL Server), ( SQL Server 2005 9), . .
■ Link Tables ( ). Access. , ( ). , , Access.
■ Back Up SQL Database ( ). SQL Server dat, ( ). SQL Server , , SQL Server Agent ( SQL Server).
■ Restore SQL Database ( Microsoft SQL Server ). dat, Office →Server → Back Up SQL Database (Office → → ), SQL Server.
|
|
■ Transfer Database... ( ...). . ( SQL Server.) Access , , .
■ , SQL Server , .
■ Copy Database File... ( ...). SQL Server , , . ( SQL Server , .) Office → Server → Transfer Database... (Office → → ...), .
■ Drop SQL Database ( SQL Server). SQL Server .
■ Set Logon Password ( ). , SQL Server.