Results 1 to 2 of 2

Thread: my first db

  1. #1
    Join Date
    Jul 2004
    Posts
    3

    Talking Unanswered: my first db

    I need to setup my first db and have a lot of questions.
    Ok, first thing what this db is going to be for uploaded files and I want to call it uploads. second I want I want it to be able to handle about 2gigs.
    now am I right in thinking that the actual db only handles the file info right. The files are uploaded to a folder and the file name,size,date,ip info is stored in my access db. so I would build a table say 200 columns and four rows then name it upload.db
    go to control panel select odbc
    select access 97
    for file I would point it to upload.db
    then click apply
    then run the script that connects the uploader to the db.
    and than it should work.

    Do I understand that right.
    Last edited by dvdljns; 07-27-04 at 22:48. Reason: inserting missing words.

  2. #2
    Join Date
    Feb 2004
    Location
    CT,USA
    Posts
    250
    Quote Originally Posted by dvdljns
    ...now am I right in thinking that the actual db only handles the file info; right? The files are uploaded to a folder and the file name,size,date,ip info is stored in my access db.
    Do I understand that right. So, I would build a table say 200 columns and four rows then name it upload.db
    You've got the rows/columns concept reversed.
    Quote Originally Posted by dvdljns
    ....so I would then name it upload.db
    go to control panel select odbc
    select access 97
    for file I would point it to upload.db
    then click apply
    then run the script that connects the uploader to the db.
    and than it should work.
    Do I understand that right.
    Probably, not. However, your thinking is a good start. Databases hold info. The way you hold and use it is up to you. DB's don't mind read at the moment. So, could you explain what script and uploader you mean. You are talking about pointing to a "file"-- do you mean selecting a row from your database? Does your folder contain files that you would download regularly to get updates??

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •