473,407 Members | 2,676 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

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 5183
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**********@yahoo.com> wrote in message
news:10*************@corp.supernews.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**********@yahoo.com> wrote in message
news:10*************@corp.supernews.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**********@yahoo.com> wrote in
news:10*************@corp.supernews.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**********@yahoo.com> wrote in message
news:10*************@corp.supernews.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***********************@btinternet.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**********@yahoo.com> wrote in message
news:10*************@corp.supernews.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******@sympatico.ca> wrote in message
news:1s*****************************@40tude.net...
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**********@yahoo.com> wrote in message
news:10*************@corp.supernews.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**********@yahoo.com> wrote in message
news:10*************@corp.supernews.com...

"Mike Storr" <st******@sympatico.ca> wrote in message
news:1s*****************************@40tude.net...
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**********@yahoo.com> wrote in message
news:10*************@corp.supernews.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**********@yahoo.com> wrote in news:102vtdna4rn3d95
@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**********@yahoo.com> wrote in message
news:10*************@corp.supernews.com...

"Mike MacSween" <mi***********************@btinternet.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**********@yahoo.com> wrote in message
news:10*************@corp.supernews.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
rkc

"Lyle Fairfield" <Mi************@Invalid.Com> wrote in message
news:Xn*******************@130.133.1.17...
"Robert" <pr**********@yahoo.com> wrote in news:102vtdna4rn3d95
@corp.supernews.com:
Then why does anyone use Visual Basic?


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


I hear you're all voting for Conan O'Brien this year.
Nov 12 '05 #11
I'll pass it along. Thanks.
Robert

"Mike MacSween" <mi***********************@btinternet.com> wrote in message
news:40**********************@news.aaisp.net.uk...
http://www.barsnet.com/
http://www.thermeon.com/
http://www.caribbean-connexion.com/software/ - and this is 'serious'
software too, in C++!
"Robert" <pr**********@yahoo.com> wrote in message
news:10*************@corp.supernews.com...

"Mike MacSween" <mi***********************@btinternet.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**********@yahoo.com> wrote in message
news:10*************@corp.supernews.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 #12

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

Similar topics

0
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...
7
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
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...
1
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...
1
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...
1
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
by: amitdutt2002 | last post by:
Hi, i need the documentation on the Railway Reservation System,
2
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...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
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
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
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,...
0
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...
0
tracyyun
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...
0
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,...
0
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...

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.