Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
remote connetion to Access
- Thread starter RTornberg
- Start date
DAO (from Access Help):
The TransferDatabase method carries out the TransferDatabase action in Visual Basic. For more information on how the action and its arguments work, see the action topic.
Syntax
DoCmd.TransferDatabase [transfertype], databasetype, databasename[, objecttype], source, destination[, structureonly][, saveloginid]
e.g.:
DoCmd.TransferDatabase acLink, "Microsoft Access", _
"\\eur-fps\teams\FolderMain\DBMain.mdb", acTable, "MyTable", "MyTable"
or
const ServNameStr = "\\eur-fps\teams"
DoCmd.TransferDatabase acLink, "Microsoft Access", _
ServNameStr & "\FolderMain\DBMain.mdb", acTable, "MyTable", "MyTable"
The TransferDatabase method carries out the TransferDatabase action in Visual Basic. For more information on how the action and its arguments work, see the action topic.
Syntax
DoCmd.TransferDatabase [transfertype], databasetype, databasename[, objecttype], source, destination[, structureonly][, saveloginid]
e.g.:
DoCmd.TransferDatabase acLink, "Microsoft Access", _
"\\eur-fps\teams\FolderMain\DBMain.mdb", acTable, "MyTable", "MyTable"
or
const ServNameStr = "\\eur-fps\teams"
DoCmd.TransferDatabase acLink, "Microsoft Access", _
ServNameStr & "\FolderMain\DBMain.mdb", acTable, "MyTable", "MyTable"
- Status
