how now cash cow?

[b_c]

so, i've been working tirelessly on a pos-type system for the last 10-months. i finally have it dialed in...but i'm looking to take it to "the next level".

seriously, what are my options?

i've heard about sql/mysql - how do these work? is it an "executable" file that's created by using this type of code? what are the benefits, what are the drawbacks? does/can it offer the functionality of access w/o bloating or loosing some of the functionality that i've embedded?



...it would be great if i could get away from the access platform, but i do enjoy the functionality. how can and/or should i make the "pos" that i've created more robust within the access platform itself?


what are my options as far as taking what i have, and being able to find a company who will make it what it needs to be (obviously at a charge)? ...you know like a .accdb-2-.exe company? i've tried the embedded functionality within access, but it errors out on me b/c i'm using some modules and there's some sort of table-assignment error that access spits at me when i've tried to run it.


anyway, sorry for my rambling post. i'm really at a crossroads b/c i believe i have something worth value, but i want to make sure that it's value and future are "secure"....if that makes sense?



cheers,

b_c

 

[namliam]

SQL/MySQL, is a bigger database, which does help against bloating as the data is actually stored on a seperate database. There are some limitations and considerations to be made when considering using another database.
You cannot do everything to a 'outside' table that you can do to a Access table.
Your 'setting' might have to change a little, i.e. you may need to change the way you do queries and what not.

"it would be great if i could get away from the access platform"
Good luck...
You basicaly cannot unless you go into seperate languages like VB/C#/etc...

"a .accdb-2-.exe company"
I dont understand your comment here?

 

[gemma-the-husky]

"a .accdb-2-.exe company"

i understand the OP to be looking for a way to change a database (therefore requiring a dbs manager application) to a standalone exe programme.

-------------
Lets assume that this is not possible (or at any event - not practical - or MS would have alreay made this avaialble to us all!)


The other way to look at this, is to provide a way of distributing a database together with the appropriate support system. Now this has been made increasingly simple over the years.

First we can distribute a MDE
Second we can use certain facilities/code to hide the design features/database window from users
Third, users can now take advantage of free run time versions of A2007 and A2010 (if not earlier)
A2010 is now starting to add facilities to upload databases to a web.

I think this is the way to look at it.

Especially, in any commercial environment the extra cost of the users buying a copy of access, is not prohbitive anyway.

--------------
so now, it becomes a question of marketing/distribution/robustness and how you can provide support to users.

 

[b_c]

what about finding a more adept programmer than me for my program? i know it could be more streamline and whatnot, but how do i find an access programmer who's worth two shakes to look at my program (everything: tables, queries, modules, reports, etc) and "fix" it the way it should be or even better could be?


gemma or namliam, do either or you "farm" out work or know anyone i could trust and would be interested?



cheers,

b_c