ASP?????? Strange problem

cocoonfx · 01-20-2010, 02:05 PM

Hello Chaps....

This may not make sense as I don't understand what happened....... I have taken over a site with an ASP database running a members area. I am in the process of making a better database using PHP and MySQL but I still need to make slight amendments to the ASP database. Ok last night I downloaded what i assumed to be the database it was in an Access format to my PC via Filezilla. (the previous administrator made a pigs ear of the whole site so it took me 2 hours to located the database.)

I then made a copy of the database and then opened the database by holding down shift to get to the tables. I then found the user table and changed the sort form Acsending to Decending. Save the file and then uploaded and over right the old database.

I then found to my horror that the login screens on the front end no longer worked and all the branding went and the head is should APSNet 3.6.2

So I then thought ok got the original no problem over right the updated one and everything should be restored...... no such luck.

As you can probably tell I have no experiene with ASP and I was wondering if I have done a critical error or possibly on the upload something could of been corrupted.

The only thing is the day before some of the posts disappeared from the database which lead me to make the changes. Can anyone advise what is the best method to update and change ASP database and could someone advise if what i did was sensible and the correct way. Or could it be something wrong on the hosts side???

HELP!

Corrosive · 01-20-2010, 02:41 PM

It's not anything to do with Access versions is it? Saved as 2007 when it should be 2000/3 maybe. I know I've had terrible trouble with Access versions in the past. Just I suggestion...I am no expert!

cocoonfx · 01-20-2010, 06:36 PM

hummm good point.... however I have noticed that when i open the databases its asking me to repair and compact which says to me the database is damaged in some way.

Corrosive · 01-20-2010, 06:42 PM

How big is it? Because there is a max size I think.

cocoonfx · 01-20-2010, 06:45 PM

it was 750KB and everytime I open the file it grows.... i can't even find the compact database in access 2007..... its been a while since i have used access.

edbr · 01-21-2010, 12:22 AM

what a night mare , id take the phone off the hook and hurry up with php

cocoonfx · 01-21-2010, 12:25 AM

your not far wrong.... 2nd late night in a row..... i have decided to go wordpress.... and lots of plugins saves a lot of time.....

01-20-2010, 02:05 PM	#1
cocoonfx Join Date: Nov 2006 Location: Tamworth,UK Posts: 576	ASP?????? Strange problem Hello Chaps.... This may not make sense as I don't understand what happened....... I have taken over a site with an ASP database running a members area. I am in the process of making a better database using PHP and MySQL but I still need to make slight amendments to the ASP database. Ok last night I downloaded what i assumed to be the database it was in an Access format to my PC via Filezilla. (the previous administrator made a pigs ear of the whole site so it took me 2 hours to located the database.) I then made a copy of the database and then opened the database by holding down shift to get to the tables. I then found the user table and changed the sort form Acsending to Decending. Save the file and then uploaded and over right the old database. I then found to my horror that the login screens on the front end no longer worked and all the branding went and the head is should APSNet 3.6.2 So I then thought ok got the original no problem over right the updated one and everything should be restored...... no such luck. As you can probably tell I have no experiene with ASP and I was wondering if I have done a critical error or possibly on the upload something could of been corrupted. The only thing is the day before some of the posts disappeared from the database which lead me to make the changes. Can anyone advise what is the best method to update and change ASP database and could someone advise if what i did was sensible and the correct way. Or could it be something wrong on the hosts side??? HELP! __________________ Regards Cocoonfxmedia http://www.cocoonfxmedia.co.uk/seo.html http://twitter.com/cocoonfxmedia http://facebook.com/cocoonfxmedialtd

01-20-2010, 02:41 PM	#2
Corrosive Join Date: Feb 2008 Location: Bristol, England Posts: 7,103	It's not anything to do with Access versions is it? Saved as 2007 when it should be 2000/3 maybe. I know I've had terrible trouble with Access versions in the past. Just I suggestion...I am no expert! __________________ Websites: www.yotocreative.co.uk \| www.clearwater-it.co.uk \| www.bristolcomputerfix.co.uk Social Media: Twitter \| Facebook

01-20-2010, 06:36 PM	#3
cocoonfx Join Date: Nov 2006 Location: Tamworth,UK Posts: 576	hummm good point.... however I have noticed that when i open the databases its asking me to repair and compact which says to me the database is damaged in some way. __________________ Regards Cocoonfxmedia http://www.cocoonfxmedia.co.uk/seo.html http://twitter.com/cocoonfxmedia http://facebook.com/cocoonfxmedialtd

01-20-2010, 06:42 PM	#4
Corrosive Join Date: Feb 2008 Location: Bristol, England Posts: 7,103	How big is it? Because there is a max size I think. __________________ Websites: www.yotocreative.co.uk \| www.clearwater-it.co.uk \| www.bristolcomputerfix.co.uk Social Media: Twitter \| Facebook

01-20-2010, 06:45 PM	#5
cocoonfx Join Date: Nov 2006 Location: Tamworth,UK Posts: 576	it was 750KB and everytime I open the file it grows.... i can't even find the compact database in access 2007..... its been a while since i have used access. __________________ Regards Cocoonfxmedia http://www.cocoonfxmedia.co.uk/seo.html http://twitter.com/cocoonfxmedia http://facebook.com/cocoonfxmedialtd

01-21-2010, 12:22 AM	#6
edbr Join Date: Aug 2005 Location: Bali Posts: 11,200	what a night mare , id take the phone off the hook and hurry up with php __________________ If you're happy and you know it shake your meds! different style links examples Flight / Hotel search Free script download Bali Villas

01-21-2010, 12:25 AM	#7
cocoonfx Join Date: Nov 2006 Location: Tamworth,UK Posts: 576	your not far wrong.... 2nd late night in a row..... i have decided to go wordpress.... and lots of plugins saves a lot of time..... __________________ Regards Cocoonfxmedia http://www.cocoonfxmedia.co.uk/seo.html http://twitter.com/cocoonfxmedia http://facebook.com/cocoonfxmedialtd

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode