Running MS Access Programs

Posted by fredhappier on Ask Ubuntu See other posts from Ask Ubuntu or by fredhappier
Published on 2012-04-12T17:22:39Z Indexed on 2012/04/12 17:41 UTC
Read the original article Hit count: 173

Filed under:

I have an old program developed in MS Access and would like to convert it to Kexi somehow. The program on Windows is launched with Access.

Is there any way that Kexi can launch this program? I know my way around Ubuntu and the terminal, but not well versed on databases. Once you make something in Kexi how do you "run" it or "view" what you've made?

So far I am able to import the MDB file into Kexi and see all of the database data, but that is as far I have gone. The program was made by a relative years ago for my dad.

I myself am an Ubuntu only user for 6+ years now and have no intentions to touch Windows and am looking for a linux solution. My dad is also an Ubuntu user, hence why Im looking for a solution.

If Kexi cannot launch and run an MDB file, what else can I try? Anything browser based? Any tips or direction would be extremely helpful.

I spoke to my brother who originally made the program. I told him about Kexi and here is what he said. Does any of this make sense? Thanks.

This is how I would try to get them to work:

  1. Stand alone setup - after import, look for an option where you designate which form object you want to open upon startup. It might be in the tools tab in the picture below. After you save that change, it re-start it and it should work.

  2. Front end/back end setup - Do what I suggested for the stand alone setup to the > "front-end" MDB file. After you do that, put the other file (table MDB file) where you > want it to reside on the network. Now, open back up the "front end" file and look for > an option that will allow you to "connect" to those tables in the other file. It looks > like it could be in the "External data" tab in the picture below. For this setup, you > may need to do these two tasks in the reverse order I just mentioned.

Thanks!

Fred

© Ask Ubuntu or respective owner

Related posts about database