sql server 2008 - 'Upsizing Wizard cannot be run with any database objects open' -
i error when try link table sql server, error if try click button when no table open.
i want create form simple data entry sql table. haven't been able find simple gudies task, guides can give appreciated.
here example copied directly access' topic transferdatabase method. assumes dsn (data source name) called "datasource1" available , points desired external database.
docmd.transferdatabase aclink, "odbc database", _ "odbc;dsn=datasource1;uid=user2;pwd=www;language=us_english;" _ & "database=pubs", actable, "authors", "dboauthors" unfortunately i'm not sure you're attempting do. if goal export existing access table odbc database, use acexport transfer type transferdatabase method.
actually, if one-time operation want import/export/link between access , odbc database, seems easier , faster use import/export options ribbon. no programming required.
Comments
Post a Comment