When I run the Avatar Mod v2.0 script from the admin_mod_dbsetup.asp page the script runs and tells me that the table FORUM_AVATAR already exists but succesfully adds the table FORUM_AVATAR2 and the field for Avatar URLs to the FORUM_MEMBERS table. But when I try to add an avatar to the database I get the following error message:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_AVATAR'.
/forum/admin_add_avatar.asp, line 90
Can somebody help cos my forum members keep asking for Avatars and delivering them is proving itself to be more difficult than I expected.
Thanks Richard, I found this about 10 mins after posting this. I just needed to get the updated admin_mod_dbsetup.asp file and then everything went fine. You can check out my forum with the Avatar MOD here: http://www.vdesign-studios.com/forum/default.asp
Um: My config.asp is fine (I've actually modded mine slightly to include my sites hits counter). If your having problems with setting up the Avatar MOD follow Richards link and get the updated admin_mod_dbsetup.asp and then try running the MOD setup again and you should find it works fine and then you'll be able to use Avatars.