Anyone with MS access?

Discussion in 'OT Graveyard' started by ThatHideousStrength, Dec 17, 2006.

  1. ThatHideousStrength

    ThatHideousStrength Junior Member

    Messages:
    6,109
    Trophy Points:
    53
    I don't have access and I need to make a database. The database is supposed to have a primary key for band names, then a table for cds. then I need a table for http://www.links that are linked from the cd titles.

    Could someone please do this? All I need is a tables, no data, maybe just fake data to make sure it works.
  2. succubus

    succubus Comfortably Numb

    Messages:
    1,591
    Trophy Points:
    51
    Location:
    127.0.0.1
    OpenOffice.org: Home

    open source version of MS Office - Open Office data base files will also work with MS Office Access files. GL
  3. ThatHideousStrength

    ThatHideousStrength Junior Member

    Messages:
    6,109
    Trophy Points:
    53
    I can't save as mdb on there, I already tried. I need it to be Access because I'm going to program a asp.net site.
  4. Drakkon

    Drakkon New Member

    Messages:
    890
    Trophy Points:
    0
    http://www.drakkon.net/files/music.mdb

    two tables...one called band_names the other calls cds
    band_names has 2 colums: band_id,band_name
    cds has 4: id, band_id, cd_title, link

    band_id is a linked item between the twoo tables
  5. Sweatervest

    Sweatervest New Member

    Messages:
    1,427
    Trophy Points:
    0
    Location:
    Hudson, Ohio
    You're going about it all wrong in that case.
  6. ThatHideousStrength

    ThatHideousStrength Junior Member

    Messages:
    6,109
    Trophy Points:
    53
    Thanks a lot!!
  7. ThatHideousStrength

    ThatHideousStrength Junior Member

    Messages:
    6,109
    Trophy Points:
    53
    Drakkon can you do one more thing for me please? Can you add in a fake band / cd? I can't seem to get the database to display in visualbasics aspx.
  8. Drakkon

    Drakkon New Member

    Messages:
    890
    Trophy Points:
    0
    *record added - click same link again
  9. ThatHideousStrength

    ThatHideousStrength Junior Member

    Messages:
    6,109
    Trophy Points:
    53
  10. ThatHideousStrength

    ThatHideousStrength Junior Member

    Messages:
    6,109
    Trophy Points:
    53
    SOrry one more thing :( , I'm getting a error when I try to add a new record through the site, I need what happens on the 2nd slide to be set.

    [​IMG]

    [​IMG]

    Crap I just realized the answer is not on there... fuck. I think it deals with autonumber. I need to set the autonumber off the BAND table I believe.
  11. Jamsan

    Jamsan Junior Member

    Messages:
    1,650
    Trophy Points:
    53
    Location:
    Connecticut
    Im not sure if you wanted to remove the autonumber from band_id in the bands table, but thats what i did... both band_id in bands and in cd's are numbers now..

    http://www.nynx.net/Jamsan/music.mdb

    any reason why you're using access and not sql server?
  12. ThatHideousStrength

    ThatHideousStrength Junior Member

    Messages:
    6,109
    Trophy Points:
    53
    Thanks!

    Because thats all I know right now :(
  13. ThatHideousStrength

    ThatHideousStrength Junior Member

    Messages:
    6,109
    Trophy Points:
    53
    doh, something isn't right :x, band names don't appear as I type them in now.
  14. succubus

    succubus Comfortably Numb

    Messages:
    1,591
    Trophy Points:
    51
    Location:
    127.0.0.1
    I realize you're probably finished by now - but here's an FYI

    You do not have to use .mdb just because you're using ASP.net.

    Code:
    *  ODBC Driver for dBASE 
    
    oConn.Open "Driver={Microsoft dBASE Driver (*.dbf)};" & _
               "DriverID=277;" & _
               "Dbq=c:\somepath"
    
    Then specify the filename in the SQL statement:
    
    oRs.Open "Select * From user.dbf", oConn, , ,adCmdText
    
    Note: MDAC 2.1 (or greater) requires the Borland Database Engine (BDE) to update dBase DBF files. (Q238431).
    
    For more information, see:  dBASE Driver Programming Considerations
    
    To view Microsoft KB articles related to Microsoft dBASE Driver, click here 
    That was located here: ODBC DSN-Less


    I found it because this person had an issue loading dBASE files using ASP.net - you can read about it here: ASP.NET Forums - Problem in connecting DataBase through ODBC

    EDIT - - -
    I guess I could have mentioned you can do this with PHP and mySQL...but you said earlier you wanted to use ASP.net since you were familiar with it.
  15. Sweatervest

    Sweatervest New Member

    Messages:
    1,427
    Trophy Points:
    0
    Location:
    Hudson, Ohio
    That's what I was getting at before. Or, you could have just used ASP + mssql, assuming you had both of those available to you.
  16. ThatHideousStrength

    ThatHideousStrength Junior Member

    Messages:
    6,109
    Trophy Points:
    53
    I'm doing it this way because I have knowledge of it :x, I have never touched SQL yet. All the code I did for what I'm doing is autogenerated as well. I'll be learning SQL soon though.
  17. succubus

    succubus Comfortably Numb

    Messages:
    1,591
    Trophy Points:
    51
    Location:
    127.0.0.1
    I was under the impression that this was for school - but I just realized everyone's out for Christmas break lol
    I'm going to PM you- I might have a couple ebooks you can use in your quest to learn sql.
  18. Sweatervest

    Sweatervest New Member

    Messages:
    1,427
    Trophy Points:
    0
    Location:
    Hudson, Ohio
    Definitely take up on that, SQL is a valuable tool.
  19. ThatHideousStrength

    ThatHideousStrength Junior Member

    Messages:
    6,109
    Trophy Points:
    53
    :p Thanks

    No I'm making a database where people can add a link to a cd of a band to download. I want people to add links, update them etc...
  20. succubus

    succubus Comfortably Numb

    Messages:
    1,591
    Trophy Points:
    51
    Location:
    127.0.0.1
    Here's what I have for SQL - -

    beginners guide to mysql and php.zip
    learn sql in 21 days.zip
    MCSE Training Kit 70-029 - MS SQL Server 7.0 Database Implementation .rar
    MCSE Training Kit 70-229 - MS SQL Server 2000 Database Design and Implementation.rar
    Microsoft SQL Server DBA Survival Guide.zip
    ms press - sql 7 data warehousing.zip
    ms press - sql 7 database implementation.zip
    my sql manual.zip