Access2002 on Web Site

  • Thread starter Thread starter John
  • Start date Start date
J

John

I am using an Access2002 DB for inventory on a website.
Generally, I have been making the inventory updates on my
desktop and then uploading the DB to the website. I am
using ASP pages to query the DB and display the results
online with no problems.

Now I have created ASP pages to handle the inventory
management; add new record, modify record, delete record,
etc... Problem is that while I can read the DB with no
problem, I cannot add,change or delete in any way. I get
the msg that says "must use updateble table".

I have the DB in share mode and have made sure that the
rights on the hosting directory are read,write,delete.

I can't figure this out... any ideas?

Thanks
John
 
You have to add a primary key to the table before it will let you update.
With out this , the database has no way of uniquely identifying the row to
be changed.
Add a field. Call it IDNO make it nmuber - autonumber, and make it the
primary key if you can (Although people in this group may complain that you
will not be using the concept of primary key properly - and they are
probably right)
 
Back
Top