VP-ASP Super User
Posted - May 29 2006 : 16:33:33
| VP-ASP versions affected: 5.5
Description: Version 5.5 introduced the split database feature. If the "User Control" features of the administrator control panel is used to change passwords or make other minor changes to for an administrator account, that administrator will lose access to certain menus.
shopa_user_control.asp or other related asp file does not have full knowledge of the slit database feature. The result is corruption of the tblusr table in the database. Specifically, the tablesallowed field loses some of the values that it should have in it.
One workaround to avoid this problem is to only use the "Edit Tables" feature of the cart to modify the user. Unfortunately, this is painful.
If the problem has already caused corruption of your administrator controls, you'll need to add some or all of following entries back into the tablesallowed field using Microsoft Access or "Edit Tables"
Of course, only add tables that you actually want access to and there may be others needed for your situation that aren't in this list.
Sometime in the past, I received the ASP code correction for this from support, but am unable to find it now. Does someone else have this fix?
Edited by - greatphoto on May 29 2006 16:54:42