Web Wiz Forums - Help: err_Access

Print Page | Close Window

Help: err_Access_getSessionData()

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=28541
Printed Date: 01 April 2026 at 9:11pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Help: err_Access_getSessionData()

Posted By: sharelife
Subject: Help: err_Access_getSessionData()
Date Posted: 21 April 2010 at 5:52pm

I enabled Logging Function and I recevied this error message.

Guest - ERROR - File: functions_session_data.asp - Error Details: err_Access_getSessionData()_save_new_session_data - Microsoft JET Database Engine - The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.

Error message always happened with Guest.

Please help me, how to overcome this error.
Thank you.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 21 April 2010 at 6:08pm

This can happen if the session ID already exists in the database, as it turned out the random code that was 32 hexadecimal numbers long was not as random as it should be and that systems were returning the same 32 hexadecimal long code around once every 10,000 times.

If you upgrade to the latest version it has a new way of creating the session ID, instead it uses 5 hexadecimal codes that have a length of between 4 and 8 and then stitches them together, this means that the likely hood of creating a random ID code the same is much less likely. There is also improved code to check that the session ID does not already exist.

-------------
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