473,218 Members | 1,824 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,218 software developers and data experts.

Tool to export MS Access forms, queries, tables, and (eventually) code

Looking to see how many people could use this kind of tool.

I've got several large databases I've developed in Access with MySQL as
the back-end.
I've started using Linux instead of windows and the only thing I can't
migrate is my Access databases.

I'm looking to export them in a standard file format, then provide
convert functionality into SWT, Flash, HTML, Native and/or some other
formats.

The other benefit would be the users would no longer need Access
installed to use the databases.

If you are interested in this kind of a tool, please reply here.

Thank you!

Jul 3 '06 #1
7 3230
<dt*********@gmail.comwrote
Looking to see how many people
could use this kind of tool.

I've got several large databases I've
developed in Access with MySQL as
the back-end.
I've started using Linux instead of
Windows and the only thing I can't
migrate is my Access databases.

I'm looking to export them in a standard file format, then provide
convert functionality into SWT, Flash, HTML, Native and/or some other
formats.
As I don't believe any of the tools you list even remotely could be
considered comparable to Access, I think you'd find "conversion" rather
difficult. If you are going to convert, it's probably going to have to be in
one of the progamming languages than Linux supports, e. g., C, Java, Perl,
PHP, Ruby, Kylix, etc.. There's just no comparable development tool to
Access in that world, AFAICT.
Jul 4 '06 #2
On Tue, 04 Jul 2006 02:27:52 GMT, "Larry Linson"
<bo*****@localhost.notwrote:

And before you think "I'll EVENTUALLY tackle the code", consider how
few applications run without code.
And before you think "My tool still does x% of the work even without
code conversion", consider that most potential users of such product
are not coders, so they'll see little value in a product that doesn't
take them all the way. Just talk to MSFT about the success (ahem) of
their VB6 to VB.NET conversion tool...

-Tom.
><dt*********@gmail.comwrote
Looking to see how many people
could use this kind of tool.

I've got several large databases I've
developed in Access with MySQL as
the back-end.
I've started using Linux instead of
Windows and the only thing I can't
migrate is my Access databases.

I'm looking to export them in a standard file format, then provide
convert functionality into SWT, Flash, HTML, Native and/or some other
formats.

As I don't believe any of the tools you list even remotely could be
considered comparable to Access, I think you'd find "conversion" rather
difficult. If you are going to convert, it's probably going to have to be in
one of the progamming languages than Linux supports, e. g., C, Java, Perl,
PHP, Ruby, Kylix, etc.. There's just no comparable development tool to
Access in that world, AFAICT.
Jul 4 '06 #3

Larry Linson wrote:
<dt*********@gmail.comwrote
Looking to see how many people
could use this kind of tool.
>
I've got several large databases I've
developed in Access with MySQL as
the back-end.
I've started using Linux instead of
Windows and the only thing I can't
migrate is my Access databases.
>
I'm looking to export them in a standard file format, then provide
convert functionality into SWT, Flash, HTML, Native and/or some other
formats.

As I don't believe any of the tools you list even remotely could be
considered comparable to Access, I think you'd find "conversion" rather
difficult. If you are going to convert, it's probably going to have to be in
one of the progamming languages than Linux supports, e. g., C, Java, Perl,
PHP, Ruby, Kylix, etc.. There's just no comparable development tool to
Access in that world, AFAICT.
Thankfully PureBasic works in Linux for the development of the tool and
SWT (used by Eclipse) is available to build the form GUI.

Most work would be in putting the two together. The idea isn't to
replace Access for the developer, but to provide a way to convert the
resulting front-end to a format end-users can use without having to use
windows and access.

Jul 4 '06 #4
You're right about the code part. It would be difficult to automate
that conversion as the GUI objects would be accessed differently than
the Access form objects. It's not an impossible conversion though.
This seems like one of those ideas that is 90% doable, but the
remaining 10% would break the success.

Tom van Stiphout wrote:
On Tue, 04 Jul 2006 02:27:52 GMT, "Larry Linson"
<bo*****@localhost.notwrote:

And before you think "I'll EVENTUALLY tackle the code", consider how
few applications run without code.
And before you think "My tool still does x% of the work even without
code conversion", consider that most potential users of such product
are not coders, so they'll see little value in a product that doesn't
take them all the way. Just talk to MSFT about the success (ahem) of
their VB6 to VB.NET conversion tool...

-Tom.
<dt*********@gmail.comwrote
Looking to see how many people
could use this kind of tool.
>
I've got several large databases I've
developed in Access with MySQL as
the back-end.
I've started using Linux instead of
Windows and the only thing I can't
migrate is my Access databases.
>
I'm looking to export them in a standard file format, then provide
convert functionality into SWT, Flash, HTML, Native and/or some other
formats.
As I don't believe any of the tools you list even remotely could be
considered comparable to Access, I think you'd find "conversion" rather
difficult. If you are going to convert, it's probably going to have to be in
one of the progamming languages than Linux supports, e. g., C, Java, Perl,
PHP, Ruby, Kylix, etc.. There's just no comparable development tool to
Access in that world, AFAICT.
Jul 4 '06 #5
"DTecMeister" wrote
Thankfully PureBasic works in Linux
for the development of the tool and
SWT (used by Eclipse) is available to
build the form GUI.
IIRC, PureBasic is a classic Basic that generates "programs"... may be fine
for the tool. Even in end-user-created applications, there's a lot of VBA
"snippets" that execute on events, such as OnFormOpen, OnFormClose,
BeforeUpdate... merging that with the Forms in a "classic Basic program" is
going to take a lot of work, even if PureBasic has the necessary
functionality.
Most work would be in putting the
two together. The idea isn't to
replace Access for the developer, but
to provide a way to convert the
resulting front-end to a format end-users
can use without having to use
windows and access.
Oohwee, if you want to re-create just the end-user user interface, remember
there are more person-hours in Access than you really want to count. They
have development _teams_ at Microsoft, and often they are not small ones --
also remember that each of those teams had a year or more to work on their
target release. So, there's a lot of "catching up" to do.

If you find a tool, or if you build one, I hope you will report here,
because we get questions regularly (though not in large quantities), about
Access on other platforms, or "equivalent DB software" on other platforms.

Larry Linson
Microsoft Access MVP
Jul 4 '06 #6
I agree with all your comments here Larry. Thanks for the quick reply.
It looks like it may be wise (if the decision is to procede) to
develop the equivalent DB software first then worry about the
conversion process.

Larry Linson wrote:
"DTecMeister" wrote
Thankfully PureBasic works in Linux
for the development of the tool and
SWT (used by Eclipse) is available to
build the form GUI.

IIRC, PureBasic is a classic Basic that generates "programs"... may be fine
for the tool. Even in end-user-created applications, there's a lot of VBA
"snippets" that execute on events, such as OnFormOpen, OnFormClose,
BeforeUpdate... merging that with the Forms in a "classic Basic program" is
going to take a lot of work, even if PureBasic has the necessary
functionality.
Most work would be in putting the
two together. The idea isn't to
replace Access for the developer, but
to provide a way to convert the
resulting front-end to a format end-users
can use without having to use
windows and access.

Oohwee, if you want to re-create just the end-user user interface, remember
there are more person-hours in Access than you really want to count. They
have development _teams_ at Microsoft, and often they are not small ones --
also remember that each of those teams had a year or more to work on their
target release. So, there's a lot of "catching up" to do.

If you find a tool, or if you build one, I hope you will report here,
because we get questions regularly (though not in large quantities), about
Access on other platforms, or "equivalent DB software" on other platforms.

Larry Linson
Microsoft Access MVP
Jul 4 '06 #7
Access forms expose one extra set of properties, the
properties shown on the properties form as 'events',
which expose the links between the UI object and the
code object.

Why is using active x objects so painful with Access?
Because they don't expose 'event' properties for their
methods, their methods don't show up on the Access property
sheet. Instead, you have to go into VBA to find the methods,
and use VBA code to link the event source to the event sink
for each method/event.

Although another tool will not necessarily have an 'event'
property (Delphi does), any set of tools that produce com
interfaces will allow you to match up event sources and
event sinks.

A translation utility doesn't have to expose the link in
a property sheet.

The same considerations apply if you use another object
interface instead of com.

(david)

"Larry Linson" <bo*****@localhost.notwrote in message
news:dunqg.7052$0G2.5778@trnddc07...
"DTecMeister" wrote
Thankfully PureBasic works in Linux
for the development of the tool and
SWT (used by Eclipse) is available to
build the form GUI.

IIRC, PureBasic is a classic Basic that generates "programs"... may be
fine for the tool. Even in end-user-created applications, there's a lot
of VBA "snippets" that execute on events, such as OnFormOpen, OnFormClose,
BeforeUpdate... merging that with the Forms in a "classic Basic program"
is going to take a lot of work, even if PureBasic has the necessary
functionality.
Most work would be in putting the
two together. The idea isn't to
replace Access for the developer, but
to provide a way to convert the
resulting front-end to a format end-users
can use without having to use
windows and access.

Oohwee, if you want to re-create just the end-user user interface,
remember there are more person-hours in Access than you really want to
count. They have development _teams_ at Microsoft, and often they are not
small ones -- also remember that each of those teams had a year or more
to work on their target release. So, there's a lot of "catching up" to
do.

If you find a tool, or if you build one, I hope you will report here,
because we get questions regularly (though not in large quantities), about
Access on other platforms, or "equivalent DB software" on other platforms.

Larry Linson
Microsoft Access MVP

Jul 4 '06 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: intl04 | last post by:
How do I create a data input form in Access that is external to the Access database to which it's connected (if that's possible, which I believe it is)? For example, if someone clicks on an Access...
2
by: Jonathan LaRosa | last post by:
Hi all - I'm wondering if anyone has (or knows of) a tool that will allow me to search through VB code, tables, queries, reports, forms, and other objects, for references to all other types of...
6
by: Kenneth Courville | last post by:
Hello, I'm looking for assistance with the Access object model. I know this is VB, but I'm building an Office Add-using C# directed at Access 2002. I'm literate in VB, so you can reply in VB... I...
3
by: Eric Ellsworth | last post by:
Hi all, Does anyone have any bright ideas for Access' tendency to add square brackets when it parses queries, then tell you that the query syntax is invalid. In my case, I'm trying to do a LEFT...
49
by: Yannick Turgeon | last post by:
Hello, We are in the process of examining our current main application. We have to do some major changes and, in the process, are questionning/validating the use of MS Access as front-end. The...
1
by: smaczylo | last post by:
Hello, I've recently been asked to work with Microsoft Access, and while I feel quite comfortable with Excel, I'm at a complete loss with databases. If someone could help me with this issue I'm...
2
by: MyEmailList | last post by:
We have an Access data base with severl tables, queries and forms. We want to put it on the web. Is there a tool that will convert the Access queries and forms to ASP? Sorta like "splitting"...
3
by: jmarcrum | last post by:
I want to export a report (that contains two separate queries, 1. Current year data, and 2. split-year data) from access into excel, but everytime I run my code and export the data to excel, it looks...
17
by: chadh | last post by:
Hello, I'm having some troubles exporting a query to a csv file. I am able to use the doCMD.TransferText to output the query to the csv file, however, I cannot get it to use the Export...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.