Access/Database help

Cid · 04-21-2006, 10:55 AM

Export it as a DBF or even CSV and import that into MySQL. Simple. If you're not sure how to do that, get MySQL front and import it using that. I'm almost sure you can save as dbf or csv in access. Then you could do whatever you want with the MySQL DB.

Or you could just make the forms in Access. Like creepy said, it's not tough. And yeah, they're like normal run of the mill front-end forms for your db. If you need it to be an executable file for distribution, use VB or do the mysql thing and make a web based app. You can use the mysql db in VB as well I believe, or Download Delphi and do it in Pascal. Or learn RUBY and do the REAL way.

Either way man, let me know if you need help. This is something I actually know a thing or two about

Cid · 04-21-2006, 11:00 AM

Oh I missed the part about the public computer thing. I assume you want this to be a thing where someone can sit down, open a program and search the DB.

If I were asked to do this right now, I would put it in MySQL and write a small delphi app. But since you don't have delphi or vb, I'd go with the php or perl app and just make a link to it on the desktop.

I think, either way, you want to put in mysql (or whatever sql server you've got) and go from there.

04-21-2006, 10:55 AM	#1
Cid Member Join Date: Oct 2004 Location: HELL Posts: 399	Export it as a DBF or even CSV and import that into MySQL. Simple. If you're not sure how to do that, get MySQL front and import it using that. I'm almost sure you can save as dbf or csv in access. Then you could do whatever you want with the MySQL DB. Or you could just make the forms in Access. Like creepy said, it's not tough. And yeah, they're like normal run of the mill front-end forms for your db. If you need it to be an executable file for distribution, use VB or do the mysql thing and make a web based app. You can use the mysql db in VB as well I believe, or Download Delphi and do it in Pascal. Or learn RUBY and do the REAL way. Either way man, let me know if you need help. This is something I actually know a thing or two about __________________ I like the things I do, so hooray for me...and fuck you!

04-21-2006, 11:00 AM	#2
Cid Member Join Date: Oct 2004 Location: HELL Posts: 399	Oh I missed the part about the public computer thing. I assume you want this to be a thing where someone can sit down, open a program and search the DB. If I were asked to do this right now, I would put it in MySQL and write a small delphi app. But since you don't have delphi or vb, I'd go with the php or perl app and just make a link to it on the desktop. I think, either way, you want to put in mysql (or whatever sql server you've got) and go from there. __________________ I like the things I do, so hooray for me...and fuck you!