I'm only using Access because I don't know how to use MySQL yet.

Concepts are all the same. GUI Interface is of course different. You also have a command line interface which is good if you come from *nix but may be very unfaliliar if you were weaned on drag and drool.

I think I will try to backup the db and just delete the original...

Why? Just repair it. Make a copy first of course just to be safe. We have all had the M$ hanging data loss blues (BSOD) at one stage of another.

my db is in a general folder one level above my cgi-bin folder. Does it need to be somewhere specific?

Not really provided you can connect to it. Just wanted to clarify that it is on localhost and therefore there are no network issues involved. The only real issue is that you don't want it under your HTTP root in a world readable directory assuming that this is a commercial widget and you don't want just anybody walking off with your data. Plus all the usual security stuff.

cheers

tachyon

s&&rsenoyhcatreve&&&s&n.+t&"$'$`$\"$\&"&ee&&y&srve&&d&&print

One of the first things I tried to do was compact and repair it, but it wouldn't let me. It said the database was in use. I rebooted, but forgot to try it again. Thanks buttroast

You do have a lockfile issue then. If your DB is called FOO.MDB then you will find the lockfile called FOO.LDB in the same dir as the .MDB file. Delete FOO.LDB and all should be well. If Windows won't let you you can often make a copy of the 'locked' file FOO.MDB to say FOO1.MDB. FOO1.MDB will then have lost the lock.

cheers

tachyon

s&&rsenoyhcatreve&&&s&n.+t&"$'$`$\"$\&"&ee&&y&srve&&d&&print