473,769 Members | 7,923 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Reservation system in Access?

Would you use Access to create a car rental reservation system? I would
think that the complexity of such a system would be better suited to a
procedural language like Visual Basic or C++. Your thoughts, please.

Robert
Nov 12 '05 #1
11 5230
Visual Basic for Applications is part of Access.
Development with VBA/Access is up to 3 times as fast as development in
Visual Basic where, after all, you're going to need some sort of database
storage, too.

HTH
- Turtle

"Robert" <pr**********@y ahoo.com> wrote in message
news:10******** *****@corp.supe rnews.com...
Would you use Access to create a car rental reservation system? I would
think that the complexity of such a system would be better suited to a
procedural language like Visual Basic or C++. Your thoughts, please.

Robert

Nov 12 '05 #2
On Sun, 15 Feb 2004 13:50:04 GMT, MacDermott wrote:
Visual Basic for Applications is part of Access.
Development with VBA/Access is up to 3 times as fast as development in
Visual Basic where, after all, you're going to need some sort of database
storage, too.

HTH
- Turtle

"Robert" <pr**********@y ahoo.com> wrote in message
news:10******** *****@corp.supe rnews.com...
Would you use Access to create a car rental reservation system? I would
think that the complexity of such a system would be better suited to a
procedural language like Visual Basic or C++. Your thoughts, please.

Robert


Nice thing about Access, is all the tools/requirements to drive a data
service are right there and automated for you. Most of the design tools
(controls etc.) in Access are specifically designed to run off of
tables/queries and handle all the connectivity for you. Even with all of
Access's faults, you're hard pressed to find a simpler environment with
the same functionality.

--
Mike Storr
veraccess.com
Nov 12 '05 #3
"Robert" <pr**********@y ahoo.com> wrote in
news:10******** *****@corp.supe rnews.com:
Would you use Access to create a car rental reservation system? I would
think that the complexity of such a system would be better suited to a
procedural language like Visual Basic or C++. Your thoughts, please.


The success of any application is 90% dependent on its developer and not on
the platform upon which it is developed.
There is probably no agreement about classifying VB and C++ as procedural.
Many call them Object Oriented. In the database world, I believe
"procedural " more commonly refers to X-Base languages such as those used in
DBase III, FoxBase and FoxPro (underneath).
If one is not experienced with and knowledgeable about these technologies one
is not likely to create any complex system successfully. It may be better to
search for an off-the-shelf solution.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)
Nov 12 '05 #4
That sounds like a database project to me. So use a database development
system. Like Access.

What makes you think it's 'complex'? IMHO the complexity of a system can't
be measured until you've done a great deal of work in analysis. And if it is
complex the chances are that the complexity is in the data structures -
tables and how they relate to each other. In which case a database
development system is what you need. Like Access.

Of course if it's very very complex then you probably need to program it
properly. In which case assembler is the obvious answer.<g>

As has been pointed out, won't this just be standard vertical market
software that somebody has already written?

Yours, Mike MacSween

"Robert" <pr**********@y ahoo.com> wrote in message
news:10******** *****@corp.supe rnews.com...
Would you use Access to create a car rental reservation system? I would
think that the complexity of such a system would be better suited to a
procedural language like Visual Basic or C++. Your thoughts, please.

Robert

Nov 12 '05 #5

"Mike MacSween" <mi************ ***********@bti nternet.com> wrote in message
news:40******** **************@ news.aaisp.net. uk...
That sounds like a database project to me. So use a database development
system. Like Access.

What makes you think it's 'complex'? IMHO the complexity of a system can't
be measured until you've done a great deal of work in analysis. And if it is complex the chances are that the complexity is in the data structures -
tables and how they relate to each other. In which case a database
development system is what you need. Like Access.

Of course if it's very very complex then you probably need to program it
properly. In which case assembler is the obvious answer.<g>

As has been pointed out, won't this just be standard vertical market
software that somebody has already written?

Yours, Mike MacSween

"Robert" <pr**********@y ahoo.com> wrote in message
news:10******** *****@corp.supe rnews.com...
Would you use Access to create a car rental reservation system? I would
think that the complexity of such a system would be better suited to a
procedural language like Visual Basic or C++. Your thoughts, please.

Robert



A previous poster evidently hasn't found any!
Robert
Nov 12 '05 #6

"Mike Storr" <st******@sympa tico.ca> wrote in message
news:1s******** *************** ******@40tude.n et...
On Sun, 15 Feb 2004 13:50:04 GMT, MacDermott wrote:
Visual Basic for Applications is part of Access.
Development with VBA/Access is up to 3 times as fast as development in
Visual Basic where, after all, you're going to need some sort of database storage, too.

HTH
- Turtle

"Robert" <pr**********@y ahoo.com> wrote in message
news:10******** *****@corp.supe rnews.com...
Would you use Access to create a car rental reservation system? I would think that the complexity of such a system would be better suited to a
procedural language like Visual Basic or C++. Your thoughts, please.

Robert


Nice thing about Access, is all the tools/requirements to drive a data
service are right there and automated for you. Most of the design tools
(controls etc.) in Access are specifically designed to run off of
tables/queries and handle all the connectivity for you. Even with all of
Access's faults, you're hard pressed to find a simpler environment with
the same functionality.

--
Mike Storr
veraccess.com


Then why does anyone use Visual Basic?
Robert
Nov 12 '05 #7
Reasons to use Visual Basic:
1. For non-database applications.
2. For applications which require complex graphic ActiveX controls.
3. Need to distribute with a small footprint.
(Access must be present on the machine where the Access application
is run. A runtime version of Access can be distributed with the
application, but this is 70-120 MB - not feasible, for example, for
downloading over a dial-up connection.)
I'm sure other developers can add to this list.

- Turtle

"Robert" <pr**********@y ahoo.com> wrote in message
news:10******** *****@corp.supe rnews.com...

"Mike Storr" <st******@sympa tico.ca> wrote in message
news:1s******** *************** ******@40tude.n et...
On Sun, 15 Feb 2004 13:50:04 GMT, MacDermott wrote:
Visual Basic for Applications is part of Access.
Development with VBA/Access is up to 3 times as fast as development in
Visual Basic where, after all, you're going to need some sort of database storage, too.

HTH
- Turtle

"Robert" <pr**********@y ahoo.com> wrote in message
news:10******** *****@corp.supe rnews.com...
> Would you use Access to create a car rental reservation system? I would> think that the complexity of such a system would be better suited to a> procedural language like Visual Basic or C++. Your thoughts, please.
>
> Robert
>
>


Nice thing about Access, is all the tools/requirements to drive a data
service are right there and automated for you. Most of the design tools
(controls etc.) in Access are specifically designed to run off of
tables/queries and handle all the connectivity for you. Even with all of
Access's faults, you're hard pressed to find a simpler environment with
the same functionality.

--
Mike Storr
veraccess.com


Then why does anyone use Visual Basic?
Robert

Nov 12 '05 #8
"Robert" <pr**********@y ahoo.com> wrote in news:102vtdna4r n3d95
@corp.supernews .com:
Then why does anyone use Visual Basic?


Asking that here is like asking Canadians why they elected George Bush.

When I use Visual Basic (rarely) I do so for one of these reasons:

- it's easy to make useful com objects available as a dymanimic link
library in VB
- it MAY be easier to distribute a VB application
- VB can compile to native code ... floating point operations are many,
many times faster in native code than in any "compiled" manifestation of
VBA code
- VB has (or had) a few very powerful capabilities that VBA does (or did)
not have)

But for most DB applications these are not needed and the slickness of
Access as a front end far outweighs any programming advantage VB might
have.

(Of course there are the misinformed persons who believe that VB has some
inherent advantage over Access as a "real" programming language. Sigh!)

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)
Nov 12 '05 #9
http://www.barsnet.com/
http://www.thermeon.com/
http://www.caribbean-connexion.com/software/ - and this is 'serious'
software too, in C++!
"Robert" <pr**********@y ahoo.com> wrote in message
news:10******** *****@corp.supe rnews.com...

"Mike MacSween" <mi************ ***********@bti nternet.com> wrote in message news:40******** **************@ news.aaisp.net. uk...
That sounds like a database project to me. So use a database development
system. Like Access.

What makes you think it's 'complex'? IMHO the complexity of a system can't be measured until you've done a great deal of work in analysis. And if
it is
complex the chances are that the complexity is in the data structures -
tables and how they relate to each other. In which case a database
development system is what you need. Like Access.

Of course if it's very very complex then you probably need to program it
properly. In which case assembler is the obvious answer.<g>

As has been pointed out, won't this just be standard vertical market
software that somebody has already written?

Yours, Mike MacSween

"Robert" <pr**********@y ahoo.com> wrote in message
news:10******** *****@corp.supe rnews.com...
Would you use Access to create a car rental reservation system? I would think that the complexity of such a system would be better suited to a
procedural language like Visual Basic or C++. Your thoughts, please.

Robert



A previous poster evidently hasn't found any!
Robert

Nov 12 '05 #10

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

Similar topics

0
2131
by: John Bevilaqua | last post by:
We have developed a prototype working application to handle Reservations or Appointments into an Access 2002 or SQL Server 2000 backend system. These Reservations can be originated using an Interactive Voice Response System (IVR), a Web enabled form, and in the 4th Quarter of 2003, a Palm Pilot interface, too. They all feed into the same backend database in real-time offering considerable savings in determining the exact
7
2433
by: windandwaves | last post by:
Hi Folk Is there anyone out there in a hotel reservation system. I have written one over the last few years and I would like to know if anyone has a similar interest. > Nicolaas
7
2586
by: Me | last post by:
Am new to vb dotnet and although I like what I've seen sofar, I am experiencing pblms with system access violation "attempt to read write protected memory". This error happens when I open a second copy of the program. Any help appreciated in finding the source for this error or preventing a second copy of the program drom being loaded.
1
4883
by: hiboo | last post by:
Does anyone know of any open source java software/code libraries for doing travel/airline reservations? I'm looking for a typical airline (hotel, car rental?) reservation system. system in perl or c, c++ ok.
1
4120
by: Roy27 | last post by:
Hi, Can somebody please confirm if "Hertz Rent A Car" company's reservation system has XML API to develop software for integration with other 3rd party software? I apologize if I am putting the question in a wrong group? Thanks Manik
1
8350
by: pop | last post by:
i am a student.i am studying engg...i want c/c++ source code for railway reservation system and online purchasing...... plz help buddies.........
10
34815
by: amitdutt2002 | last post by:
Hi, i need the documentation on the Railway Reservation System,
2
7572
by: cotty | last post by:
AIRLINE RESERVATION SYSTEM A small airline has just purchased a computer for its new automated reservations system. The president has asked you to program the new system in C. You are to write a program to assign seats on each flight of the airline’s only plane (capacity: 20 seats). Your program should display the following menu alternatives: Please type 1 for “business” Please type 2 for “economy” If the person types 1, then your...
0
9589
marktang
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...
0
10216
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9997
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8873
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7413
isladogs
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...
0
6675
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();...
0
5310
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...
1
3965
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
2
3565
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.