linking files to a database comes back with errors Help! please

This topic is locked

linking files to a database comes back with errors Help! please	6/21/2006 11:59:35 AM
ASPRunnerPro General questions
B Bobs author I have made a very simple application where word files are stored in a directory and i am using asp runner v3.2 to make links to the files and once clicked on the file it opends up in a window fine i hear you all say but one slight problem randomly 8-10 i get an error as found below. The database has been set to r/w for the server/iusr_server account and all other permissions seem to be correct. I would appreciate any help on clearing up this issue. Many thanks Bob -------------------------------------------------------------------------------------------------------- Technical Information (for support personnel) Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver]Error in row /Policies/Policies_add.asp, line 472 Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1) Page: POST 239160 bytes to /Policies/Policies_add.asp POST Data: error '80020009' Exception occurred. /iisHelp/common/500-100.asp, line 192


K	kat 6/22/2006
	Bob, This error means one of the following: One or more required fields were not filled One of entered values do not conform field type (character values in numeric or date fields) You trying to enter a value into field which is of Autonumber type. You have a relationship between tables that requires you to put into foreign key field one of existing values from another table. If you put value that don't exist in another table you see the same error. To resolve this issues you need to dowble check what relationships you have in your database, what fields are required or don't allow zero length values. Try to find what field causes this problem by removing part of fields from this page.