Peter Jones
|
| Posted: 12/05/2002, 9:50 AM |
|
Hope someone can shed some light on this.
I am creating a project where the site design in in an acces database table called template, fields for header, left,right,menu & footer.
My page has a form that get template records 1, whish has the details and displays it correctly.
This is working fine, my main problem is that 2 to 3 times a day the menu field gets corrupted, so that when I look at the table wiithin access the menu field is populated either with #error or #######. I then need to repair the database.
I have rebuilt the entire database from scratch, new file, recreated all the tables and fields, yet it stills does this.
using CCS 1.0.7, w2K Mdac 2.7, Access 2000,
Any help or thoughts on this greatly appreciated.
|
|
|
 |
Bill
|
| Posted: 12/06/2002, 5:52 AM |
|
The first step would be to enter the corrupted record again, but this time directly into the access table, this way you could narrow the fault down to either the database or the input form.
|
|
|
|
Peter Jones
|
| Posted: 12/09/2002, 9:54 AM |
|
I do not have a form for this table, it is coded in access itself.
The pages which access this table do not have any functions for updating the table, this table is the html for the site layout.
|
|
|
|
Bill
|
| Posted: 12/10/2002, 10:53 AM |
|
Open access
Double click the table
It should open just like a spreadsheet in edit mode.
Enter the information directly into the table.
Sounds like
1 You are trying to enter a value which is greater than the table will accept.
2 You are trying to enter a string, where a numeric is required.
3 The number of characters is greater than the field will hold.
Access usually defaults to a field of 50 characters of required type Text.
|
|
|
|
Peter Jones
|
| Posted: 12/13/2002, 3:57 PM |
|
The table field is a memo field, the field holds the table fine in access, and for a while in Project
The problem is that the table field is getting corrupted, for no reason, as the project dooes not have any function in it to update the records for that table.
Yet it is?
That is the problem!
|
|
|
|
Bill
|
| Posted: 12/15/2002, 9:37 AM |
|
This is a strange one.
I wonder if the buffers are being flushed back to the table without being set.
If you dont need to update the table, try opening it as read only.
|
|
|
|
Peter Jones
|
| Posted: 12/19/2002, 8:44 AM |
|
Hi Bill
That sounds like a good idea.
How can the table be opened for just read-only.
Thanks in advance
Peter
|
|
|
|
Robin Bolton
|
| Posted: 12/19/2002, 3:25 PM |
|
If you are using ODBC for your DB connection, you can set the read-only option from the ODBC control panel:
1) Start/Settings/Control Panel/Administrative Tools/Data Sources (ODBC)
2) select the database in question and click the Configure button
3) Click the Options bottom in the bottom right corner, Read Only is there
|
|
|
|
bfr
|
| Posted: 12/19/2002, 3:39 PM |
|
Try changing the memo fields to text and running the same queries. I believe null memo fields can cause the behavior you are expirencing. The work around, if this is the case is to code in a business rule allowing null values.
|
|
|
|
Bill
|
| Posted: 12/21/2002, 3:54 AM |
|
Is the problem sorted ?
If so, what did the trick.? (for the benefit of us all)
|
|
|
|
|
