Hi everyone
Pls let me introduce myself. I'm Dean, an IT professional with more than 25 years in the industry.
What I'm after is help from this community. But, it's controversial, because some might think like an intruder or something
So, what we made is an automated Access to Web converter, based on Jam.py. What it does is automated conversion to sqlite3 (for now), moving data to sqlite3, and than one builds the App from it as Forms. Beautiful Forms and really fast. Doing Forms is simple. It can also be automated, however, than one would minimise the learning path which is not steep anyway.
I know you'll be jumping off chairs guys with "what will happen with my VBA?" Nothing. It won't happen. But the crazy thought is can that be moved in a reasonable time to Python for backhand, and JS for FrontEnd? Like, how much VB is there? What does it do? Did you already move some stuff from Access to SQLServer? If so, Jam.py fully supports SQLServer, so there you go. Solved. We "fire" the stored procedure from Jam just like any other event.
Because Jam is an Event Driven architecture. Which means everything is accessed by the API. In Access, the Button can run a code after single click. Same in Jam, that is called an Event there.
Reports are designed similar to Access. It takes like 30 mins to design a Template, and than some time to develop an Event which "fires" server-side Python procedure. An Event looks like this for a button:
function on_before_print_report(report) {
report.id.value = report.task.invoices.id.value;
}
Here we take the invoice ID from the table and pass it to report. Server side report than consumes it (30 lines of Python code or so), and produces the content.
So there you go. Super short intro.
As mentioned in a thread "Migrate Access DB to browser-based on local network" Jam is Rapid Application Development. Can it be used in parallel with Access, sharing the same database? Yes. They are even hoping to make it talk directly with local Access db, over odbc. On Windows of course.
What I'm after is some thoughts about this! Is it worth pursuing the idea of automated conversion?
Cheers
PS
Pic showing Forms and report. Everything seen on Forms is no-code, no programming at all. WYSISYG. The code is needed for report, custom authentication, obviously custom buttons (which this on the pics are not), etc. Like email sending, it's custom code.
The link on the pics is accessible.
Pls let me introduce myself. I'm Dean, an IT professional with more than 25 years in the industry.
What I'm after is help from this community. But, it's controversial, because some might think like an intruder or something
So, what we made is an automated Access to Web converter, based on Jam.py. What it does is automated conversion to sqlite3 (for now), moving data to sqlite3, and than one builds the App from it as Forms. Beautiful Forms and really fast. Doing Forms is simple. It can also be automated, however, than one would minimise the learning path which is not steep anyway.
I know you'll be jumping off chairs guys with "what will happen with my VBA?" Nothing. It won't happen. But the crazy thought is can that be moved in a reasonable time to Python for backhand, and JS for FrontEnd? Like, how much VB is there? What does it do? Did you already move some stuff from Access to SQLServer? If so, Jam.py fully supports SQLServer, so there you go. Solved. We "fire" the stored procedure from Jam just like any other event.
Because Jam is an Event Driven architecture. Which means everything is accessed by the API. In Access, the Button can run a code after single click. Same in Jam, that is called an Event there.
Reports are designed similar to Access. It takes like 30 mins to design a Template, and than some time to develop an Event which "fires" server-side Python procedure. An Event looks like this for a button:
function on_before_print_report(report) {
report.id.value = report.task.invoices.id.value;
}
Here we take the invoice ID from the table and pass it to report. Server side report than consumes it (30 lines of Python code or so), and produces the content.
So there you go. Super short intro.
As mentioned in a thread "Migrate Access DB to browser-based on local network" Jam is Rapid Application Development. Can it be used in parallel with Access, sharing the same database? Yes. They are even hoping to make it talk directly with local Access db, over odbc. On Windows of course.
What I'm after is some thoughts about this! Is it worth pursuing the idea of automated conversion?
Cheers
PS
Pic showing Forms and report. Everything seen on Forms is no-code, no programming at all. WYSISYG. The code is needed for report, custom authentication, obviously custom buttons (which this on the pics are not), etc. Like email sending, it's custom code.
The link on the pics is accessible.
Attachments
Last edited: