I had a consultant develop a web-page reporting system for me, and
last week I sat down and reviewed the undelying code. I have never
seen something so complex for a system so simple.
The system, basically requires a user to login, and based on their
login, generates a list of PDF files that they can click and review.
The information required to generate the list is kept in an Access
database. The site is an SSL secured site (https),
Ok, it is not that simple, since the information is grouped, and
actually there are two type of lists that are generated. The database
is relationship, and includes several one to many relations, and a
many to many relationship using a third table. But, this is a type of
application that can be developed by an experience developer in Access
in a day or so.
The web application is done in VB.Net, using ASP.Net for database
access, and some JavaScript for client side processing (minimal). The
code is all over the place.
Eventually, given volume, we may move the data to a SQL server (but
MySQL would be more than adequate). Given the very limited display on
the site, moving the system to another environment should not be too
difficult.
Curious to know what other peoples experience have been moving basic
Access database applications to the Web. Is there better tools than
this .Net stuff?
Steven R. Zuch
Cogent Management inc. 1 1263
On Sat, 20 Nov 2004 16:23:39 GMT, st***@nospam.co m (Steve) wrote:
Keep in mind that a considerable portion of the code you saw was
generated by Visual Studio, not by your developer.
-Tom. I had a consultant develop a web-page reporting system for me, and last week I sat down and reviewed the undelying code. I have never seen something so complex for a system so simple.
The system, basically requires a user to login, and based on their login, generates a list of PDF files that they can click and review. The information required to generate the list is kept in an Access database. The site is an SSL secured site (https),
Ok, it is not that simple, since the information is grouped, and actually there are two type of lists that are generated. The database is relationship, and includes several one to many relations, and a many to many relationship using a third table. But, this is a type of application that can be developed by an experience developer in Access in a day or so.
The web application is done in VB.Net, using ASP.Net for database access, and some JavaScript for client side processing (minimal). The code is all over the place.
Eventually, given volume, we may move the data to a SQL server (but MySQL would be more than adequate). Given the very limited display on the site, moving the system to another environment should not be too difficult.
Curious to know what other peoples experience have been moving basic Access database applications to the Web. Is there better tools than this .Net stuff?
Steven R. Zuch Cogent Management inc. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Manolis |
last post by:
Hi,
I was wondering if there is any way to make two objects of the same
class to be able to access each other's private data, like this:
class A {
public:
void access( const A& a ) {cout<<"a.value="<<a.value<<endl; }
private:
int value;
|
by: John |
last post by:
Hi,
I've recently upgraded from Access 97 to Access 2002 & the performance
basically stinks. I have tried the following items listed below but it
has only had a minor impact:
1) Upgraded Jet 4 to Service Pack 7
2) Set Subdatasheet Name to from
3) Shortened the file name of the .MDB file
4) Made sure the Track name AutoCorrect info is off
|
by: edo |
last post by:
100 Day Analysis
Following is a summary of articles spanning a 100 day period,
beginning at 10 Sep 2003 06:41:30 GMT and ending at
19 Dec 2003 04:09:06 GMT.
Notes
=====
- A line in the body of a post is considered to be original if it
|
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 application is relatively big: around 200
tables, 200 forms and sub-forms, 150 queries and 150 repports, 5GB of data
(SQL Server 2000), 40 users.
I'm wondering what are the disadvantages of using Access as front-end? Other
that it's not...
|
by: Olav.NET |
last post by:
I am a .NET/C++ developer who is supposed to do some work with Access.
I do not know much about it except for the DB part.
Questions:
*1*
I am looking for INTENSIVE books to get quickly up to speed.
I like books with practical exercises, and also with test questions (like
cert books)
*2*
| |
by: ljubo lecic via AccessMonster.com |
last post by:
I am an experienced ORACLE software developer who
met ACCESS few months ago and I must say that ,so far,
I am delighted. I rapidly developed a few aplications
and everything is working extremly good.
Now, I am offered to develop something more complex.
And It must be done in ACCESS.I feel so comfortable in
ACCESS programming that I am about to accept the offer.But before my final
response I URGENTLY need some
advices and opinions from...
|
by: Jeffrey P via AccessMonster.com |
last post by:
Our IT guys are on a vendetta against MS Access (and Lotus Notes but they've
won that fight). What I can't understand is, what's the problem? Why does
IT hate MS Access so much.
I have tried to find out who it is that actually wants to get rid of it, but
I can't find anyone who will admit to trying to get rid of it. Nevertheless,
I'm always hearing about how their "phasing it out" or "getting rid of it".
Because no-one owns up I can't...
|
by: AnandaSim |
last post by:
I just had a google through this NG but have not seen mention of Erik
Rucker's blog entry and the new Jet:
http://blogs.msdn.com/access/archive/2005/10/05/477549.aspx
mentioned by Mike Gunderloy
http://www.larkware.com/dg4/TheDailyGrind726.html
Aside from the Sharepoint feature extension, amazing news.
|
by: PSN |
last post by:
Hi all ,,
I have a complex class which inturn contains several classses and
subclasses .. can some one give me an easy method to access the deep
most member variables (explained in the example below) .. However, i
have a much complex class with asmany as 6-7 subclasses ...
Please note that the names of the classes are completely different from
one another .. so we cannot form a uniform struncture of their titles
...
|
by: lesperancer |
last post by:
I've got an access97 reporting mdb that pulls data (77,000 rows) from a
sql server table into a local table to run reports
if the local table is part of the reporting MDB, the insert statement
(16 fields) takes less than 30secs, but because of db-bloat, I moved
the local table to a 2nd MDB
and per postings, this 2nd MDB is copied into a folder and linked as a
'temp' MDB every time I run my reporting mdb
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |