Jump to content
Sign in to follow this  
Kevin Pledger

Converting Access to Filemaker 16

Recommended Posts

Hi All,

(Hopefully the right place to post)

Background

We have an engineering database that was built in Access, consisting of 3 seperate Access MDB, which are all linked. My immediate Manager is looking at if possible  converting this over to FM16, with the view of using this online for uses / contractors to login and update the information, seen as we already have other applications running on this platform, and also Access is not all that bright over WLAN.

With all the hype at present with FM pushing to convert users from Access to Filemaker, just how easy is this, because after all my research, this doesnt see to be a very easy conversion. I have come across some tools which can convert the table structures and retain the schema, BUT, the issue will be converting the existing VB code to FM Coding, as there are lot of Sub-Routines being called. 

I read this article by Wim Decorte called Filemaker vs Access, which was based on Filemaker 5.5 and Access 2002, so not sure how relevant that is now.

Any insight would be greatly appreciated as to whether persuing this conversion.

 

Kevin.

Share this post


Link to post
Share on other sites
Wim Decorte    455
5 hours ago, Kevin Pledger said:

I read this article by Wim Decorte called Filemaker vs Access, which was based on Filemaker 5.5 and Access 2002, so not sure how relevant that is now.

It's still relevant in all its conclusions (except that we a bunch of event triggers now in FM :)

You won't find any good conversion tools to convert your VBA code and forms into the FM equivalent.  So if you are looking for a quick conversion, there isn't.

My suggestion would be to start building the FM bit based on what you know the Access solution does, that allows you to make it do just what it needs to do and not carry over any deadwood.  If you are new to FM then find a good developer in your area that can mentor you and guide you through that process.  You'll find it very rewarding, frustrating at times but it is a quick learning curve.

Share this post


Link to post
Share on other sites
Lee Smith    147

This product, FmPro Migrator might be helpful.

Lee 

Share this post


Link to post
Share on other sites
2 hours ago, Wim Decorte said:

It's still relevant in all its conclusions (except that we a bunch of event triggers now in FM :)

You won't find any good conversion tools to convert your VBA code and forms into the FM equivalent.  So if you are looking for a quick conversion, there isn't.

My suggestion would be to start building the FM bit based on what you know the Access solution does, that allows you to make it do just what it needs to do and not carry over any deadwood.  If you are new to FM then find a good developer in your area that can mentor you and guide you through that process.  You'll find it very rewarding, frustrating at times but it is a quick learning curve.

Wim,

Appreciate the reply, and there are not many good developers for FM in my area Singapore and yes I am very new to FM.

12 minutes ago, Lee Smith said:

This product, FmPro Migrator might be helpful.

Lee 

Lee, 

I am aware of this program and have spoken with the Author, basically it will convert the schema and tables over, keep the relationships, but will tag the VB code and then its a matter of redoing it all line by line.

Appreciate the responses.

Kevin.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.