Save Database Or Object In Different

Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.

Save Database Or Object In Different. To save a database. When saving to a save file only one library can be specified.

Improved Object Search Search For Objects In System Databases Sql Sqlserver Sql Escape Character System
Improved Object Search Search For Objects In System Databases Sql Sqlserver Sql Escape Character System from www.pinterest.com

Directly here I mean manual queries execution on database. You can browse to the specified object in the database using the object explorer. Command used to save the selected object with a different name.

The Get External Data - Access Database import and link wizard opens.

Sometimes manual query execution requires to perform some cross checks on the data or may be for reporting purpose in your case reporting may not make sense. The SaveObject action works on all database objects that the user can explicitly open and save. On the home page of the object explorer enter the object name and search. On the File tab click Save As.