How to activate Replica in Access 2010?
My microsoft access 2010 has replica option greyed (not active). How do I make it active so as to create replica?
- ColonelLv 68 years agoFavorite Answer
This section highlights new feature in Access 2010 that might be of more interest to IT administrators. For more information about new features, see Microsoft Access 2010 (http://go.microsoft.com/fwlink/?LinkId=1%E2%80%A6
Share a database on the Web
In Office Access 2007, there was limited support in sharing a database to the Web, where you could only publish your lists and move the database to document libraries. Now, in Access 2010, if you have access to Access Services in Microsoft SharePoint Server 2010, you can create a Web database by using Access 2010.
Export to .pdf and .xps
In Access 2010, you can export data to a .pdf file format (Portable Document Format) or an .xps file format (XML Paper Specification) to print, post, and distribute e-mail. In Office Access 2007 this capability was also available through a downloadable add-in.
You can now connect to a Web service as an external data source. You will need a Web service definition file provided by the Web service administrator. After you install the definition file, you can link to Web service data as a linked table.
The Microsoft Office Backstage is part of the Microsoft Office Fluent user interface (UI) and a companion feature to the ribbon.
This section summarizes some of the feature changes in Access 2010 that might be of more interest to IT administrators.
Backward compatibility between Access 2010 and Access 2007
Access 2010 introduces features that are not supported in Office Access 2007. Although Office Access 2007 SP1 will not open databases that contain these features, Office Access 2007 SP2 offers limited viewing and designing capabilities.
Enhanced security features and strong integration with Microsoft SharePoint Foundation 2010 help you more effectively manage data and allow you to make your information tracking applications more secure than before. By storing your tracking application data in lists on SharePoint Foundation 2010, you can audit revision history, recover deleted information, and set data access permissions.
Office Access 2007 introduced a new security model that is carried forward and improved in Access 2010. Unified trust decisions are integrated with the Microsoft Office Trust Center. Trusted locations make it easy to trust all databases in secure folders. You can load an Office Access 2007 application with code or macros that are disabled to provide a more secure, sandbox experience (that is, unsafe commands cannot be run). Trusted macros are run in Sandbox mode.
Support for SQL Server 2008 data types
Access 2010 provides limited support in Access projects (.adp) for the following seven new data types introduced in Microsoft SQL Server 2008: date, datetime2, datetimeoffset, time, geography, geometry, hierarchyID
The following three data types are unsupported when you use table or view design mode in Access 2010: geography, geometry, hierarchyID
The alternative is to use SQL Server 2008 design tools for creating tables, views, stored procedures, and functions when you use any of these three data types. You can still use Access 2010 to design reports, forms, modules and macros that reference these data types.
This section provides information about removed features in Access 2010 that might be of more interest to IT administrators.
Calendar control (mscal.ocx)
The Microsoft Calendar control (mscal.ocx) is not available in Access 2010. An alternative is to use the date picker control in Access 2010. Opening an application from an earlier version of Access where the control was used will generate an error message in Access 2010 and the control will not appear.
Microsoft Replication Conflict Viewer
The Microsoft Replication Conflict Viewer is not available in Access 2010. To achieve the same functionality, you can use the ReplicationConflictFunction property in a database replica set so that you can create a custom procedure to resolve synchronization conflicts.
Snapshot file format
The ability to export a report as a snapshot file is not available in Access 2010. Alternatives to the snapshot file format, in which file formats preserve the layout and formatting of the original report, are .pdf and .xps file formats.
Data access pages
Beginning with Office Access 2007, the ability to create, modify, or import data access pages was no longer supported. However, data access pages in an Office Access 2007 database would still function. By using Access 2010, you can open a database that includes data access pages.
Lotus 1-2-3, Paradox, Jet2.x, and Red2 IISAM
The IISAM (installable index sequential access method) for Lotus 1-2-3, Paradox, Jet2.x, and Red 2 is not available in Access 2010.
- Anonymous4 years ago
the Pirates are hoarding them eager about themselves and do not favor everybody else to purchase them! and the lady is clearly playing stupid, it truly is the in basic terms logical clarification to this!