Kalau ngomongin server, tentu Windows Server, misalnya Windows 2003, Windows 2008. IIS tentu ada juga. Nah kalau ngomongin SQL Server, pastinya harus dipasang di Windows Server. Kalau pasang di desktop, itu MSDE dan Express namanya... :) SharePoint Server (SPS) juga software untuk server.
Haer On Tue, Jul 6, 2010 at 3:17 PM, jkssbma <[email protected]> wrote: > Apa tidak bisa dengan menggunakan Windows 7 sebagai Server Web ( > memanfaatkan IIS 7 ) ? > Sharepoint Server 2010 apa bisa di install pada Windows 7 ? > > Salam Sejahtera > > --- In [email protected], Haer Talib <haerta...@...> wrote: > > > > Yang menarik tentu Access Services-nya ya? :) > > Aplikasi yang dibuat dengan Access bisa diakses via web browser. > > Tapi ini mainan server sebenarnya. > > Access Services merupakan service baru di Sharepoint Server 2010. > > Nah kudu install itu, jadi syarat di bawahnya ya kudu pakai Windows > Server, > > SQL Server, baru Sharepoint Server yang dipasangi Access Services. > > Aplikasinya sendiri ga bisa langsung migrate dari yang sudah existing, > > karena beda. > > > > hayo, pada belajar lagi... belajar lagi... :) > > > > Haer > > > > > > On Fri, Jul 2, 2010 at 4:13 PM, privat access <les.acc...@...> wrote: > > > > > > > > > > > hhmmm.. blm tau juga nih.. msh perlu searching lg.. > > > > > > > > > 2010/7/2 Muntahar <eyoun...@...> > > > > > > > > >> > > >> Tapi infrastrukturnya lumayan mahal ya ..... > > >> > > >> > > >> On Fri, Jul 2, 2010 at 3:30 PM, privat access <les.acc...@...>wrote: > > >> > > >>> > > >>> > > >>> yeahhhh.. tepat sekali kang muntahar.. access 2010 sptnya benar2 > sangat > > >>> menjanjikan... kayaknya perlu dikupas tuntas oleh ybs tuh di kopdar > > >>> berikutnya... > > >>> > > >>> berikut kutipan/sekilas access 2010 dari url : > > >>> http://technet.microsoft.com/en-us/library/cc179181.aspx dan > perintah > > >>> macro apa saja yg compatible atau tidak utk mensupport access 2010, > silahkan > > >>> lihat di : > > >>> > file:///D:/Downloads/web-compatibility-check-macro-errors-HA010386888.aspx.htm > > >>> > > >>> salam, > > >>> Lusky Kurniawan > > >>> > > >>> solusiaccess.com > > >>> (021) 9293 1925 > > >>> > > >>> > > >>> Changes in Access 2010 > > >>> > > >>> Published: May 12, 2010 > > >>> > > >>> This article lists changes in Microsoft Access 2010 since Microsoft > > >>> Office Access 2007 and migration considerations. If you are upgrading > from > > >>> Microsoft Office Access 2003, see also Changes in Access 2007 ( > > >>> http://go.microsoft.com/fwlink/?LinkId=164065) and Migration > > >>> considerations for Access 2007 ( > > >>> http://go.microsoft.com/fwlink/?LinkId=164070). > > >>> > > >>> In this article: > > >>> > > >>> What's new > > >>> > > >>> What's changed > > >>> > > >>> What's removed > > >>> > > >>> Migration considerations > > >>> > > >>> What's new > > >>> > > >>> 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=182564 > ). > > >>> > > >>> *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. Users can use your database in a Web browser > window, > > >>> but you must use Access 2010 to make design changes. Although some > desktop > > >>> database features do not translate to the Web, you can do many of the > same > > >>> things by using new features, such as calculated fields and data > macros. > > >>> * > > >>> 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. Beginning with Office Access > 2007 > > >>> SP2 and continued with Access 2010, this feature was built into the > product > > >>> so you do not need to install any additional software. Exporting a > form, > > >>> report, or datasheet to a .pdf file or an .xps file lets you capture > > >>> information in an easy-to-distribute form that retains all the > formatting > > >>> characteristics, but does not require other users to install Access > on their > > >>> computers to print or review your output. > > >>> > > >>> *Connect to a Web service as an external data source* > > >>> > > >>> 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. > > >>> > > >>> *Backstage view* > > >>> > > >>> The Microsoft Office Backstage is part of the Microsoft Office Fluent > > >>> user interface (UI) and a companion feature to the ribbon. The > Backstage > > >>> view, which can be accessed from the File tab, contains commands that > you > > >>> apply to an entire database, such as compact and repair, or open a > new > > >>> database. (The File tab replaces the Microsoft Office Button and File > menu > > >>> that were used in earlier releases of Microsoft Office.) Commands are > > >>> arranged on tabs on the left side of the screen, and each tab > contains a > > >>> group of related commands or links. For example, if you click New, > you see a > > >>> set of buttons that let you create a new database from scratch, or > you can > > >>> select from a library of professionally designed database templates. > > >>> > > >>> *What's changed* > > >>> > > >>> 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* > > >>> > > >>> 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. > > >>> > > >>> *What's removed* > > >>> > > >>> 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. > For more > > >>> information, see How to Use the ReplicationConflictFunction Property > ( > > >>> http://go.microsoft.com/fwlink/?LinkId=165394). > > >>> > > >>> *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. > However, the > > >>> data access pages will not function. When you attempt to open a data > access > > >>> page, you will receive an error message that states that Microsoft > Office > > >>> Access does not support this operation for Data Access Pages. > > >>> > > >>> An alternative to using data access pages is to create a Web database > and > > >>> publish to a SharePoint site by using Access Services. For more > information, > > >>> see What's new for Access Services in SharePoint Server 2010 ( > > >>> http://go.microsoft.com/fwlink/?LinkId=182566). > > >>> > > >>> *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. If you > need to > > >>> link to, import from, or export to one of these IISAMs, you can use > Office > > >>> Access 2007 or earlier. When you attempt to create a link to, import > from, > > >>> or export to a Jet 2.x or Red 2 database, and when you select or > paste a > > >>> linked table to Lotus 1-2-3 or Paradox, you might receive one of the > > >>> following error messages: > > >>> > > >>> *Could not find installable ISAM.* > > >>> > > >>> Microsoft Office Access does not support this operation for this > IISAM > > >>> type. To perform this operation, use Microsoft Office Access 2007 or > > >>> earlier. > > >>> > > >>> *Migration considerations* > > >>> > > >>> When you plan a migration to Access 2010, review what is new, > changed, > > >>> and removed for Access 2010. Because Access 2010 has many > similarities with > > >>> Office Access 2007, such as the same native file format, you can also > review > > >>> and use the existing migration documentation for Office Access 2007 > when you > > >>> migrate to Access 2010. > > >>> > > >>> *VBA settings migration* > > >>> > > >>> In Office 2010, Visual Basic for Applications (VBA) 6.0 was updated > to > > >>> VBA 7.0. VBA 7.0 settings were reset to their defaults after > migration > > >>> instead of automatically repopulating. This occurred because the > registry > > >>> settings for VBA are in a different hive in Office 2010, as shown in > the > > >>> following table. > > >>> > > >>> *Version Registry subkey > > >>> ** > > >>> Office 2000 through Office 2007* > > >>> > > >>> HKEY_CURRENT_USER\SOFTWARE\Microsoft\VBA\6.0\Common > > >>> > > >>> *Office 2010* > > >>> > > >>> HKEY_CURRENT_USER\SOFTWARE\Microsoft\VBA\7.0\Common > > >>> > > >>> To correct this problem, copy the VBA 6.0 registry keys from the 6.0 > hive > > >>> to the 7.0 hive. > > >>> > > >>> > > >>> > > >>> > > >>> > > >>> > > >>> > > >>> Pada 2 Juli 2010 14:45, Muntahar <eyoun...@...> menulis: > > >>> > > >>> > > > >>> > > > >>> > > > >>> > kayaknya menjanjikan, > > >>> > btw, kira-kira > > >>> > kalo mau membuat server Access 2010 ontheweb untuk intranet > > >>> > butuh hardware n software pa ajah yah ? > > >>> > > > >>> > 2010/7/2 privat access <les.acc...@...> > > >>> >> > > >>> >> > > >>> >> [Attachment(s) from privat access included below] > > >>> >> > > >>> >> Dear Accesser, > > >>> >> > > >>> >> Ayooo tetap semangat.. nikmati petualangan baru Access 2010 on the > > >>> web... > > >>> >> > > >>> >> salam, > > >>> >> > > >>> >> Lusky Kurniawan > > >>> >> www.solusiaccess.com > > >>> >> (021) 9293 1925 > > >>> > > > >>> > > > >>> > > > >>> > -- > > >>> > --------------------------------------------- > > >>> > grapyak-semanak-cluthak > > >>> > http://djmumun.wordpress.com > > >>> > http://facebook.com/djmumun > > >>> > --------------------------------------------- > > >>> > > > >>> > > >> > > >> > > >> > > >> -- > > >> --------------------------------------------- > > >> grapyak-semanak-cluthak > > >> http://djmumun.wordpress.com > > >> http://facebook.com/djmumun > > >> --------------------------------------------- > > >> > > > > > > > > > > > > > > > > > > > > > > > -- > > > > Jadikan www.gapura.web.id sebagai homepage browser anda. > > => Akses ke website favorit tinggal klik aja. (Lihat dulu deh). > > > > > > > ------------------------------------ > > SPAM IS PROHIBITEDYahoo! Groups Links > > > > -- Jadikan www.gapura.web.id sebagai homepage browser anda. => Akses ke website favorit tinggal klik aja. (Lihat dulu deh).

