Why cannot modity or add , in the webpage ? ( I am in gread need of your help )

[Martin]

Access can generate .htm documents.

Yet I am facing a problem:

the .htm document I generated by my Access ( generated base on a Query of
this Access database), cannot be modified or add any data in it.

However, I explore other person's .htm, I find that it can be add data or
modify data in the .htm

I think, somewhere must exist a "switch" to let users to be able to enter
data or modify data in the .htm



I really needs your help. Thanks!

Martin

 

[Arvin Meyer [MVP]]

I would check out the permissions on the IIS server. Then check the DSN used
to connect the web page to the database. Ask your network administrator to
make sure that the I_User account has permission to write data to the
server.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Martin]

Thanks, but not such kind of problem. It is not an internet problem. I
generate the "page" inside Access, so, it would not relate to the IIS
problem.

 

[Arvin Meyer [MVP]]

So what you are saying is that you don't have an updateable query, even
before the page is viewed? If that's the case you need to make sure your
query is updateable. Here are a few KB articles which may help:

http://support.microsoft.com/kb/209571/en-us

http://support.microsoft.com/kb/174640/en-us
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Martin]

Thank you ! You really helped me !

Your method gives me a clue to solve the big problem finally!

Thank you! I have been being a hard time these several days to find a way to
solve this problem.


The problem I now know:
1. My first model's problem: the table is without KEY
2. My first model's problem: the Query is from two tables, and these two
tables are linked to each other ( 1 to 1 ), and, the Access Page cannot
accept such model to be modified or added --- I think ACCESS really has
great problem in this usage, because a DataAccessPage cannot be
generated( Page content modifiable and addable) from a Query which is based
on two related tables.

Thanks again.

Martin (Martin Lee)