Could someone tell me where MS-Access (current and 97?) fit(s) on the
RDBMS - ORDBMS - ODBMS spectrum?
I gather it's relational, but how does it size up against/follow SQL2/3/4
definitions and how does it compare to other database vendors?
Any articles that might be of interest? It's for an essay on database
models...
Thanks in advance,
Alex
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
Nov 13 '05
29 5908
<ji********@com pumarc.com> schreef in bericht news:11******** **************@ g43g2000cwa.goo glegroups.com.. . Today I had to reinstall Access 2.0 using the 31 Office 4.3 diskettes on a machine that got whacked by a virus and had been running a POS app for about nine years. With moderate trepidation I performed the install using the ancient 1.44 Meg HD disks. The only file that could not be read from the disks was MSQUERY.EXE (whew!). All the necessary functions of the app worked correctly. I did a custom install and noticed that installing the ISAM drivers was a separate checkbox option. That seemed to indicate that ISAM in Access went beyond table seeks, at least in A2. ISAM brings back distant memories of using JCL on an IBM mainframe and of how nearly everyone failed to realize how important SQL would become. The page indexing method used by Access queries is not intuitive. I only realized recently that Access is using something other than an ISAM style indexing method. James A. Fortune
You *did* install the "Microsoft Access Version 2.0 Service Pack" also I hope?
Arno R
Arno R wrote: You *did* install the "Microsoft Access Version 2.0 Service Pack" also I hope?
Arno R
No way. Let sleeping dogs lie. I did not want to change anything from
the way it was running before. I did not want to upgrade the code to a
later version of Access, although that would have been mostly changing
DB_OPEN_DYNASET 's to dbOpenDynaset's and having them buy another
version of Access. Had the SP changed anything I would be there right
now fixing it on my own time. The app also printed checks using a dot
matrix printer while keeping a record of the cash flows in the
database. There was just too much potential for something to go wrong.
I'll wait until the install disks have lost enough magnetism to prevent
an install before doing any upgrades to that app.
James A. Fortune
The sp is NOT a later version, it's a jet-upgrade to version 2.5.
Most important feature (From MS-info):
"The Microsoft Jet database engine version 2.5 can repair or recover information in some cases where it was not possible to do so before."
Also a lot of files concerning OLE are changed/upgraded. (And I guess) some othes fixes of the jet-engine.
Well if the app is running fine, it's allright with me, but I have always been very carefull about the jet-version my users use...
I even check the jet-version on startup of all my access 2.0 apps.
Arno R
<ji********@com pumarc.com> schreef in bericht news:11******** **************@ g43g2000cwa.goo glegroups.com.. . Arno R wrote: You *did* install the "Microsoft Access Version 2.0 Service Pack" also I hope?
Arno R No way. Let sleeping dogs lie. I did not want to change anything from the way it was running before. I did not want to upgrade the code to a later version of Access, although that would have been mostly changing DB_OPEN_DYNASET 's to dbOpenDynaset's and having them buy another version of Access. Had the SP changed anything I would be there right now fixing it on my own time. The app also printed checks using a dot matrix printer while keeping a record of the cash flows in the database. There was just too much potential for something to go wrong. I'll wait until the install disks have lost enough magnetism to prevent an install before doing any upgrades to that app. James A. Fortune ji********@comp umarc.com wrote in
news:11******** **************@ g43g2000cwa.goo glegroups.com: Today I had to reinstall Access 2.0 using the 31 Office 4.3 diskettes on a machine that got whacked by a virus and had been running a POS app for about nine years. With moderate trepidation I performed the install using the ancient 1.44 Meg HD disks. The only file that could not be read from the disks was MSQUERY.EXE (whew!). All the necessary functions of the app worked correctly.
I hope you remembered to apply the Jet 2.5 update -- Access 2.0 was
completely unusable without it, and could corrupt your data badly.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc ji********@comp umarc.com wrote in
news:11******** **************@ g43g2000cwa.goo glegroups.com: Arno R wrote:
You *did* install the "Microsoft Access Version 2.0 Service Pack" also I hope?
No way. Let sleeping dogs lie. I did not want to change anything from the way it was running before. I did not want to upgrade the code to a later version of Access, although that would have been mostly changing DB_OPEN_DYNASET 's to dbOpenDynaset's and having them buy another version of Access. Had the SP changed anything I would be there right now fixing it on my own time. The app also printed checks using a dot matrix printer while keeping a record of the cash flows in the database. There was just too much potential for something to go wrong. I'll wait until the install disks have lost enough magnetism to prevent an install before doing any upgrades to that app.
Arno has already posted on this, but it was not an Access update --
it was a JET update. It was even an upgrade to a new version of Jet,
2.5.
And it's MANDATORY.
You can't safely run an Access 2.0 database without it in multi-user
mode at all -- it corrupts and crashes faster than you can imagine.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
David W. Fenton wrote: ji********@comp umarc.com wrote in news:11******** **************@ g43g2000cwa.goo glegroups.com:
Arno R wrote:
You *did* install the "Microsoft Access Version 2.0 Service Pack" also I hope?
Arno has already posted on this, but it was not an Access update -- it was a JET update. It was even an upgrade to a new version of Jet, 2.5.
And it's MANDATORY.
You can't safely run an Access 2.0 database without it in multi-user mode at all -- it corrupts and crashes faster than you can imagine.
-- David W. Fenton http://www.bway.net/~dfenton dfenton at bway dot net http://www.bway.net/~dfassoc
When I said upgrade I meant to A97 or later. I realized that the SP
was not a newer version, but I didn't know that the SP was a JET update
only. Your advice is good but the POS runs from the main cash register
by a single user. It will never be multi-user no matter how many cash
registers are added. The POS has a backup system in place. I'm not
going to let the SP anywhere near it.
James A. Fortune
"David W. Fenton" wrote I've never needed the speed of a .Seek, so I've never used it myself.
I haven't done any comparison against seek but I have always found that
using a Query or SQL statement that selects a single record works very
nicely in DAO. (But I don't generally work with huge numbers of records in
Jet databases.) Jet seems pretty "smart" in optimizing when it retrieves
data.
Larry Linson
Microsoft Access MVP
"Larry Linson" <bo*****@localh ost.not> wrote in message
news:Slppe.1007 3$KQ2.7131@trnd dc08... "David W. Fenton" wrote
I've never needed the speed of a .Seek, so I've never used it myself.
I haven't done any comparison against seek ...<snip>
Then why not do one? Perhaps then you can report back to the group with
something more useful than your usual somewhat cautious and limited posts.
After all - don't you need to do something to earn the MVP tag? ji********@comp umarc.com wrote in
news:11******** **************@ g14g2000cwa.goo glegroups.com: When I said upgrade I meant to A97 or later. I realized that the SP was not a newer version, but I didn't know that the SP was a JET update only. Your advice is good but the POS runs from the main cash register by a single user. It will never be multi-user no matter how many cash registers are added. The POS has a backup system in place. I'm not going to let the SP anywhere near it.
I know the problems were most severe in multi-user applications,
where you ended up with corruption almost immediately, but I still
wouldn't run any Access 2.0 installation without it.
I think you're being exremely unwise *not* applying the update. Your
customer should be very nervous.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
"Bob" <bo*@lalamoomoo .com> wrote in
news:d8******** **@nwrdmz02.dmz .ncs.ea.ibs-infra.bt.com: "Larry Linson" <bo*****@localh ost.not> wrote in message news:Slppe.1007 3$KQ2.7131@trnd dc08... "David W. Fenton" wrote
> I've never needed the speed of > a .Seek, so I've never used it > myself.
I haven't done any comparison against seek ...<snip>
Then why not do one? Perhaps then you can report back to the group with something more useful than your usual somewhat cautious and limited posts. After all - don't you need to do something to earn the MVP tag?
Why don't *you* do the comparisons?
That would then add to your long, long list of constructive
contributions to this newsgroup (which now stands at ZERO, out of a
total of ONE POST, ever).
Is that you, Don?
<plonk>
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Limey |
last post by:
Hi All,
I want to write an application that will talk to a RDBMS.
The application needs to be platform neutral from both an operating
system and database backend point of view.
I have decided to create a prototype in Python, the RDBMS will be
PostgreSQL running on a Linux box.
|
by: Relaxin |
last post by:
It is just me or has MS created some of the worst ways to access and display
data?
You can use a DataSet, but if you want to sort or filter the data to must
use a DataView which is created from a DataSet.
But, if you sort by using the Grid (clicking the header) you can no longer
use the DataSet (or maybe the DataView, if that is what you are using) to
locate the record that the user has selected!!
|
by: Shawn H. Mesiatowsky |
last post by:
I have a strange problem here. I have my development computer with IIS
installed, and we have a SQL server as well on a windows 2000 server. both
are members of a domain. I have restricted access to my web app using NTFS
ACL's and have disabled anonymous logon and enabled windows authentication.
So when a user logons on to a computer and they use there web browser, they
are not prompted to logon to the intranet web app I am building. All...
|
by: Val P |
last post by:
How does everyone design the database access layer in an asp.net application?
Two options that come to mind is:
1. create a database class and instanciate it as needed, local to a function
or
2. Provide database access in a base class from which all objects that need
db access will inherit from.
#1 seems wasteful for application that do frequent but light db access.
Option #2 seems even more wasteful, because it adds overhead to the
|
by: williamphenryjr |
last post by:
This is a long post. If you have answers I'm ready. If you have web
links, that'd be great too. I'm a Junior/Senior in Computer Science at
Washington State University, so you can make some assumptions about
terminology I'll be familiar with based on that.
I am trying to write a class that will abstract out database access
stuff for my application. This class will be called DBUtil
I will use this class to do the gruntwork for a custom...
| |
by: Macca |
last post by:
Hi,
I have a multithreaded app which now needs database storage.
I am in the process of designing my Data Access Layer but and was wondering
what issues I should look for for in regards to a multi threaded app.
My app will be need to initiate access to the database from several places
in the Business logic. I'd appreaciate any advice/suggesstions on best
practices to avoid problems such as accessing the same method in the data
|
by: arvind |
last post by:
hi all,
i am accessing sql+ database through python 2.4.3.
i am using Tkinter to build my screens.
how can i pass parameters on the click event of button from one
function to the another?
how can i run another file from current file?
|
by: =?Utf-8?B?Um9nZWxpbw==?= |
last post by:
hey, I have 2 threads, th and th2, both of them run a method.
each of these 2 methods requires database access.
sometimes I get an error, that database requires an open connection, and
that the current connection state is "connecting".
is this because both threads are trying to use the same database???
they use the same public static data access class. would this be why? isnt
|
by: laziers |
last post by:
Hi,
What kind of data access you will use for the project with very large
database :
1. NHibernate
2. Linq
3. Sql queries + stored procedures
4. DataSets
|
by: tvnaidu |
last post by:
I have digital video camera connected to PC, how I will know what kind of packets it is?. I can see live using http access to camera. I installed wireshark, I can see TCP and HTTP packets when I can se LIVE using HTTP. How I will know what kind of packets those video is?. Is it is RTP/RSTP?. mainly streaming packets? thanks.
|
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: 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...
|
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: 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...
|
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: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |