Cdate error after migration

no problem

1 Setting default values

- open the database in Access
- then open the tables in design view
then in each row/field you see a name,field type - comment

if you click the row in the bottom section you see lots of values /options.

make sure the one that says default value has '0' for the number of posts (this is for the threads table)

2. to Compact and repair

ope n the database in access, then on the tools menu you will see database utilities i think

click that and select Compact & Repair"


trying a new database

upload a new blank database withithe same name as the one on the server , this will replace the existing one.. then try posting a message, if it works you know its the original database thats the problem.

make sure you back up the original database before uplopading a blank one.

no.. ill explain thats was just saying what the collumn names where

in the above screen shot you see te section called general and one set back saying lookup?

if you make sure the general pannel is in front as it is in the screen shot.

then in the list below you should see default value .

--> where it says field name at the top of the screen shot.. there is a list of fields (PM_ID, Author_ID....)

click on PM_Message_Date, then in the section i mentioned above about the defaul value see if it s default value is set to NOW()

then use the same method to check the post count within the tblauthor table, the default value should be 0

also check that the join dates default value  is set to NOW()



after another way to check is to open the table in record view so you can see the records.

thehn see what value is in those fields mentioned if there is nothing at all in them for any record, oralso the very bottom one as the last one is the default values per a new record.

you need to make sure all tables default values are correct, you wiull have to compare them to a default/blank database.

if you can are able to / security i mean . you can send a copy of the database to me at aaron [@] emagine-hosts.com and i wil download and look tomorrow.?