Book a Demo

Author Topic: Import Access source code  (Read 3847 times)

Fintan

  • EA User
  • **
  • Posts: 28
  • Karma: +0/-0
    • View Profile
Import Access source code
« on: February 26, 2003, 07:53:27 am »
Hi there,

I have an Access application that I need to analyse (Original programmer has retired - no documentation) in order to be able to maintain the code.

I used EA to import the table definitions.

My question is this - Can I import the code - logic in modules and queries similar to how I would import VB code?

Many thanks for your help,

Fintan

Andrew_Webster

  • EA User
  • **
  • Posts: 31
  • Karma: +0/-0
  • Keep It Simple Stupid!
    • View Profile
Re: Import Access source code
« Reply #1 on: February 26, 2003, 04:23:01 pm »
I've been working with EA on an Access project solidly for the last couple of weeks, and I've really put it through its paces.

As far as I can tell, there is no way to directly import and analyse code from Access.  I would imagine that this is because code within Access isn't stored in external text files, like most other development environments, but is tucked away within Access's own format.

I've written a couple of tools to analyze and play around with code in Access code module, and its not difficult, but it's a fiddle, so I imagine Sparx have decided to come back to it!

It's certainly something that would help me as well, so I might just put it in as a feature request - I'd suggest that you do as well.

In the meantime, although synchronization will be a fiddle, you could try to 'Save As Text' the code modules in your Access project, then have a go at getting EA to import them as if they were VB.  I'm making this up as I go along, but it sounds right.  WHen I get a moment, I'll try it.  Let me know if you have any success yourself.

All the best

Andrew Webster