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/



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net