Web Wiz Forums - Using Access 2007

Print Page | Close Window

Using Access 2007

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=27287
Printed Date: 02 April 2026 at 7:08pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Using Access 2007

Posted By: Candyman
Subject: Using Access 2007
Date Posted: 24 April 2009 at 11:43pm

I'm installing the Forums software using the Access method. Yes i know this is a bad way to go for it, but it's a small group and i doubt if more then one person would ever even be on at the same time. Instead of using the MDB i upgraded the DB that came with the files to MS Access 2007 (accdb) and changed the lines in "database_connection.asp" to this

Was this:
strDbPathAndName = Server.MapPath("database/ForumDB.mdb")
strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & strCon

Now this:
strDbPathAndName = Server.MapPath("database/ForumDB.accdb")
Provider=Microsoft.ACE.OLEDB.12.0;Data Source="&strDbPathAndName

But i always get this error:
Server Error in Forum Application
An error has occurred while writing to the database.
Please contact the forum administrator.

Support Error Code:- err_Access_loginUser()_update_login_attempts
File Name:- functions_login.asp

Error details:-
ADODB.Recordset
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.

The permissions are set on the IUSR account for read, write and modify. So i'm not sure what to try next. If it can't be done with the newer DB then i'll upload the old one and change things back.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 27 April 2009 at 8:04am

As Access is not supported in a production environment the Access 2007 ACE driver has not been fully tested yet. Although preliminary tests on version 10 do look promising.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: Candyman
Date Posted: 27 April 2009 at 3:24pm

Thanks for letting me know. Guess i'll need to go the hosting rout. Any ideas how i could change my order from the product to hosting?

Posted By: Putz22
Date Posted: 27 April 2009 at 5:03pm

Contact Sales With your Inquiry on this one...

http://www.webwiz.net/contact/" rel="nofollow - http://www.webwiz.net/contact/