Filemaker还是Access？ [英] Filemaker or Access?
问题描述
我在一家超过一年的小公司工作。我把它们卖给了
用于跟踪销售和订单输入的数据库的想法（加上
许多其他职责）。我们将开发自己的数据库，并试图决定使用哪种软件。我们是基于Windows的，具有
Access和FMP 8.5的试用版。我过去几年使用了Access for
并且会将我的技能称为中级以上但是
绝对不是专家。几年前我曾经使用过FMP（之前它是关系型的
~1987）但很喜欢它。其中一位业主是我们的IT经理，他们知道很多，但不是数据库（理论或实践）。由于存在安全问题，他倾向于支付
FMP（他表示，在互联网上使用时，b
应该更容易使用，而且更不容易受到攻击）。尽管如此，我们的决定仍然是大约50/50美元。
无论哪种方式，我都是最了解数据库管理的人。我已经审查了FMP的试用版本，我很快就记住了我喜欢的内容，但是我没看到的一些数据库基础知识就像分配一个
主键;看起来好像FMP不顾一切地使用这个术语在他们的任何文档甚至是圣经中都是如此。我在Borders购买了
。
经过大量阅读后，我理解FMP曾经是关联的
文件，但是现在一切都可以用一个文件，多个表来完成。然而
快速解决方案Filemaker'的网站提供似乎让我链接所有
这些文件。这几乎感觉就像我知道得太多使用FMP。我是
寻找设置数据库的条款和方法，这些数据库在
FMP中不存在。这只是一个学习曲线还是我错过了什么？
我诚实地愿意使用这两个程序。你有什么建议吗？
I work for a small company just over a year old. I have them sold on
the idea of a database for tracking their sales and order entry (plus
many other duties). We are going to develop our own database and are
trying to decide which software to use. We are windows based, have
Access, and a trial version of FMP 8.5. I have used Access for the
past few years and would call my skills above intermediate but
definitely not expert. I used FMP years ago (before it was relational
~ 1987) but loved it. One of the owners is our IT manager and knows a
lot, but not about database (theory or practice). He is leaning toward
FMP because of the security issues (he says it should be easier to
utilize and less vulnerable when on the Internet). Nevertheless, we
are still about 50/50 in our decision.
Either way, I am the most knowledgeable on database management. I have
been reviewing the trial FMP and I quickly remembered what I loved,
however some of the database basics I don''t see are like assigning a
primary key; it almost seems as if FMP goes out of their way not to
use the term in any of their documentation or even the "Bible" I
purchased at Borders.
After reading a lot, I understand FMP used to be relational by linking
files, but now it can all be done with one file, multiple tables. Yet
the fast solutions Filemaker''s website offers seem to make me link all
these files. It almost feels like I "know too much" to use FMP. I''m
looking for terms and ways to set up the database that don''t exist in
FMP. Is this just a learning curve or what am I missing?
I am honestly open to using either program. What are your suggestions?
推荐答案
< Al ********* @ Hotmail.com写信息
新闻：11 ********************** @ k79g2000hse.googlegr oups.com ...
<Al*********@Hotmail.comwrote in message
news:11**********************@k79g2000hse.googlegr oups.com...
我在一家超过一年的小公司工作。我把它们卖给了
用于跟踪销售和订单输入的数据库的想法（加上
许多其他职责）。我们将开发自己的数据库，并试图决定使用哪种软件。我们是基于Windows的，具有
Access和FMP 8.5的试用版。我过去几年使用了Access for
并且会将我的技能称为中级以上但是
绝对不是专家。几年前我曾经使用过FMP（之前它是关系型的
~1987）但很喜欢它。其中一位业主是我们的IT经理，他们知道很多，但不是数据库（理论或实践）。由于存在安全问题，他倾向于支付
FMP（他表示，在互联网上使用时，b
应该更容易使用，而且更不容易受到攻击）。尽管如此，我们的决定仍然是大约50/50美元。
无论哪种方式，我都是最了解数据库管理的人。我已经审查了FMP的试用版本，我很快就记住了我喜欢的内容，但是我没看到的一些数据库基础知识就像分配一个
主键;看起来好像FMP不顾一切地使用这个术语在他们的任何文档甚至是圣经中都是如此。我在Borders购买了
。
经过大量阅读后，我理解FMP曾经是关联的
文件，但是现在一切都可以用一个文件，多个表来完成。然而
快速解决方案Filemaker'的网站提供似乎让我链接所有
这些文件。这几乎感觉就像我知道得太多使用FMP。我是
寻找设置数据库的条款和方法，这些数据库在
FMP中不存在。这只是一个学习曲线还是我错过了什么？
我诚实地愿意使用这两个程序。你的建议是什么？
I work for a small company just over a year old. I have them sold on
the idea of a database for tracking their sales and order entry (plus
many other duties). We are going to develop our own database and are
trying to decide which software to use. We are windows based, have
Access, and a trial version of FMP 8.5. I have used Access for the
past few years and would call my skills above intermediate but
definitely not expert. I used FMP years ago (before it was relational
~ 1987) but loved it. One of the owners is our IT manager and knows a
lot, but not about database (theory or practice). He is leaning toward
FMP because of the security issues (he says it should be easier to
utilize and less vulnerable when on the Internet). Nevertheless, we
are still about 50/50 in our decision.
Either way, I am the most knowledgeable on database management. I have
been reviewing the trial FMP and I quickly remembered what I loved,
however some of the database basics I don''t see are like assigning a
primary key; it almost seems as if FMP goes out of their way not to
use the term in any of their documentation or even the "Bible" I
purchased at Borders.
After reading a lot, I understand FMP used to be relational by linking
files, but now it can all be done with one file, multiple tables. Yet
the fast solutions Filemaker''s website offers seem to make me link all
these files. It almost feels like I "know too much" to use FMP. I''m
looking for terms and ways to set up the database that don''t exist in
FMP. Is this just a learning curve or what am I missing?
I am honestly open to using either program. What are your suggestions?
我没有使用过FMP，但你的IT人员的安全问题可以解决
带有SQL Server后端，免费版本支持2GB数据。互联网
从MSAccess访问SQL服务器需要仔细编码您的
表单，报告和源查询，以减少通过WAN的数据传输。
使用终端服务器访问Internet将简化MSAccess的操作。 WEB
将需要其他东西，然后MSAccess
I have not used FMP but your IT person''s security concerns can be solved
with a SQL Server backend, the free version supports 2GB of data. Internet
access to the SQL server from MSAccess will require careful coding of your
forms, reports and source queries to reduce data transfers over the WAN.
Internet access with Terminal server would simplify things for MSAccess. WEB
based will require something other then MSAccess
Al ********* @ Hotmail.com 写道：
Al*********@Hotmail.com wrote:
>这几乎感觉就像我知道太多了使用FMP。我正在寻找设置GMP中不存在的数据库的条款和方法。这只是一个学习曲线还是我错过了什么？
我诚实地愿意使用这两个程序。你有什么建议？
>It almost feels like I "know too much" to use FMP. I''m
looking for terms and ways to set up the database that don''t exist in
FMP. Is this just a learning curve or what am I missing?
I am honestly open to using either program. What are your suggestions?
我会同意你从朋友那里听到并读到的情绪。对于初学者来说，使用FMP可能更容易
。但是如果你开始进入
中级或高级的东西，那么FMP就不能做Access的事情。
Tony
-
Tony Toews，Microsoft Access MVP
请仅在新闻组中回复，以便其他人可以
阅读整个消息主题。
Microsoft Access Links，Hints，Tips&会计系统
http://www.granite.ab.ca /accsmstr.htm
Tony的Microsoft Access博客 - http://msmvps.com/blogs/access/
Al ********* @ Hotmail.com 写道：
我在一家小公司工作超过一岁。我把它们卖给了
用于跟踪销售和订单输入的数据库的想法（加上
许多其他职责）。我们将开发自己的数据库，并试图决定使用哪种软件。我们是基于Windows的，具有
Access和FMP 8.5的试用版。我过去几年使用了Access for
并且会将我的技能称为中级以上但是
绝对不是专家。几年前我曾经使用过FMP（之前它是关系型的
~1987）但很喜欢它。其中一位业主是我们的IT经理，他们知道很多，但不是数据库（理论或实践）。由于存在安全问题，他倾向于支付
FMP（他表示，在互联网上使用时，b
应该更容易使用，而且更不容易受到攻击）。尽管如此，我们的决定仍然是大约50/50美元。
无论哪种方式，我都是最了解数据库管理的人。我已经审查了FMP的试用版本，我很快就记住了我喜欢的内容，但是我没看到的一些数据库基础知识就像分配一个
主键;看起来好像FMP不顾一切地使用这个术语在他们的任何文档甚至是圣经中都是如此。我在Borders购买了
。
经过大量阅读后，我理解FMP曾经是关联的
文件，但是现在一切都可以用一个文件，多个表来完成。然而
快速解决方案Filemaker'的网站提供似乎让我链接所有
这些文件。这几乎感觉就像我知道得太多使用FMP。我是
寻找设置数据库的条款和方法，这些数据库在
FMP中不存在。这只是一个学习曲线还是我错过了什么？
我诚实地愿意使用这两个程序。你有什么建议吗？
I work for a small company just over a year old. I have them sold on
the idea of a database for tracking their sales and order entry (plus
many other duties). We are going to develop our own database and are
trying to decide which software to use. We are windows based, have
Access, and a trial version of FMP 8.5. I have used Access for the
past few years and would call my skills above intermediate but
definitely not expert. I used FMP years ago (before it was relational
~ 1987) but loved it. One of the owners is our IT manager and knows a
lot, but not about database (theory or practice). He is leaning toward
FMP because of the security issues (he says it should be easier to
utilize and less vulnerable when on the Internet). Nevertheless, we
are still about 50/50 in our decision.
Either way, I am the most knowledgeable on database management. I have
been reviewing the trial FMP and I quickly remembered what I loved,
however some of the database basics I don''t see are like assigning a
primary key; it almost seems as if FMP goes out of their way not to
use the term in any of their documentation or even the "Bible" I
purchased at Borders.
After reading a lot, I understand FMP used to be relational by linking
files, but now it can all be done with one file, multiple tables. Yet
the fast solutions Filemaker''s website offers seem to make me link all
these files. It almost feels like I "know too much" to use FMP. I''m
looking for terms and ways to set up the database that don''t exist in
FMP. Is this just a learning curve or what am I missing?
I am honestly open to using either program. What are your suggestions?
既然你在一个专门讨论MS-access
问题的新闻组中提出你的问题，我猜你会得到答案支持选择
MS-Access。这只是我的推荐，因为我知道并且喜欢
访问并且不是文件制作者。
如果您打算在网上提交申请确保你知道
关于Access的限制。你不能真正用Access构建网络应用程序。
是的，你可以使用数据访问页面，但Access似乎正在逐渐消失
。
如果你在网上使用你的Access数据库作为数据库服务器，并且正确地做了b / b
，我认为你不必担心安全问题。
但当然如果有疑问，SQL服务器将是可行的方法。
但请注意，SQL服务器只是一个数据管理器。 Access和
FM都有一个应用程序开发组件。访问''
应用程序开发组件也可以使用SQL服务器数据
作为自己内置的Jet数据库。我也觉得Filemaker可以这么做。
Bob
Since you asked your question in a newsgroup devoted to MS-access
issues, I would guess you would get answers supporting the choice of
MS-Access. That would be my recommendation only because I know and like
Access and don''t filemaker.
If you are planning to put an application on the web make sure you know
about Access'' limitations. You can''t really build web apps with Access.
Yes, you can use Data Access Pages but Access seems to be moving away
from them.
If you use your Access database on the web as a database server, and do
it correctly, I don''t think you have to worry very much about security.
But certainly if in doubt, SQL server would be the way to go.
But also note that SQL server is just a data manager. Both Access and
FM have an application development component as well. Access''
application development component can work with SQL server data as well
as its own built in Jet database. I assssuuummme that Filemaker can do
so as well.
Bob
这篇关于Filemaker还是Access？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
