l**q
发帖数: 335 | 1 管理1000条左右的记录，
打算用ASP+Web Browser的界面，
server 端用 Acess 支持得了吗？
如果用MS SQL Server，是不是一定要买 Internet Connector
才能使用 TCP/IP 对数据库进行访问？ |
m******t
发帖数: 2416 | 2 hehe, a 1000 records db is like a toy. Access can definitely
handle that. 8-)
【在 l**q 的大作中提到】
: 管理1000条左右的记录，
: 打算用ASP+Web Browser的界面，
: server 端用 Acess 支持得了吗？
: 如果用MS SQL Server，是不是一定要买 Internet Connector
: 才能使用 TCP/IP 对数据库进行访问？
|
w*********n
发帖数: 84 | 3 I think Access is enough.
However, seems Access is a single user DB, I guess which means
that there cann't have multiple users accesing the DB at
the same time.
So, balance it.
【在 l**q 的大作中提到】
: 管理1000条左右的记录，
: 打算用ASP+Web Browser的界面，
: server 端用 Acess 支持得了吗？
: 如果用MS SQL Server，是不是一定要买 Internet Connector
: 才能使用 TCP/IP 对数据库进行访问？
|
xt
发帖数: 17532 | 4
This is not true. Access has almost everything a full-fledged
database should have, including the multi-user access as long as it is
read-only.
【在 w*********n 的大作中提到】
: I think Access is enough.
: However, seems Access is a single user DB, I guess which means
: that there cann't have multiple users accesing the DB at
: the same time.
: So, balance it.
|
m******t
发帖数: 2416 | 5
hehe, I think what people would worry more about is concurrent writing/
reading.
【在 xt 的大作中提到】
:
: This is not true. Access has almost everything a full-fledged
: database should have, including the multi-user access as long as it is
: read-only.
|
xt
发帖数: 17532 | 6
Well, Access provides synchronization mechanism for sure. It is
comtemporary development, not the development in the good old days
where only 1 thread can be run at any time for a CPU. Tables in
access is locked by Table. That is, if one thread is writing to a
table, other threads will be locked out, unless the programmer
forces the committment.
【在 m******t 的大作中提到】
:
: hehe, I think what people would worry more about is concurrent writing/
: reading.
|
m******t
发帖数: 2416 | 7
Hmmm... that's OK. I might have misunderstood your words in your first
post.
【在 xt 的大作中提到】
:
: Well, Access provides synchronization mechanism for sure. It is
: comtemporary development, not the development in the good old days
: where only 1 thread can be run at any time for a CPU. Tables in
: access is locked by Table. That is, if one thread is writing to a
: table, other threads will be locked out, unless the programmer
: forces the committment.
|
