Can we use mdb file without Access installed

[momen]

Hi

i finished a simple computer store management system using access 2003.

i found some one wants to buy it but he doesn't have MS Access installed on his computer.

is there a way to export or convert the mdb file to another extension that can run on his computer.

Can I use Mysql to run this database from his computer ( I guess that it is free open source system ) and I found some software that convert MS Access to Mysql.

Any suggestions?

Thanks

 

[mp9]

You need Office Developer rather than Office so that you can ship your database with the Access runtime files that your non-Access user would need to use the MDB.

http://www22.brinkster.com/accessory/

 

[lupins46]

The cheapest solution will be for your customer to buy a copy of Access.

MySQL will give you free tables but what are you going to do about the rest of the application?

 

[momen]

Thanks for your replies

I will try to put in order what I thought that I could do, and I hope that you can give me some of your experience:

1- Creating management system using Access.
2- Using bar code to create ID for each item ( still looking for any solution on this point and if you can give me your point of view I will be thankful )
3- Giving the client a proposal that I can create a dynamic web site using this database ( to display and search items at the beginning )
4- I thought that using any software to convert the mdb to Mysql could help.
5- I am starting to learn all about creating dynamic web pages so I hope that I am walking in the right track.

Please give me some of your experience about what I intend to do .


Thank you

 

[wdverner]

Momen certainly the easiest way would be to create a run time version of the DB as someone has already suggested. He can then have use of the DB on his machine without Access bing installed as it will install all the necessary run time files.

 

[willybgw]

Do a search for msaccess.exe on the computer you want your program to run on.

All of the computers in our office run Office 2000 Small Business Edition. There are 2 disks, and if the second disk is installed an access runtime will be there. I don't know about other versions.

willybgw

 

[abaldwin]

I would suggest that you look at writing the application in VB or some other programming language and use the database only to store the application.

It appears that the data will grow dramatically at least from the point of view of where the data will be used.

I have never liked using access as the application developement platform.

Just my $.025



Andy Baldwin

 

[alvechurchdata]

I have never liked using access as the application developement platform.

Access is a great development tool but distribution can be a real pain because it's so tightly dependent on Office. I'd agree that VB or VFP are much better if you've got to distribute and support the application on a lot of PCs.

Geoff Franklin

http://www.alvechurchdata.co.uk