使用 Windows Server 2008 和 IIS 7.5 实现 Access 2000 的 Internet 同步
我使用 Access2000 和开发工具、用于互联网同步的 JRO、RepMan 4，并使用 Win Server 2003（专用服务器）。刚刚升级到 Win Server 2008，并一直在尝试使 Internet 同步运行，但没有成功。我的问题是：我看到 MS 正在敦促/强制订阅 SharePoint2010 以实现互联网同步，但是我不确定他们的新平台对我来说是否和旧平台一样有用。我分发到的每个公司都将在多个位置运行我的访问应用程序的运行时版本（每个公司可能有 1 个位置，也可能有 100 个位置）。他们需要能够通过 LAN（2 到 20 台计算机）在每个位置直接同步。他们并不总是有互联网连接（他们在海上），即使有，也是通过卫星进行的，传输成本很高。因此，他们偶尔会连接一台计算机并执行互联网复制以将数据发送到家庭办公室（可能是每天、每周或每月）。我目前通过 JRO 进行同步的方法非常简单。获得互联网连接后，只需打开一个表单并单击“同步 LAN”按钮或“同步 Internet”按钮。此外，通过不使用自动同步，我们可以避免在一个副本损坏或用户无意中删除大量数据时损坏其他副本（因为删除总是获胜）。
我觉得最终我将不得不更新到 Access2010 只是为了跟上 MS 的新发展（即新的 .PDF 报告而不是 .SNP）。我最近购买了 Office 2010 Pro，以便开始研究这个问题，但这当然需要一些时间来解决。
我的问题如下：
SharePoint2010 是否只允许每个远程位置有一个订阅来处理返回到主办公室的同步，或者是否需要在远程办公室执行直接同步的每个副本都需要维护 Sharepoint2010 订阅？
我是否仍可以使用 JRO 来完成远程位置和家庭办公室内的副本之间的直接同步，因此仅使用 Sharepoint 2010 通过 Internet 将这些更新传递到家庭办公室。
Sharepoint 2010 Enterprise 是否允许我在一个中央帐户中托管多个公司数据库（类似于 RepMan4），还是必须为每个客户设置一个单独的帐户？如果是这样，我是否需要为每个客户购买一份 Sharepoint 2010 副本？
Sharepoint 2010 是否会以与我当前设置类似的方式处理基本数据复制和/或设计更新？我可以使用自定义冲突管理器吗？
此外，您是否知道 Internet 同步是否确实能够通过 Windows Server 2008 上的 IIS 7.5 利用 Access2000 和 RepMan4？我还没有找到任何人完成此操作 - 最新的建议是也许 IIS 需要在 32 位环境中运行才能打开同步器，但我还没有尝试过。
I am using Access2000 and Developer Tools, JRO for internet synch, RepMan 4, and was using Win Server 2003 (dedicated server). Just upgraded to Win Server 2008 and have been trying to get Internet synch operational, but with no luck. Here's my problem: I see that MS is urging/forcing subscriptions to SharePoint2010 for internet synchs, however I am not sure that their new platform is as useful to me as their old. Each company I distribute to will run a runtime version of my access application at multiple locations(could be 1 location per company, could be 100). They need to be able to direct synch within each location via LAN (anywhere from 2 to 20 computers). They do not always have an Internet connection (they are at sea), and when they do, it's by satellite and transmission costs are high. And so occasionally they will connect with one computer and perform Internet Replication to send data to home office(could be daily, weekly, or monthly). My current means of synching via JRO is very simple. After attaining an Internet connection, just open a form and either click the synch LAN button or the synch Internet button. Also, by not utilizing automatic synchs, we avoid corrupting other replicas when one is bad or a user has deleted massive amounts of data inadvertently (since deletes always win).
I feel that eventually I will have to update to Access2010 just to keep abreast on new developments in MS (i.e. new .PDF reports instead of .SNP). I recently purchased Office 2010 Pro in order to begin looking into this, but of course this will take some time to work thru.
Here are my questions:
Will SharePoint2010 allow for only one subscription per remote location to handle synchronization back to main office, or would every replica that performs a direct synch at the remote office be required to maintain a Sharepoint2010 subscription?
Can I still use JRO to complete direct synchs among replicas at a remote location and within the home office, and therefore only use Sharepoint 2010 to pass those updates via Internet to the home office.
Will Sharepoint 2010 Enterprise allow me to host multiple company databases in one central account (similar to RepMan4), or must I set up a separate account for each of my customers? If so, do I need to purchase a copy of Sharepoint 2010 for each of these customers?
Will Sharepoint 2010 handle basic data replication and/or design updates in a similar manner to my current set-up? Will I be able to utilize my custom conflict manager?
Also- do you have any info whether Internet synchronizations are indeed capable utilizing Access2000 viaIIS 7.5 on Windows Server 2008 with RepMan4? I have not found anyone who has accomplished this – latest suggestion is that maybe IIS needs to be run in a 32-bit environment in order to open the synchronizer, but I have not yet tried this.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我的公司生产了一款名为 [EQL OnWeb - 链接已删除] 的产品，该产品专为您的用例而设计。它可以在网络上获取 Access 2000 数据库，而无需先重写它们，并且有免费试用版，因此您可以看看是否喜欢它。
我不会详细评论 SharePoint 2010，因为显然我有偏见......但我更喜欢我们的产品:)
My company makes a product called [EQL OnWeb - link deleted] which is designed for exactly your use case. It works with getting Access 2000 databases on the web without rewriting them first, and there's a free trial so you can see if you like it.
I won't comment in detail on SharePoint 2010 because clearly I'm biased... but I like our product better :)