Easy to use database?

[slackerinabox]

MS access is driving me crazy! Is there any easy to use database program or website out there?
thanks!

 

[PowerMacG5]

You can find GUI frontends for certain databases.

 

[loup garou]

If Access is giving you problems, I suggest grabbing a few books on database basics or taking a class, because it doesn't get much easier than that.

 

[PowerMacG5]

Originally posted by: werk
If Access is giving you problems, I suggest grabbing a few books on database basics or taking a class, because it doesn't get much easier than that.

I have to agree. If you want to access it where you have full control, every decent database is using SQL syntax to access and alter data. As I said, you can get GUI frontends, but they are very restricted in functionality.

 

[Hector13]

Originally posted by: freedomsbeat212
MS access is driving me crazy! Is there any easy to use database program or website out there?
thanks!

perhaps you can use excel? cause I can't think of many rdbms "easier" than access. Anything in particular that is causing you problems?

 

[wyvrn]

Access is pretty easy. Go learn SQL and then you won't have to worry about the interface.

 

[ggavinmoss]

Originally posted by: Hector13

Originally posted by: freedomsbeat212
MS access is driving me crazy! Is there any easy to use database program or website out there?
thanks!

perhaps you can use excel? cause I can't think of many rdbms "easier" than access. Anything in particular that is causing you problems?

If I had a nickel for everytime somebody used a spreadsheet program for a database... I'd be rich!

-geoff

 

[wyvrn]

Originally posted by: ggavinmoss

Originally posted by: Hector13

Originally posted by: freedomsbeat212
MS access is driving me crazy! Is there any easy to use database program or website out there?
thanks!

perhaps you can use excel? cause I can't think of many rdbms "easier" than access. Anything in particular that is causing you problems?

If I had a nickel for everytime somebody used a spreadsheet program for a database... I'd be rich!

-geoff

Excel isn't just a spreadsheet, sir! Pair it with solver and you have some serious functionality on your hands. Though I agree it's not a true database program.

 

[ISAslot]

If you want to use sql with access, you can find common sql commands and such on the mysql doc pages, the syntax won't have to be changed too much for most things either.

 

[PowerMacG5]

Originally posted by: ISAslot
If you want to use sql with access, you can find common sql commands and such on the mysql doc pages, the syntax won't have to be changed too much for most things either.

Uhm, he would be better off looking up the documents on MS SQL Server. mySQL out of the box with no add ons is not a RDBMS, and doesn't contain the same exact helper stored procedures that MS Access and MS SQL Server have. He would be better off learning generic SQL syntax, and then go learn how access handles everything.

 

[ggavinmoss]

Originally posted by: wyvrn

Originally posted by: ggavinmoss

Originally posted by: Hector13

Originally posted by: freedomsbeat212
MS access is driving me crazy! Is there any easy to use database program or website out there?
thanks!

perhaps you can use excel? cause I can't think of many rdbms "easier" than access. Anything in particular that is causing you problems?

If I had a nickel for everytime somebody used a spreadsheet program for a database... I'd be rich!

-geoff

Excel isn't just a spreadsheet, sir! Pair it with solver and you have some serious functionality on your hands. Though I agree it's not a true database program.

I was by no means trying to demean Excel, I think it's just the bee's knees. However I've seen plenty of projects that should've used Access or another DB solution rely on Excel trickery and shenanigans and it quickly becomes a VBA nightmare.

-geoff

 

[Soybomb]

I find mysql very easy to work with