Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - DB change wont work
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

DB change wont work
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
Katana View Drop Down
Newbie
Newbie


Joined: 06 April 2003
Status: Offline
Points: 5 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Katana Quote  Post ReplyReply Direct Link To This Post Topic: DB change wont work
    Posted: 06 April 2003 at 4:46am

Hey all,

I tried to convert my 6.34 db to 7.4 but it wouldnt work. I placed the files needed into C:\temp but the DB changer says that he cant find the files. I placed the DB changer also in the C:\temp and again he said "cannot find files" .

Any1 have a idea? cuz im totally lost
i have Acces 2000 i thought anywayz its the acces from the Office XP pack
Back to Top
eaglesexec View Drop Down
Groupie
Groupie
Avatar

Joined: 02 December 2002
Status: Offline
Points: 127 		Post Options Post Options   Thanks (0) Thanks(0)   Quote eaglesexec Quote  Post ReplyReply Direct Link To This Post Posted: 06 April 2003 at 11:40am
u also actually have to rename the files to old634.mdb and new7.mdb i believe. read the readme file very carefully man.
A good plan, violently executed now, is better than a perfect plan next week. -General George S. Patton.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 06 April 2003 at 1:44pm
Also compact and repair the database in access first to stop any error form occuring.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
xeerex View Drop Down
Senior Member
Senior Member


Joined: 19 November 2002
Location: United States
Status: Offline
Points: 601 		Post Options Post Options   Thanks (0) Thanks(0)   Quote xeerex Quote  Post ReplyReply Direct Link To This Post Posted: 06 April 2003 at 8:06pm

This doesn't really matter until v7 Final, but in testing the upgrade script from v6.34 to v7b3, I am getting the following error when try to post anything:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E2F)
[Microsoft][ODBC Microsoft Access Driver] 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.
/cotpforum/post_message.asp, line 609

Anyone have an idea? All the posts are there. Changes in the admin section such as adding forums works fine. It seems to only be on posting new topics or replies.

If you want to visit the test, go to http://rexpage.homedns.org/cotpforum and try it.
Need Hosting, Domains, Dedicated Servers?
web design | pc support | training | podcasts | video production
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 07 April 2003 at 1:15am
You must have a corrupted database then, you need to compact and repair the databases before and after the upgrade.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
xeerex View Drop Down
Senior Member
Senior Member


Joined: 19 November 2002
Location: United States
Status: Offline
Points: 601 		Post Options Post Options   Thanks (0) Thanks(0)   Quote xeerex Quote  Post ReplyReply Direct Link To This Post Posted: 07 April 2003 at 10:38pm

borg,

Did both of those and the same results. The database doesn't give any idications of corruption as I can open it fine after the updgrade. I know its not corrupted before the upgrade as it is a straight FTP download from a working 6.34 forum and will power a 2nd 6.34 forum just fine.

I'm not too concerned at this point since I don't test the beta's on anything I plan to use live unlike some forum users.  

However, I am a little concerned about being able to eventually upgrade this one particular forum. Any ideas or has anyone else had problems with the Access upgrade script to v7b4?
Need Hosting, Domains, Dedicated Servers?
web design | pc support | training | podcasts | video production
Back to Top
xeerex View Drop Down
Senior Member
Senior Member


Joined: 19 November 2002
Location: United States
Status: Offline
Points: 601 		Post Options Post Options   Thanks (0) Thanks(0)   Quote xeerex Quote  Post ReplyReply Direct Link To This Post Posted: 07 April 2003 at 11:02pm

Hmm--guess 3rd time is the charm. I went through the same sequence a 3rd time and now it works fine.

So nevermind on my little problem .
Need Hosting, Domains, Dedicated Servers?
web design | pc support | training | podcasts | video production
Back to Top
Katana View Drop Down
Newbie
Newbie


Joined: 06 April 2003
Status: Offline
Points: 5 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Katana Quote  Post ReplyReply Direct Link To This Post Posted: 11 April 2003 at 4:56am
I did read the read-me  and changed the names to what they should be converted. Ill c if i can compact and repair the DB Thx all. ill be back soon
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.