Anyone with MS access?

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.

OpenOffice.org: Home

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

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.

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

You're going about it all wrong in that case.

Thanks a lot!!

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.

*record added - click same link again

Thanks!

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.





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.

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?

Thanks!

Because thats all I know right now

doh, something isn't right :x, band names don't appear as I type them in now.

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.

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.

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.

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.

Definitely take up on that, SQL is a valuable tool.

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...

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