交易表？ [英] Transactions Tables?

问题描述

我希望之前有人这样做过。

我在MySql中有一个数据库，很多成员都可以通过PHP访问。


但是，更新此数据库的新人没有学习任何新东西的动力或愿望。


我想要做的是构建一个访问数据库，在那里他在熟悉的环境（访问）中进行更改，并向我发送一个表格，其中包含他所做的所有更改，但只有他所做的改变。


我目前的托管计划使得难以链接表格，因此离线更新是最好的选择。另外，他们只支持MySQL和PostGres。


我可以使用Access构建交易表供我接收吗？ （具有记录号的表，字段的名称已更改，新值就足够了）。 {167，Home_Address，155 North 5th Street}


或者这里的任何人都可以想到更简单的东西吗？


我可能真的在这里忽略了简单的解决方案。

I''m hoping someone has done this before.
I have a database in MySql that many members access via PHP.

However, the new person to update this database does not have the drive or desire to learn anything new.

What I would like to do is build an access database where he makes the changes in a familiar environment (access) and sends me a table with all the changes he''s made, but ONLY the changes he''s made.

My current hosting plan makes it way to difficult to link the tables, so offline updating is the best bet. In addition, they only support MySQL and PostGres.

Can I use Access to build transaction tables for me to receive from him? (A table with the record Number, name of the field changed, and new value would suffice) I.E. {167,Home_Address,155 North 5th Street}

Or can anyone here think of something more simple?

I''m probably really overlooking the simple solution here.

推荐答案

我想这是可能的。


你在这个过程的哪个阶段有控制权吗？你打算设计他将要使用的Access数据库吗？

I guess it''s possible.

What stages of the process do you have control over? Are you about to design the Access database that he''ll be using?

是的，我已经开始导入表格并制作表格，但我知道我可能会把它们丢弃。 :-P


更简单，我可以只标记他所更改的每条记录，并让他导出那些，然后我可以直接替换整个MySQL记录。我很乐意。只要记录下来，如果记录中的任何内容发生变化，就会触发YES / NO字段。


哇，我的思绪徘徊 - 导入表两次是否可行（tbl_main和tbl_main1 ）他改变了一个地址然后当他完成时，我比较表中的所有数据并根据任何差异建立交易？


Arrgh ......这么多的可能性。 ACCESS太强大了。从DOS开始我的DB3在哪里？


Tony

Yes, I''ve started by importing the tables and making his forms, but know I will probably trash them. :-P

Even more simple, could I just mark each record that he changes, and have him export those, and then I could just replace the entire MySQL record. I''m up for that. Just make it so if ANYTHING on a record changes, a YES/NO field is triggered.

Wow, My mind wanders- Would it be feasible to import a table twice (tbl_main and tbl_main1) he changes an address and then when he''s done, I compare all data in the table and build the transactions based on any difference?

Arrgh...so many possibilities. ACCESS is just too powerful. Where''s my DB3 from DOS days?

Tony

顺便说一句，我可以完全访问MySQL，并且在MS上相当不错访问，但只需要在裤子上有一个好的踢，以便朝着正确的方向前进。


Tony

Incidentally, I have full access to the MySQL, and am fairly decent at MS Access, but just need a good kick in the pants to get moving the right direction.

Tony

这篇关于交易表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！