MDB problem

[vicsam]

I'm new to ASP and I got a website to maintain. I have some experience with MS-Access and html.

We have a mdb for a pictures gallery asp page. I had to delete some old picture, so I downloaded the mdb, deleted the pics (records in a table) and uploaded the mdb back to the website.

I probably didn't do it right because we cannot see the picture anymore. I even try to upload again the backup that I have for that mdb but it didn't work either.

I also try to delete the ldb file but didn't help.

Can you help me?

[jeffstl]

Is it possible that the code written for displaying the pictures assumes that there will always be something in that database field?

You say you deleted entire records from this database or just fields out of records?

Did you make any changes to the table designs? To you remove columns or delete actual data from the table?

Lastly, if you truly made a back up .mdb before making ANY changes, and you have uploaded that back up to the FTP site, it really should have instantly corrected the problem. So with that being the case my guess is you need to find the original design\database and compare the two to see whats changed or different about them. Also see questions above.

[vicsam]

Is it possible that the code written for displaying the pictures assumes that there will always be something in that database field?

Gallery Names, Pictures, Menus... all the information for that page is in that mdb... I deleted all records with the same number.

You say you deleted entire records from this database or just fields out of records?

Did you make any changes to the table designs? To you remove columns or delete actual data from the table?

No. The format of the table is the same as before.


Lastly, if you truly made a back up .mdb before making ANY changes, and you have uploaded that back up to the FTP site, it really should have instantly corrected the problem. So with that being the case my guess is you need to find the original design\database and compare the two to see whats changed or different about them. Also see questions above.

The backup was not touched, I uploaded it back almost right away. But it was from the downloaded file, not from the file that was on the site. So I'm wondering if I broke some db connection because I downloaded/uploaded those files just using copy/paste on the ftp connection.

[jhardman]

The backup was not touched, I uploaded it back almost right away. But it was from the downloaded file, not from the file that was on the site. So I'm wondering if I broke some db connection because I downloaded/uploaded those files just using copy/paste on the ftp connection.

that's possible. What is the connection string you are using? This should look something like: [code=asp]set objConn = server.createOb ject("ADODB.Con nection")
objConn.open "..."[/code]

[vicsam]

I have something like this...

Set rs_album_cmd = Server.CreateOb ject ("ADODB.Command ")
rs_album_cmd.Ac tiveConnection = MM_newalbum_STR ING
rs_album_cmd.Co mmandText = "SELECT * FROM albums WHERE Código = ?"
rs_album_cmd.Pr epared = true
rs_album_cmd.Pa rameters.Append rs_album_cmd.Cr eateParameter(" param1", 5, 1, -1, rs_album__MMCol Param) ' adDouble

Set rs_album = rs_album_cmd.Ex ecute
rs_album_numRow s = 0

[vicsam]

I found the problem...

I should use a ftp software to upload back that mdb... I did and it's working now.

thanks for your help