access Vs. SQL - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

access Vs. SQL

access Vs. SQL# Database - 数据库

l*q2000-05-24 07:05

1 楼

管理1000条左右的记录，
打算用ASP+Web Browser的界面，
server 端用 Acess 支持得了吗？
如果用MS SQL Server，是不是一定要买 Internet Connector
才能使用 TCP/IP 对数据库进行访问？

m*t2000-05-24 07:05

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*n2000-05-24 07:05

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 的大作中提到】

xt2000-05-24 07:05

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*t2000-05-24 07:05

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.

xt2000-05-24 07:05

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*t2000-05-24 07:05

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.