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

In reply to Re: Re: Re: DBI ODBC CGI Access hangs on execution of select statement by tachyon
in thread DBI ODBC CGI Access hangs on execution of select statement by buttroast

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.