Asking help for Access!:( - 未名空间MITBBS历史存档

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

Redian新闻

>未名空间

>Database - 数据库

Asking help for Access!:(

Asking help for Access!:(# Database - 数据库

i*g2000-06-27 07:06

1 楼

ASP + Access to collect data from a webpage form,
that is, users fill in the form and click "submit",
my asp file will store the data into an Access table.
This program ran well, but yesterday after I deleted some
records which were entered by myself for testing, the
program can't run well. The error information is "The
file is in use." Actually, I just opened the database
and did nothing on it. O.K., I closed the database, then
another error information of "read-only data" appears.
Why? Thanks

j*a2000-06-27 07:06

2 楼

When you want to change to data in Access, just close the
corresponding table view or design, no need to close the
Access file. Of course, closing it will be also OK.
But I don't know why is the "read-only data" problem. Maybe
your Access file has been damaged. I think the problem
should lie on Access file, not the ASP code.

【在 i*******g 的大作中提到】

: ASP + Access to collect data from a webpage form,
: that is, users fill in the form and click "submit",
: my asp file will store the data into an Access table.
: This program ran well, but yesterday after I deleted some
: records which were entered by myself for testing, the
: program can't run well. The error information is "The
: file is in use." Actually, I just opened the database
: and did nothing on it. O.K., I closed the database, then
: another error information of "read-only data" appears.
: Why? Thanks

i*g2000-06-27 07:06

3 楼

Thanks for response, then how to recover
the access database files? The ASP file stores
data into two tables( some data into one table,
some others into another table, but the two tables
have some datas in common) in the access database,
and I just deleted the two testing records in the
two tables.

【在 j*****a 的大作中提到】

: When you want to change to data in Access, just close the
: corresponding table view or design, no need to close the
: Access file. Of course, closing it will be also OK.
: But I don't know why is the "read-only data" problem. Maybe
: your Access file has been damaged. I think the problem
: should lie on Access file, not the ASP code.

j*a2000-06-27 07:06

4 楼

1. It's hard to undo some operations on Access database
file, as far I know. So what I mean to recover it is
to use the latest backup Access files, if your current
data file is in a mess.
2. I don't understand your points clearly. Are they
datus stored by ASP that be shared with two tables?
3. I think it's a good design of database to store datus
in one table, and transfer them in other tables by
relationships. Maybe your problem lies on the relationships.
If you can delete your test records in

【在 i*******g 的大作中提到】

: Thanks for response, then how to recover
: the access database files? The ASP file stores
: data into two tables( some data into one table,
: some others into another table, but the two tables
: have some datas in common) in the access database,
: and I just deleted the two testing records in the
: two tables.