Hello all

Currently my company is using a software which is installed in all the individual pc and connected to the Access database which is stored at the main server.

I've found an alternative to Access which is Base (Open office).

May i know, if possible, how do i make a software, the user interface, and connect it to the Base database? Any free / open source software which i can use to create the user interface?

Any other suggestion to make a software with database?

Thank you guys

If i were you, i'd start using a server based solution.

You would be better off using Microsoft SQL (licensed ware) or MySQL (freeware) and there are tons of ASP (for MSSQL) and PHP (for MySQL) based tutorials that you can use to make a good interface.

Base is individualized ...much like Access. Nonethless, you can connect using ODBC. Or check this out: http://www.easysoft.com/applications/openo...e_org/odbc.html



Good luck.

Hello sanjayws, thank you very much for your reply.

Btw, may i know, what's the difference using your suggested server based solution and the one i'm currently have now?

In my case, i understand the database is using Access, how about the user interface? How do i make one? Any software to make the user interface (that later on can be connect to the base database)?

Thank you in advance

You can use ASP or .Net to connect to Access database couple with html and css for interface, it has been quite reliable has been used by many web application since early year 2000 till now. However, you will have to master html,css and ASP/.Net. If u r serious into this, straight go to .Net platform, for a quick and dirty starting you might like to check out ASP, as the coding is in VBscript, close relative of VBA used in Access I presumed you could pick up faster. As for editor, check out Visual Interdev for serious web development else a plain vanila notepad will served you well. HTH

This post has been edited by goolias: Jan 16 2009, 05:04 PM

migrate to MS SQL express. It's free.

http://aspalliance.com/989_Migrating_Acces..._SQL_Server.all

Shouldn't be any problem for DB admins.

Dear guys, i'm not sure whether i've mislead you all in explaining about a web-based program.. I'm so sorry..

What i meant was, my company is using a program (with .exe extension). The program itself connect to the access database which is placed in the main server.

My question is, may anyone can advise me on how to create a program which later on be install in each individual pc in my office and be able to connect to the Base database (instead of Access) which will be placed at the main server.

I hope i'm not confusing you all. I apologise if i did..

A million thanks in advance guys

yes, it's possible. Access does support client-server infrastructure, you can placed the mdb file in server, and create a shortcut at user desktop.
You should also look into create a mdw file that cater for the multi user access, by default first user who open the mdb file locks the database whihc cause other user can't open again. a mdw file resolve this but letting others to be read only, sorta maintaining concurrent read access. As for concurrent write to mdb, I dun think Ms Access designed for that.

Hi,

You're prolly referring to 32bit desktop apps?

Well, there are tons of development languages you can use, e.g. Visual Basic, Java or even Flash ...ODBC is the underlying standards based protocol used to connect front end editors/clients to a back end database, much like the straw between your mouth and the juicy soda...

J

Thank you very much people