We have been developing in MS Access/VBA for nearly 10 years now and find we
need to get with the times and look at a web type of front end to a more
robust/multi user back end.
I would be interested to here any thoughts on which way we should go. We
currently have an IT Help Desk application that we need to duplicate in new
technology (example at http:jackaroo.net.au) which needs to be able to have
many users eg Corp wide and to handle say 50,000 records. Cost to the client
is a main concern hence why we used Access but we are now thinking possibly
MySQL or ????? (any thoughts) and say a HTML front end created with
Macromedia Flash or ?????? (any thoughts).
Thanks for your thoughts.
--
Regards
Ian Baker
Jackaroo Developments Pty Ltd
(Download Jackaroo IT - IT Mgmt and Help Desk application at http://jackaroo.net.au) 6  2448 
I too came from the Access/VBA world and changed quite happily to Web based,
mysql based world.
Here's what I'd do. I'm Linux savvy but basic plan should also work on
Windows.
Load Linux on a box (an old slow one is ok say 200+mhz, 64+ram)
Install PHP4, MySQL, Apache (language, sql, webserver)
Access databases can export to Mysql via ODBC (a separate step).
Then write PHP4 code, running from the Web server, and accessing MySql.
The queries against 50K records should be a piece of cake for
Linux/Mysql/PHP.
That's my initial thoughts with no more details then this to start.
dp
"Ian Baker" <ia*@REMOVE-CAPITALS-FOR-EMAILjackaroo.net.au> wrote in message
news:3f**********************@news.optusnet.com.au ... We have been developing in MS Access/VBA for nearly 10 years now and find
we need to get with the times and look at a web type of front end to a more
robust/multi user back end.
I would be interested to here any thoughts on which way we should go. We
currently have an IT Help Desk application that we need to duplicate in
new technology (example at http:jackaroo.net.au) which needs to be able to
have many users eg Corp wide and to handle say 50,000 records. Cost to the
client is a main concern hence why we used Access but we are now thinking
possibly MySQL or ????? (any thoughts) and say a HTML front end created with
Macromedia Flash or ?????? (any thoughts).
Thanks for your thoughts.
--
Regards
Ian Baker
Jackaroo Developments Pty Ltd
(Download Jackaroo IT - IT Mgmt and Help Desk application at
http://jackaroo.net.au)
I too came from the Access/VBA world and changed quite happily to Web based,
mysql based world.
Here's what I'd do. I'm Linux savvy but basic plan should also work on
Windows.
Load Linux on a box (an old slow one is ok say 200+mhz, 64+ram)
Install PHP4, MySQL, Apache (language, sql, webserver)
Access databases can export to Mysql via ODBC (a separate step).
Then write PHP4 code, running from the Web server, and accessing MySql.
The queries against 50K records should be a piece of cake for
Linux/Mysql/PHP.
That's my initial thoughts with no more details then this to start.
dp
"Ian Baker" <ia*@REMOVE-CAPITALS-FOR-EMAILjackaroo.net.au> wrote in message
news:3f**********************@news.optusnet.com.au ... We have been developing in MS Access/VBA for nearly 10 years now and find
we need to get with the times and look at a web type of front end to a more
robust/multi user back end.
I would be interested to here any thoughts on which way we should go. We
currently have an IT Help Desk application that we need to duplicate in
new technology (example at http:jackaroo.net.au) which needs to be able to
have many users eg Corp wide and to handle say 50,000 records. Cost to the
client is a main concern hence why we used Access but we are now thinking
possibly MySQL or ????? (any thoughts) and say a HTML front end created with
Macromedia Flash or ?????? (any thoughts).
Thanks for your thoughts.
--
Regards
Ian Baker
Jackaroo Developments Pty Ltd
(Download Jackaroo IT - IT Mgmt and Help Desk application at
http://jackaroo.net.au)
D. Pickering
Thanks for your input. I have spent the last couple of days looking into all
of this and I believe the way for us to go with our Help Desk app is ASP.NET
using VBScript as the front end and for now stay with Jet as the backend
simply because it is free (via MSOffice Developer). Once we have got our
heads around the learning curve for the front end which I feel will take a
year or so to develop a robust and proven app we will probably look at MySQL
as the backend. SQLServer would be far to costly for our clients (50 to 250
employee sized organisations) and MSDE wouldn't work as there will probably
be up to 10 normal help desk people as concurrent users and with a light
version on all employees desktops accessing the db to log/view their own
help desk calls the strain will probably be to much
Does this sound fair and reasonable to you?
Thanks again
--
Regards
Ian Baker
Jackaroo Developments Pty Ltd
(Download Jackaroo IT - IT Mgmt and Help Desk application at http://jackaroo.net.au)
"D. Pickering" <dc*****@hps.com> wrote in message
news:w8*********************@newssvr30.news.prodig y.com... I too came from the Access/VBA world and changed quite happily to Web
based, mysql based world.
Here's what I'd do. I'm Linux savvy but basic plan should also work on
Windows.
Load Linux on a box (an old slow one is ok say 200+mhz, 64+ram)
Install PHP4, MySQL, Apache (language, sql, webserver)
Access databases can export to Mysql via ODBC (a separate step).
Then write PHP4 code, running from the Web server, and accessing MySql.
The queries against 50K records should be a piece of cake for
Linux/Mysql/PHP.
That's my initial thoughts with no more details then this to start.
dp
"Ian Baker" <ia*@REMOVE-CAPITALS-FOR-EMAILjackaroo.net.au> wrote in
message news:3f**********************@news.optusnet.com.au ... We have been developing in MS Access/VBA for nearly 10 years now and
find we need to get with the times and look at a web type of front end to a more
robust/multi user back end.
I would be interested to here any thoughts on which way we should go. We
currently have an IT Help Desk application that we need to duplicate in
new technology (example at http:jackaroo.net.au) which needs to be able to
have many users eg Corp wide and to handle say 50,000 records. Cost to the
client is a main concern hence why we used Access but we are now thinking
possibly MySQL or ????? (any thoughts) and say a HTML front end created with
Macromedia Flash or ?????? (any thoughts).
Thanks for your thoughts.
--
Regards
Ian Baker
Jackaroo Developments Pty Ltd
(Download Jackaroo IT - IT Mgmt and Help Desk application at
http://jackaroo.net.au)
D. Pickering
Thanks for your input. I have spent the last couple of days looking into all
of this and I believe the way for us to go with our Help Desk app is ASP.NET
using VBScript as the front end and for now stay with Jet as the backend
simply because it is free (via MSOffice Developer). Once we have got our
heads around the learning curve for the front end which I feel will take a
year or so to develop a robust and proven app we will probably look at MySQL
as the backend. SQLServer would be far to costly for our clients (50 to 250
employee sized organisations) and MSDE wouldn't work as there will probably
be up to 10 normal help desk people as concurrent users and with a light
version on all employees desktops accessing the db to log/view their own
help desk calls the strain will probably be to much
Does this sound fair and reasonable to you?
Thanks again
--
Regards
Ian Baker
Jackaroo Developments Pty Ltd
(Download Jackaroo IT - IT Mgmt and Help Desk application at http://jackaroo.net.au)
"D. Pickering" <dc*****@hps.com> wrote in message
news:w8*********************@newssvr30.news.prodig y.com... I too came from the Access/VBA world and changed quite happily to Web
based, mysql based world.
Here's what I'd do. I'm Linux savvy but basic plan should also work on
Windows.
Load Linux on a box (an old slow one is ok say 200+mhz, 64+ram)
Install PHP4, MySQL, Apache (language, sql, webserver)
Access databases can export to Mysql via ODBC (a separate step).
Then write PHP4 code, running from the Web server, and accessing MySql.
The queries against 50K records should be a piece of cake for
Linux/Mysql/PHP.
That's my initial thoughts with no more details then this to start.
dp
"Ian Baker" <ia*@REMOVE-CAPITALS-FOR-EMAILjackaroo.net.au> wrote in
message news:3f**********************@news.optusnet.com.au ... We have been developing in MS Access/VBA for nearly 10 years now and
find we need to get with the times and look at a web type of front end to a more
robust/multi user back end.
I would be interested to here any thoughts on which way we should go. We
currently have an IT Help Desk application that we need to duplicate in
new technology (example at http:jackaroo.net.au) which needs to be able to
have many users eg Corp wide and to handle say 50,000 records. Cost to the
client is a main concern hence why we used Access but we are now thinking
possibly MySQL or ????? (any thoughts) and say a HTML front end created with
Macromedia Flash or ?????? (any thoughts).
Thanks for your thoughts.
--
Regards
Ian Baker
Jackaroo Developments Pty Ltd
(Download Jackaroo IT - IT Mgmt and Help Desk application at
http://jackaroo.net.au)
"Ian Baker" <ia*@REMOVE-CAPITALS-FOR-EMAILjackaroo.net.au> wrote in message
news:3f***********************@news.optusnet.com.a u... D. Pickering
Thanks for your input. I have spent the last couple of days looking into
all of this and I believe the way for us to go with our Help Desk app is
ASP.NET using VBScript as the front end and for now stay with Jet as the backend
simply because it is free (via MSOffice Developer). Once we have got our
heads around the learning curve for the front end which I feel will take a
year or so to develop a robust and proven app we will probably look at
MySQL as the backend....
If you're going through the redevelopment process, I'd suggest going ahead
and do the jump to the new backend at the same time. As there are SQL-syntax
differences, field type differences, etc, the front-end will need some
coding and testing specific to the database backend, and so to me it makes
sense to re-code and test both ends at the same time.
Ray Gurganus www.citidc.com
"Ian Baker" <ia*@REMOVE-CAPITALS-FOR-EMAILjackaroo.net.au> wrote in message
news:3f***********************@news.optusnet.com.a u... D. Pickering
Thanks for your input. I have spent the last couple of days looking into
all of this and I believe the way for us to go with our Help Desk app is
ASP.NET using VBScript as the front end and for now stay with Jet as the backend
simply because it is free (via MSOffice Developer). Once we have got our
heads around the learning curve for the front end which I feel will take a
year or so to develop a robust and proven app we will probably look at
MySQL as the backend....
If you're going through the redevelopment process, I'd suggest going ahead
and do the jump to the new backend at the same time. As there are SQL-syntax
differences, field type differences, etc, the front-end will need some
coding and testing specific to the database backend, and so to me it makes
sense to re-code and test both ends at the same time.
Ray Gurganus www.citidc.com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Corey Burnett |
last post by:
I have a client that has a split database (front-end/back-end). They
are also using Access security - MDW file. The front end MDE file,
the back end MDB file, and the MDW file are all located on...
|
by: http://vmdd.tech.mylinuxisp.com/catalog/ |
last post by:
After having seen my co-worker reinventing the wheel
when he busily labored to build MS Access framework, I want to share
my perspective.
Having experienced with Access, Visual Basic, Visual...
|
by: rdemyan via AccessMonster.com |
last post by:
I'm thinking about providing a relatively easy method for users to restore
the front end from a backup. The purpose is to allow for restoring if the
front end becomes corrupt.
Here are some...
|
by: rdemyan via AccessMonster.com |
last post by:
I have code in my front end that opens a form for backing up the front end.
I'll give a brief description of what the form does:
1) When the backup form opens, it closes all open forms except for...
|
by: sara |
last post by:
Very strange behavior, but I suspect some is A2K and some might be for
me to correct. Just trying to see if anyone can help and advise.
We have a database that's been running for a few years...
|
by: Max Vit |
last post by:
I have deployed few Access apps splitting it in Front End and Back
End. Our environment uses Win XP SP2 for clients, Win 2k3 for servers
and Access 2003. The max. number of clients is about 50...
|
by: z060053 |
last post by:
#include <iostream>
using namespace std;
template <class T>class list{
protected:
typedef struct node{
node* prev;
T* data;
node* next;
};
node* first;
|
by: Brian Nelson |
last post by:
Sorry for the long post, I've tried so hard to solve this one but I'm
just stuck!
We've had a multiuser .mdb file on a network share for years. I know
it's not ideal, but it's worked well from...
|
by: gskbond |
last post by:
Below is the node for m way tree
class Node
{
public: Node(int imway);
~Node();
int noofKeys;
int *keys;
Node **childPointer;
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |
