Database question ?

[bmd2k1]

I'm using ASPSmartUpload component in conjunction with MS Access.

I updated the name of the table in MS Access that I use....and subsequently changed the table name in my ASP code.

However, when I run my update routine, I am now getting an ODBC error...when I issue the "rs.Update" command :
"Operation must use an updateable query"

I haven't changed any code, other than updating the table name.

All of my display queries work just fine. It's my edit and add queries that are the problem.

I'm currently using a System DSN. (The table name was changed after the System DSN was created. - Not sure if this has any bearing.)

Anyone have any ideas on this ? I can post the code if need be.

I must be having one of those days!


-Thanks...
B

[bmd2k1]

As it turns out....someone had done something on the server and changed the permissions....which resulted in the problem.

Frustrating.

Thanks for looking though.

-B

[no_mac_jack]

Wouldn't it be nice if you could keep everyone away from what you're doing? :D: ;):

Good luck with the rest of the project!

~no_mac_jack