7 beta 3 to 7 beta 4 the dummy’s guide

Ha ha meant for me..

1) Make a copy of your beta 3 mdb file.

2) open the beta3 mdb file with access

Things need to add

tblAuthor

1) Change Username length from 20 to 25

2)Add a column between Username and User_code

Rename it Real_name , Details : Datatype=text , Length=40

3) Add a column between Avatar and Last_visit

Rename it Avatar_title, Details: Datatype =text , length =40

2) tblConfiguration

1)Add 4 columns between Upload_files_size and Upload_component

Rename it respectively

Upload_avatar , Details : Datatype=Yes/No , Format=True/False

Upload_avatar_path , Details : Datatype=text , Length=50

Upload_avatar_types , Details : Datatype=text , Length=50

Upload_avatar_size , Details : Datatype=number , Field Size=integer

Key in 5 in the upload_avatar_size column

2)Delete Mass_mailier

3)Insert 1 column at the end

Rename it Reg_closed, Details : Datatype=yes/no , Format , True/False

3)tblGroup

1) Insert column between Stars and Starting_group

Rename it Custom_stars , Details: Datatype=text, length=80

4) Insert a new table called : tblGuestName

1)Insert 3 columns

Rename respectively

Guest_ID , Details : Datatype=AutoNumber , Field Size=Long Integer

Thread_ID , Details : Datatype=Number , Field Size=Long Integer

Name , Details : Datatype=text , Length=40

5)tblPoll

1) Rename Last_vote_IP to Author_ID

2)Delete all data in this column

Details : Datatype =number fieldsize=long integer

6) tblTopic

1)Insert column between Poll_ID and Subject

Rename it Moved_ID , Details : Datatype =number Filedsize =long integer

Key 0 in this column for all the data(rows) you have

INstall the new v 7 beta 4 files use this new mdb file.

This is as it is.. please backup your mdb before your try.

taffy wrote: Ha ha meant for me..

I followed those directions to a tee...and triple checked my work...even compared the new fields, tables, datatype, fieldsize and length, as well as table relationships with a brand new Beta 4 database side by side and disabled all extra forum functions.  I also compacted and repaired the database & I still get this error every time I try to make a new post no matter what I do!