Programming Forums > Web Development and Design > Databases

rogonma · Sep 2nd, 2009, 5:28 AM

Hi:

I need a small and simple db to organize my CDs and DVDs.

I thought in Access because I can make a good front-end without programming but I can't use Access because of money and I don`t like Openoffice Base: it hasn't as many features as Access.

Can you tell me about any other alternative program to make a good front-end (with forms, etc) without programming? I can install a database like MySQL, I only need the front-end for the UI.

Thanks.

sgnirtswob · Sep 2nd, 2009, 7:07 AM

phpMyAdmin works very well with MySQL have you looked at that? would that do what you need?

rogonma · Sep 2nd, 2009, 8:11 AM

mmm... It doesn't do.

I need forms. I need a form to insert a new DVD, with comboboxes showing data in joined tables, etc.

And my friends want me to copy the program for their use.

sgnirtswob · Sep 2nd, 2009, 8:18 AM

Have you ever played with phpMyAdmin?

it's just that it offers a GUI interface to editing the data, admittadly it's basic but if you just needed a single table it would work. Im assuming you know this and need a more complicated multi table style solution, is that correct?

rogonma · Sep 2nd, 2009, 8:22 AM

Yes, it's right.

I know phpMyAdmin and I use to manage my databases at work but it's not good for a final user. And I don't want to manage manually the foreign keys between tables.

Arla · Sep 2nd, 2009, 11:08 AM

Open Office Base?

I've not played with it, but I believe it's the "free" alternative from Open Office to Access.

Weird Fishes · Sep 2nd, 2009, 2:09 PM

Quote:

Originally Posted by Arla

Open Office Base?

I've not played with it, but I believe it's the "free" alternative from Open Office to Access.

Quote:

Originally Posted by rogonma

...I don`t like Openoffice Base: it hasn't as many features as Access.

It’s free, you get what you pay for. (Not that I’m knocking open source software...)

CoderGuru · Sep 2nd, 2009, 6:36 PM

You surely get what you pay for... As for mySQL, how do you expect to interact with the database without any programming?

Sep 2nd, 2009, 5:28 AM	#1
rogonma Newbie Join Date: Sep 2009 Posts: 3 Rep Power: 0	Microsoft Access alternative Hi: I need a small and simple db to organize my CDs and DVDs. I thought in Access because I can make a good front-end without programming but I can't use Access because of money and I don`t like Openoffice Base: it hasn't as many features as Access. Can you tell me about any other alternative program to make a good front-end (with forms, etc) without programming? I can install a database like MySQL, I only need the front-end for the UI. Thanks.

Sep 2nd, 2009, 7:07 AM	#2
sgnirtswob Experience Teaches Us Join Date: Dec 2008 Location: Wales Posts: 34 Rep Power: 0	Re: Microsoft Access alternative phpMyAdmin works very well with MySQL have you looked at that? would that do what you need? __________________ Experience is the only teacher we have www.rsmithers.net www.russellsashtanga.info

Sep 2nd, 2009, 8:11 AM	#3
rogonma Newbie Join Date: Sep 2009 Posts: 3 Rep Power: 0	Re: Microsoft Access alternative mmm... It doesn't do. I need forms. I need a form to insert a new DVD, with comboboxes showing data in joined tables, etc. And my friends want me to copy the program for their use.

Sep 2nd, 2009, 8:18 AM	#4
sgnirtswob Experience Teaches Us Join Date: Dec 2008 Location: Wales Posts: 34 Rep Power: 0	Re: Microsoft Access alternative Have you ever played with phpMyAdmin? it's just that it offers a GUI interface to editing the data, admittadly it's basic but if you just needed a single table it would work. Im assuming you know this and need a more complicated multi table style solution, is that correct? __________________ Experience is the only teacher we have www.rsmithers.net www.russellsashtanga.info

Sep 2nd, 2009, 8:22 AM	#5
rogonma Newbie Join Date: Sep 2009 Posts: 3 Rep Power: 0	Re: Microsoft Access alternative Yes, it's right. I know phpMyAdmin and I use to manage my databases at work but it's not good for a final user. And I don't want to manage manually the foreign keys between tables.

Sep 2nd, 2009, 11:08 AM	#6
Arla Expert Programmer Join Date: Mar 2005 Posts: 778 Rep Power: 6	Re: Microsoft Access alternative Open Office Base? I've not played with it, but I believe it's the "free" alternative from Open Office to Access. __________________ I can remember, back in '22 They changed the law - came knocking on the door In that same moment, the broadband seemed to go.. Phones all dead. Gone dizzy in the head..

Sep 2nd, 2009, 6:36 PM	#8
CoderGuru Professional Programmer Join Date: Jan 2009 Location: Dallas, Texas, USA Posts: 329 Rep Power: 2	Re: Microsoft Access alternative You surely get what you pay for... As for mySQL, how do you expect to interact with the database without any programming? __________________ Dallas Web Design \| Texas Web Design \| www.ChillAxen.com \| Renee C. Greco Fund

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Microsoft Access Title,Subject,Author Property	Muneeb	Visual Basic .NET	0	Feb 13th, 2009 11:01 PM
Working for Microsoft	Wizard1988	Coder's Corner Lounge	16	Sep 24th, 2007 12:07 PM
How to connect with VB to an Access database on another computer	iown714	Visual Basic	5	Aug 4th, 2005 10:23 AM
problem with JDBC for talking to Microsoft Access database using a Java Applet	captainK	Java	4	Mar 20th, 2005 11:01 AM

Programming Forums > Web Development and Design > Databases

Microsoft Access alternative