Running MS Access Programs
- by fredhappier
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:
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.
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