472,951 Members | 2,561 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Access Front End to MySQL Database for Reporting

I just had an outside company develop a small application using MySQL
and server side Java.

The application is OK (not great), and the reason for server side Java
was that I need to use the app on a WAN with slow connection speeds
(128K / 384K).

Obviously, I can't just Load Access on these clients and have them try
to bang on a central DB accross the WAN. The users would Lynch me.

However, to do the simplest changes takes several hours of programming
in the Java environment by the conultant. I don't believe they are
ripping me off, I just think the Java environment is much harder to
program in than using MS Access.

So, what I really want to do is develop further interface stuff in MS
Access, starting with new reports, and possibly replacing the Java code
comlpetely at some point.

Of couse I need to overcome the limitations of running Access on my
WAN.

I have a vague understanding that it might be doable with Widows
Terminal Services, but don't have experience with that. Also, someone
else told me to forget trying it with Active Server Pages.

Also, what if I wanted to give access to this from the internet itself?
(Not important, just curious)

Can anyone outline a few options? (or am I crazy to think I can have an
Access front end?)

Thanks,
Chuck

Jun 26 '06 #1
1 1783
Bri
Appelq wrote:
I just had an outside company develop a small application using MySQL
and server side Java.

The application is OK (not great), and the reason for server side Java
was that I need to use the app on a WAN with slow connection speeds
(128K / 384K).

Obviously, I can't just Load Access on these clients and have them try
to bang on a central DB accross the WAN. The users would Lynch me.

However, to do the simplest changes takes several hours of programming
in the Java environment by the conultant. I don't believe they are
ripping me off, I just think the Java environment is much harder to
program in than using MS Access.

So, what I really want to do is develop further interface stuff in MS
Access, starting with new reports, and possibly replacing the Java code
comlpetely at some point.

Of couse I need to overcome the limitations of running Access on my
WAN.

I have a vague understanding that it might be doable with Widows
Terminal Services, but don't have experience with that. Also, someone
else told me to forget trying it with Active Server Pages.

Also, what if I wanted to give access to this from the internet itself?
(Not important, just curious)

Can anyone outline a few options? (or am I crazy to think I can have an
Access front end?)


You should take a look at the MySQL site and their MyODBC driver. I have
an app where I connect an AC97 FE to a MySQL BE on a remote server. It
works, but you have to be careful that you craft your forms, reports and
queries to pull the minimum amount of data across the connection if you
want to have reasonable response. You can also use PassThrough queries
on the Access side or Views and SPs on the MySQL side to help with this.

--
Bri

Jun 28 '06 #2

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

Similar topics

9
by: Rich May | last post by:
Afternoon all, Apologies for cross-posting but as my query covers both Access and SQL Server I thought I'd send it both! I have inherited a project to migrate a fairly complex series of...
38
by: Remco Groot Beumer | last post by:
Hello, I'm trying to decide if the following situation would be workable: Generate an MS Access Front End (which will run localy on client computers), which will link to a DBMS (SQL server or...
13
by: bill | last post by:
I am trying to convince a client that dotNet is preferable to an Access project (ADP/ADE). This client currently has a large, pure Access MDB solution with 30+ users, which needs to be upgraded....
2
by: Murphy | last post by:
I am new to Linux and am migrating a SQL Server DB with an Access front end to MySQL and ? What options are available under Linux for development of a client front end without copious amounts of...
10
by: Mike | last post by:
I recently had a Microsoft Access 97 database corrupt on me. The setup is a split database (front end/back end) setup with about 10-15 users. This is the first corruption in something like a...
5
by: B1ackwater | last post by:
We've fooled around with Access a bit, but only using the single-user store-bought version. It seems to be a good database - versatile and infinitely programmable - and can apparently be used as a...
49
by: Mell via AccessMonster.com | last post by:
I created databases on Access 2003 and I want to deploy them to users. My code was also done using 2003. If they have Ms Access 2000 or higher, will they be able to use these dbs with all code,...
16
by: JoeW | last post by:
I'm utilizing a database that I created within MS Access within a program I've created in VB.NET. I am using the VB front end to navigate the information, but want to be able to print a report,...
10
by: Richard | last post by:
Hi folks, thanks for taking the time to read this (and hopefully point our where I'm going wrong). The scenario: I have a local Access2007 database which links in several read only mySql...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...

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.