Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS Access
 Can't change moderator back to normal user		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

prescottw
Junior Member

189 Posts
Posted - 25 August 2009 :  13:58:22  Show Profile  Send prescottw a Yahoo! Message
Microsoft JET Database Engine error '80040e07'

Data type mismatch in criteria expression.

/forum/pop_profile.asp, line 1625

here is line 1625


my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords

Hello fellow Snitzlings... LONG time!

About 4 or 5 years ago switched to SQL Server. About two years ago switched back to access... (raised the price on me by 500% and couldn't afford it)

Anyway, have a problem switching moderators back to normal users. Can't Archive anymore either.

But the moderator thing is my main problem at the moment. Any help would be appreciated.

Thanks aagain,

-prescottw
What day is it anyway?

iane87
Starting Member

USA
42 Posts
Posted - 25 August 2009 :  15:10:00  Show Profile  Visit iane87's Homepage
Did you change the DB type in config.asp?

strDBType = "access"

I would recommend MySQL over access it's free and much faster.
Twitter MOD | Search Provider MOD | W3C Valid RSS MOD | Google Translate MOD
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 25 August 2009 :  15:26:29  Show Profile  Send ruirib a Yahoo! Message
You will need to Response.Write the strSQL variable, so that what's being written to the database can be seen.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

prescottw
Junior Member

189 Posts
Posted - 29 August 2009 :  02:32:00  Show Profile  Send prescottw a Yahoo! Message
Thank you ruirib... Response.Write strSql was commented out. Crazy. I worked on trying to figure out what to do for too long and it was right in front of me the entire time. I commented out the my_conn.execute just now and the forum archived perfectly. (it did write alot on the page as it was going through the motion). I'll keep looking at the moderator problem.

Thank You iane87! I actually spent alot of time setting up a mysql database. But I'm working in a HELm environment and have long times between support requests and answers (could not figure out where database was located on server). But I will migrate. Been with same reseller for years and years so I'm patient with them.

Thank you both for helping me.

-prescottw

25255 posts, Congrats ruirib.
What day is it anyway?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.15 seconds. Powered By: Snitz Forums 2000 Version 3.4.07