Local Database Interaction?
Hey all,
I'm fairly new to the whole database "scene" but am trying to start by creating an Administrative Interface for a small business. Basically, I just need to create some kind of form that can read and write to a database on the user's computer (local). I could just use Access and create some forms and stuff in there, but I'm trying to avoid having the user startup Access and navigate to the proper form and all of that... then there is the visual factor too.
Originally I wanted to use Macromedia Flash to create an interface that data could be pulled to, but I haven't found a solution yet that doesn't involve a web server, and thus makes the idea of the process being local, unachievable. I refuse to believe that you can access a database through a server only and not directly on one machine... that doesn't seem to make any sense. Any help, pointers... anything, would be greatly appreciated. thanks!
Woody
[970 byte] By [
woodman650] at [2007-11-11 8:19:37]
# 1 Re: Local Database Interaction?
Access is the easiest, and you don't have to use the visual part of it. You can just consider it as a database and ignore the forms, reports, ... that come with it. A windows program written in any language (.net, java, ...) you want can access it. And office is not required for that, just the latest MDAC.
Otherwise, most database vendors (microsoft's SQL express, Oracle, IBM's DB2, ...) have a free version these days of their products which will do all you need. Or you can go for an open source database (SQLlite, MySql, ...). Disadvantage is that these databases have to be installed making distribution more difficult. SQLlite may be an exception but I have no experience with it. Access on the other hand is just a file, which is easy to deploy.
If you want more ideas about development environments as an alternative to Flash, this forum might be a little off topic.
Hope it helps.
Cedric
# 2 Re: Local Database Interaction?
geez, I didn't really databases were so tricky. I was all set to head the MySQL route until I realized it needed to be installed, but now I'm lost again. I need to create an online management system, where I can create/view database entries... users can login into accounts to view and edit their information. But I want to keep it as simple and straightforward as possible, without having to install anything anywhere if possible. Any suggestions? haha, thanks
# 3 Re: Local Database Interaction?
Hi friendz,
Just to let you know that, there is a software 'ZINC', using which you can build Flash Desktop Application, even database connectivity.
it allows you to connect MS Access or MySQL database without IIS!
Just check this on link :
http://www.multidmedia.com/
Cheers,
Rohan Chandane
