4) 取决于 ERP 系统,如果它有附加的 Web 服务或某种 API,那么这是可能的。作为一个真正更糟糕的情况,你甚至可以做一些自动按钮按下,但我不会推荐它!
5) 抱歉,我不知道是否还有更多示例数据库,但 Northwind 是一个很好的学习工具,
如果您需要更多详细信息,请告诉我
To answer yours questions
1) Once you link the tables they will work almost exactly like a local table so you can make queries on them etc. There are some restrictions on access them through DAO code but that’s easy to get round if you need to
2) If its is a number only and not shown to the end user then use an autonumber field, that will give you a 32bit number to play with
3) Nope, anything you do in the full fat version of access will be able to be run on the runtime version so no worries there
4) Depends on the ERP system, if it has a web service attached to it or some kind of API then it would be possible. As a real worse case you could even do some automated button pressing but I would not recommend it!
5) Sorry I don’t know if any more example databases but the northwind one is a good learning tool
发布评论
评论(1)
回答你的问题
1)一旦你链接了这些表,它们的工作方式几乎就像本地表一样,因此你可以对它们进行查询等。通过 DAO 代码访问它们有一些限制,但如果你需要
2, 这很容易绕过) 如果它只是一个数字并且不向最终用户显示,则使用自动编号字段,这将为您提供一个 32 位数字供您使用
3) 不,您在完整版本的 access 中执行的任何操作都将能够运行在运行时版本上所以不用担心
4) 取决于 ERP 系统,如果它有附加的 Web 服务或某种 API,那么这是可能的。作为一个真正更糟糕的情况,你甚至可以做一些自动按钮按下,但我不会推荐它!
5) 抱歉,我不知道是否还有更多示例数据库,但 Northwind 是一个很好的学习工具,
如果您需要更多详细信息,请告诉我
To answer yours questions
1) Once you link the tables they will work almost exactly like a local table so you can make queries on them etc. There are some restrictions on access them through DAO code but that’s easy to get round if you need to
2) If its is a number only and not shown to the end user then use an autonumber field, that will give you a 32bit number to play with
3) Nope, anything you do in the full fat version of access will be able to be run on the runtime version so no worries there
4) Depends on the ERP system, if it has a web service attached to it or some kind of API then it would be possible. As a real worse case you could even do some automated button pressing but I would not recommend it!
5) Sorry I don’t know if any more example databases but the northwind one is a good learning tool
Let me know if you need any more detail