访问数据库记录到Web服务 [英] access database records to web service

问题描述

嗨

我有一个用于管理员工休假的访问数据库（2007）。我想将它连接到我们的网络服务并发送记录并从网络服务获得回复。

任何人都可以建议或指导我如何实现这一目标。

Hi
I have an access database (2007) for managing staff leave. I would like to connect it to our web service and send the records and get response from the web service back.
Can anyone suggest or guide me how to achieve this.

推荐答案

根据您的具体情况，这很难做到。

一旦完成所有工作，您将不得不与IT部门密切合作。


请使用字节徽标旁边的搜索（或橙色放大镜左侧）：
访问zmbd web数据库


再次
访问zmbd发布


和此链接：
http://bytes.com/topic/访问/ insigh ... ccess-data-web 保持心态：数据访问页面支持自ACC2010起已经过折旧，并在ACC2013中完全删除。

http://bytes.com/topic/access/answer...atabase-online 就是这个进展的地方。

This is very difficult to do depending on your situation.
You will have to work very closely with your IT department once you have everything in place.

Please use the search next to the bytes logo (or just to the left of the orange magnifying glass):
access zmbd web database

and again
access zmbd publish

and this link:
http://bytes.com/topic/access/insigh...ccess-data-web KEEP IN MIND: Data access pages support has been depreciated as of ACC2010 and completely removed in ACC2013.

http://bytes.com/topic/access/answer...atabase-online is where this has progressed.

亲爱的zmbd

感谢您的回复。我将提供Web服务以及与Web相关的其他要求。我想知道从ACCESS生成记录集后如何将其传输到Web服务。什么是最简单的方法？是否有任何VB代码可以将这些记录从ACCESS传输到Web应用程序？

基本上，ACCESS中的数据是工作人员休假，我们需要将这些记录传输到Web服务并进行更新。希望我已经解释过我的问题。请指导我

Dear zmbd
Thank you for the reply.My IT will be providing the web service and other requirements related to the web. I like to know that after generating my recordset from ACCESS how can I transfer that to the web service. What is the easiest way? Is there any VB code can do this transfer of records from ACCESS to the web application?
Basically the data in ACCESS is staff leave and we need to transfer those records to the web service and update. Hope I have explained about my issue. Please guide me

我会选择混合共享点


我的意思是你的大部分实际工作都由Access程序。您设计了一些非常基本的表单和表来处理Share-Point服务器中的列表。


这就是我所做的。

1 ）从界面的共享点决定我真正需要的东西...用最简单的术语


2）使用网络数据库模板（ACC2010，我''我没有使用ACC2007，所以我猜这是相同的）并开发了我能做的最基本的表格和表格。

2a）（我们在网站上有一个人主要处理共享点开发。通常，我可以简单地设计具有我需要的外观和感觉的前端，并且他可以从Share-Point开发人员那里进行相当多的翻译，我只需要在完成后链接到列表）。


3）开始开发我的正常具有拆分后端的数据库，然后添加到共享点表的链接。


在链接表之间移动数据与任何其他数据移动没有什么不同。

在Access和SharePoint站点之间集成数据的简介


这是针对ACC2010的，其中一些可能不适用于ACC2007但您也应该了解这一点：在SharePoint 2010上编辑或发布Web数据库（请注意适用于ACC2013标记，这是此页面的最新更改，因此我怀疑这将是也适用于ACC2013）


要记住的事项：

- 为Share-Point开发的表格和报告不支持VBA并且仅支持非常有限的Access Macro语言集。

- Share-Point不支持表关系。解决方法是使用最讨厌的查找字段向导并在表级创建查找字段。

（我尽量避免这种情况;但是，它通常不能要避免）


其他一些事情：


共享Access数据库的方式（ACC2007）

将数据库发布到SharePoint站点（ACC2007）


最后：

不要使用较旧的MDB文件格式尝试解决数据访问页面的删除问题（url = http://office.microsoft.com/en-us/access-help/what-happened-to-data-access-pages-HA010030832.aspx ]数据访问页面发生了什么[/ url]

ACC2007 / ACC2010没有有效的支持，它们甚至无法使用在没有重大黑客的情况下在ACC2013中打开。

I would go with a hybrid share-point

What I mean by that is that most of your actual work is handled by the Access program. You Design a few very basic forms and tables to handle the Lists within the Share-Point server.

This is what I''ve done.
1) Decided on what I really needed from the share-point side of the interface... in the most simplistic terms

2) Used the web-database template (ACC2010, I''ve not used ACC2007 so I''m guessing that this is fairly much the same) and developed the most basic forms and tables that I could.
2a)(We have a person on site that mainly handles Share-Point development. Often, I can simply design the front-end with the look and feel that I need and he can translate this fairly much from the Share-Point developer''s side and I need only link into the lists once done).

3) Started development of my "Normal" database with a split back-end and then add links to the share-point tables.

Moving data between the linked tables is no different than any other data movement.

Introduction to integrating data between Access and a SharePoint site

This is for ACC2010 and some of this may not be available in ACC2007 but you should know about this too: Edit or publish a web database on SharePoint 2010 (note the applies to ACC2013 tag, that''s a recent change to this page so I suspect this will also apply in ACC2013)

Things to keep in mind:
- Forms and reports that are developed for Share-Point do not support VBA and support only a very limited set of the Access Macro language.
- Share-Point does not support table relationships. The work-around is to use the most hated look-up-field wizard and create look-up fields at the table level.
(I try to avoid this; however, it often can''t be avoided)

Some other things:

Ways to share an Access database (ACC2007)

Publish a database to a SharePoint site (ACC2007)

Finally:
Do not use the older MDB file format to try and workaround the removal of Data Access Pages (url=http://office.microsoft.com/en-us/access-help/what-happened-to-data-access-pages-HA010030832.aspx]What Happened to Data Access Pages[/url]
There is no effective support in ACC2007/ACC2010 and they cannot even be opened in ACC2013 without a major hack.

这篇关于访问数据库记录到Web服务的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！