访问我的男人？ [英] Is Access my man?

问题描述

大家好，


人们一直在说访问是一场噩梦。或访问是

地狱但我听到这个人的唯一的人就是那些使用Access经验不足的人。我最能把这些人绑在一起

就是Access并不健壮，它只允许少数用户和

锁定它是非常糟糕的。


我以前用过单个用户工作清单系统，它是优秀的b / b
。我正在为一个慈善组织开发一个系统，所以

我想要钱，我想知道可以处理我的

要求。系统是：


大约15个并发用户（我打算拆分数据库）

目前17,000行不可能超过30,000

将在未来5年内使用。


Access可以处理这个吗？我在问，因为我想知道有多少是什么

我听说Access是城市神话，多少是真的。我将使用

2003.访问是否有所改善？


感谢您的评论


LL

Hi All,

People keep saying things like "Access is a nightmare" or "Access is
hell" but the only people I hear this from are peopel who aren''t that
experienced in using Access. The most I can tie these people down to
is that Access isn''t robust, that it only allows a few users and that
the locking on it is terrible.

I used it before for a single user worklist system and it was
excellent. I''m now developing a system for a charity organisation so
I''ve to think of money and I''m wondering can access handle my
requirement. The system is:

Approx 15 concurrent users (I plan to split the db)
Currently 17,000 rows not likely to grow beyond 30,000
Will be used for the next 5 years.

Can Access handle this? I''m asking because I wonder how much of what
I hear about Access is urban myth and how much is true. I''d be using
2003. Has Access improved?

Thanks for any comments

LL

推荐答案

Luvin午餐< ma ************ @ o2.iewrote新闻：f09fea6a-38d7-4192- 866e-
8d ********** @ e60g2000hsh.googlegroups.com ：

Luvin lunch <ma************@o2.iewrote in news:f09fea6a-38d7-4192-866e-
8d**********@e60g2000hsh.googlegroups.com:

大家好，


人们一直在说访问是一场噩梦。或访问是

地狱但我听到这个人的唯一的人就是那些使用Access经验不足的人。我最能把这些人绑在一起

就是Access并不健壮，它只允许少数用户和

锁定它是非常糟糕的。


我以前用过单个用户工作清单系统，它是优秀的b / b
。我正在为一个慈善组织开发一个系统，所以

我想要钱，我想知道可以处理我的

要求。系统是：


大约15个并发用户（我打算拆分数据库）

目前17,000行不可能超过30,000

将在未来5年内使用。


Access可以处理这个吗？我在问，因为我想知道有多少是什么

我听说Access是城市神话，多少是真的。我将使用

2003.访问是否有所改善？


感谢您的评论


LL

Hi All,

People keep saying things like "Access is a nightmare" or "Access is
hell" but the only people I hear this from are peopel who aren''t that
experienced in using Access. The most I can tie these people down to
is that Access isn''t robust, that it only allows a few users and that
the locking on it is terrible.

I used it before for a single user worklist system and it was
excellent. I''m now developing a system for a charity organisation so
I''ve to think of money and I''m wondering can access handle my
requirement. The system is:

Approx 15 concurrent users (I plan to split the db)
Currently 17,000 rows not likely to grow beyond 30,000
Will be used for the next 5 years.

Can Access handle this? I''m asking because I wonder how much of what
I hear about Access is urban myth and how much is true. I''d be using
2003. Has Access improved?

Thanks for any comments

LL

Access就像其他RAD一样，是开发人员的好。


听起来你的15个用户如果没有超过30000条记录，那么就不能全部使用它。


我不知道Access的任何问题/ JET锁定除DD以外（dumb

开发人员）。

Access, just like every other RAD, is a good as the developer.

It sounds to me that your 15 users can''t be using all that intensively if
there never will be more than 30000 records.

I don''t know of any issues with Access/JET locking other than DD (dumb
developer).

2月27日，12：40 * pm，lyle fairfield< lylef。 .. @ yah00.cawrote：

On Feb 27, 12:40*pm, lyle fairfield <[e-mail]:

Luvin午餐< martina_mul ... @ o2.iewrote新闻：f09fea6a-38d7-4192-866e-

8de42d06b ... @ e60g2000hsh.googlegroups.com:

Luvin lunch <[e-mail] in news:f09fea6a-38d7-4192-866e-
[e-mail]:

大家好，

Hi All,

人们一直在说访问是一场噩梦之类的事情。或访问是

地狱 *但是我听到的唯一的人是peopel，他们使用Access并不是很有价值。 * *我最能把这些人绑在一起

是Access不强大，它只允许少数用户和

锁定它是可怕。

People keep saying things like "Access is a nightmare" or "Access is
hell" *but the only people I hear this from are peopel who aren''t that
experienced in using Access. *The *most I can tie these people down to
is that Access isn''t robust, that it only allows a few users and that
the locking on it is terrible.

之前我用过单个用户工作清单系统，它是优秀的b / b
。 *我现在正在为慈善组织开发一个系统，所以

我想到钱，我想知道可以处理我的

要求。 *系统是：

I used it before for a single user worklist system and it was
excellent. *I''m now developing a system for a charity organisation so
I''ve to think of money and I''m wondering can access handle my
requirement. *The system is:

大约15个并发用户（我打算拆分数据库）

目前17,000行不太可能增长超过30,000

将在未来5年内使用。

Approx 15 concurrent users (I plan to split the db)
Currently 17,000 rows not likely to grow beyond 30,000
Will be used for the next 5 years.

Access可以处理这个吗？ *我在问，因为我想知道有多少是什么

我听说Access是城市神话，多少是真的。我将使用

2003. * Access是否有所改进？

Can Access handle this? *I''m asking because I wonder how much of what
I hear about Access is urban myth and how much is true. I''d be using
2003. *Has Access improved?

感谢您的评论

Thanks for any comments

LL

LL

访问，就像其他所有RAD一样，是开发人员的好。


听起来我的15个用户不能如果

，那么将永远使用所有这些记录。


我不知道Access / JET锁定其他任何问题比DD（dumb

开发人员）.-隐藏引用的文字 -


- 显示引用的文字 -

Access, just like every other RAD, is a good as the developer.

It sounds to me that your 15 users can''t be using all that intensively if
there never will be more than 30000 records.

I don''t know of any issues with Access/JET locking other than DD (dumb
developer).- Hide quoted text -

- Show quoted text -

嘿Lyle，


感谢您的回答。我并不是故意暗示我认为Access是一场噩梦。我发帖的原因是谣言传闻

但是我想听听那些实际使用Access的人，因为

只有那些曾经说过Access的人才是噩梦是那些没有b $ b bb b真正使用它的人。当我问他们时，似乎没有人能够证实他们的要求

。他们总是说像锁定这样的东西是可怕的等等。


所以基本上听起来你很自信如果获得

split可以处理15个并发用户输入不超过
30,000条记录。这是正确的吗？


我会觉得我可能会受到DD的影响（而且很可惜我不是在谈论我的胸罩大小;-)）我认为如果我使用我的插入和更新的事务我会没事的。像你一样

说，它并没有受到重创，我发现VBA非常方便

验证。


我仍然对所有这些谣言的来源感到好奇。是

它访问97是麻烦，并且所有问题已经解决了吗？

Hey Lyle,

Thanks for that answer. I didn''t mean to imply that I think Access is
a nightmare. The reason I''m posting is that that rumour goes around
but I want to hear from people who actually use Access because the
only people who ever say Access is a nightmare is people who don''t
really use it. No one seems to be able to substantiate their claim
when I ask them to. They always say things like the locking is
terrible etc.

So basically it sounds like you''re fairly confident that access if
split could handle fifteen concurrent users entering not more than
30,000 records. Is that correct?

I would be consciuos that I might suffer from a touch of the DDs (and
unfortunately I''m not talking about my bra size ;-)) I presume if I
use transactions for my inserts and updates I''ll be alright. Like you
say, it''s not that heavily hit and I find the VBA really handy for
validation.

I am still curious as to where all these rumours are coming from. Is
it that access 97 was trouble and that all the problems have been
resolved?

Luvin午餐< ma ************ @ o2.iewrote在

新闻：a9 **************** ****************** @ p43g2000 hsc.googlegroups.com:

Luvin lunch <ma************@o2.iewrote in
news:a9**********************************@p43g2000 hsc.googlegroups.com:

2月27日，12：40 *下午，lyle fairfield< lylef ... @ yah00.cawrote：

On Feb 27, 12:40*pm, lyle fairfield <[e-mail]:

> Luvin lunch< martina_mul ... @ o2.iewrote in
新闻：f09fea6a-38d7-4192-866e-
8de42d06b ... @ e60g2000hsh.googlegroups.com:

>Luvin lunch <[e-mail] in
news:f09fea6a-38d7-4192-866e-
[e-mail]:

嗨全部，

Hi All,

人们一直在说访问是一场噩梦。或访问

是地狱 *但是我听到的唯一的人是peopel谁

不是

People keep saying things like "Access is a nightmare" or "Access
is hell" *but the only people I hear this from are peopel who
aren''t that

使用Access时经验丰富。 * *我可以将这些人与
绑定

experienced in using Access. *The *most I can tie these people down

到

to

是Access不健壮，它只允许少数用户和

锁定它是可怕的。

is that Access isn''t robust, that it only allows a few users and
that the locking on it is terrible.

之前我用过单个用户工作清单系统，它是优秀的b / b
。 *我现在正在为慈善组织开发一个系统

所以我想到钱，我想知道可以访问我的

要求。 *系统是：

I used it before for a single user worklist system and it was
excellent. *I''m now developing a system for a charity organisation
so I''ve to think of money and I''m wondering can access handle my
requirement. *The system is:

大约15个并发用户（我打算拆分数据库）

目前17,000行不太可能增长超过30,000

将在未来5年内使用。

Approx 15 concurrent users (I plan to split the db)
Currently 17,000 rows not likely to grow beyond 30,000
Will be used for the next 5 years.

Access可以处理这个吗？ *我在问，因为我想知道有多少

我听说Access是城市神话，多少是真的。我将使用2003年获得
。* Access是否有所改进？

Can Access handle this? *I''m asking because I wonder how much of
what I hear about Access is urban myth and how much is true. I''d be
using 2003. *Has Access improved?

感谢您的评论

Thanks for any comments

LL

LL

访问，就像所有其他RAD一样，是开发人员的好处。

听起来你的15个用户不能使用所有这些
如果永远不会有超过30000条记录那么密集。

我不知道除了DD之外的任何Access / JET锁定问题
（愚蠢的开发人员）.-隐藏引用的文字 -

- 显示引用的文字 -

Access, just like every other RAD, is a good as the developer.

It sounds to me that your 15 users can''t be using all that
intensively if there never will be more than 30000 records.

I don''t know of any issues with Access/JET locking other than DD
(dumb developer).- Hide quoted text -

- Show quoted text -

嘿莱尔，


感谢您的回答。我并不是故意暗示我认为Access是一场噩梦。我发帖的原因是谣言传闻

但是我想听听那些实际使用Access的人，因为

只有那些曾经说过Access的人才是噩梦是那些没有b $ b bb b真正使用它的人。当我问他们时，似乎没有人能够证实他们的要求

。他们总是说像锁定这样的东西是可怕的等等。


所以基本上听起来你很自信如果获得

split可以处理15个并发用户输入不超过
30,000条记录。这是正确的吗？


我会觉得我可能会受到DD的影响（而且很可惜我不是在谈论我的胸罩大小;-)）我认为如果我使用我的插入和更新的事务我会没事的。像你一样

说，它并没有受到重创，我发现VBA非常方便

验证。


我仍然对所有这些谣言的来源感到好奇。

它访问97是麻烦，并且所有的问题已经解决了？b $ b？

Hey Lyle,

Thanks for that answer. I didn''t mean to imply that I think Access is
a nightmare. The reason I''m posting is that that rumour goes around
but I want to hear from people who actually use Access because the
only people who ever say Access is a nightmare is people who don''t
really use it. No one seems to be able to substantiate their claim
when I ask them to. They always say things like the locking is
terrible etc.

So basically it sounds like you''re fairly confident that access if
split could handle fifteen concurrent users entering not more than
30,000 records. Is that correct?

I would be consciuos that I might suffer from a touch of the DDs (and
unfortunately I''m not talking about my bra size ;-)) I presume if I
use transactions for my inserts and updates I''ll be alright. Like you
say, it''s not that heavily hit and I find the VBA really handy for
validation.

I am still curious as to where all these rumours are coming from. Is
it that access 97 was trouble and that all the problems have been
resolved?

有些电脑用户认为如果可以关闭
a节目，它会增加一个人的声望。

我希望这里有关于你打算做什么的其他意见;我是b $ b开发计算特定和密集的应用程序，可能不是类似于你的计划的b $ b;虽然他们有多个用户，但通常每个用户都有他/她自己的数据。您可以从开发人员的建议中受益，这些开发人员的工作更接近您的描述。

Some computer people think that it adds to one''s prestige if one can off
a program.

I hope there will be other opinions here about what you plan to do; I
develop calculation specific and intensive applications which may not be
similar to your plans; while they have multile users, typically each user
has his/her own data. You may benefit from advice from developers whose
work is closer to what you describe.

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