This is a general question about back ends.
Using in the scenario of a single user machine or *possibly* 2 networked
machines. Therefore using SQL Server is not really an option.
I need to write a database that keeps track of someone's sales (eg:
jewellery shop). There would be tables with around 20000 records that would
keep track of the stock items (wouldn't change much). The bulk of the work
is based on sales made which of course would vary. It's probably fair to
say that in any one year, there would say 40000 transactions (sales).
If I wrote the front end in VS.net VB, would Access be stable enough for a
back end? If not, what are other options that I should be considering?
TIA
Michelle
PS: If I also carrying out compacting on a regular basis, would this help?
Is there such a thing as 'compact and repairing' too often? 9 1364
Whether stability is good enough depends on your stability requirements.
Based on what you've said, the database will always be off-line each night,
and could be fully backed up, and a repair/compact run. Given that, the very
worst that could happen in a crash or corruption is the loss of a day's work.
You could even reduce that risk further by backing up at lunch. In this
situation, what is the cost of that loss?
Also, in most cases back-end data corruption is fairly rare, though it
certainly does happen. When it does happen, the data is usually recoverable,
possibly minus one or 2 rows that can then be re-entered or recovered from
another back-up. I've only had about 2 unrecoverable back-end corruptions in
about 13 years of Access work, and one of those was my fault (make sure your
procedures are solid and resistant to human error).
On Wed, 28 Jan 2004 08:18:22 +1000, "-Michelle-" <mi********@yahoo.com> wrote: This is a general question about back ends.
Using in the scenario of a single user machine or *possibly* 2 networked machines. Therefore using SQL Server is not really an option.
I need to write a database that keeps track of someone's sales (eg: jewellery shop). There would be tables with around 20000 records that would keep track of the stock items (wouldn't change much). The bulk of the work is based on sales made which of course would vary. It's probably fair to say that in any one year, there would say 40000 transactions (sales).
If I wrote the front end in VS.net VB, would Access be stable enough for a back end? If not, what are other options that I should be considering?
TIA Michelle
PS: If I also carrying out compacting on a regular basis, would this help? Is there such a thing as 'compact and repairing' too often?
Steve Jorgensen <no****@nospam.nospam> wrote in
news:op********************************@4ax.com: Also, in most cases back-end data corruption is fairly rare, though it certainly does happen. When it does happen, the data is usually recoverable, possibly minus one or 2 rows that can then be re-entered or recovered from another back-up. I've only had about 2 unrecoverable back-end corruptions in about 13 years of Access work, and one of those was my fault (make sure your procedures are solid and resistant to human error).
Actually, most instances of reported corruption don't lose any data
at all, because the there's not actually anything corrupt, it's just
a flag that isn't set right.
Indeed, I've seen only a handful of cases of actual data loss in my
nearly 10 years of full-time Access programming.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
On Tue, 27 Jan 2004 23:47:11 GMT, "David W. Fenton"
<dX********@bway.net.invalid> wrote: Steve Jorgensen <no****@nospam.nospam> wrote in news:op********************************@4ax.com :
Also, in most cases back-end data corruption is fairly rare, though it certainly does happen. When it does happen, the data is usually recoverable, possibly minus one or 2 rows that can then be re-entered or recovered from another back-up. I've only had about 2 unrecoverable back-end corruptions in about 13 years of Access work, and one of those was my fault (make sure your procedures are solid and resistant to human error).
Actually, most instances of reported corruption don't lose any data at all, because the there's not actually anything corrupt, it's just a flag that isn't set right.
Yes, that is what I was trying to imply, though I certainly have experienced
the loss of a row or 2 once in a great while. The repair process also tells
you when it loses rows, so you know when this has happened and can take
appropriate measures to recover properly afterward.
This message is a forgery.
On Wed, 28 Jan 2004 09:56:38 +0100, Salad <oi*@vinegar.com> wrote: Your email name "milky swirl" causes a twinge in my loins. -Michelle- wrote:
This is a general question about back ends.
Using in the scenario of a single user machine or *possibly* 2 networked machines. Therefore using SQL Server is not really an option.
I need to write a database that keeps track of someone's sales (eg: jewellery shop). There would be tables with around 20000 records that would keep track of the stock items (wouldn't change much). The bulk of the work is based on sales made which of course would vary. It's probably fair to say that in any one year, there would say 40000 transactions (sales).
If I wrote the front end in VS.net VB, would Access be stable enough for a back end? If not, what are other options that I should be considering?
TIA Michelle
PS: If I also carrying out compacting on a regular basis, would this help? Is there such a thing as 'compact and repairing' too often?
I take offense to your comments. I have posted questions on here before and
I am always thankful for the answers that I get.
I also cannot be held responsible what happens to your loins when reading my
email address.
Michelle
"Steve Jorgensen" <no****@nospam.nospam> wrote in message
news:or********************************@4ax.com... This message is a forgery.
On Wed, 28 Jan 2004 09:56:38 +0100, Salad <oi*@vinegar.com> wrote:
Your email name "milky swirl" causes a twinge in my loins. -Michelle- wrote:
This is a general question about back ends.
Using in the scenario of a single user machine or *possibly* 2
networked machines. Therefore using SQL Server is not really an option.
I need to write a database that keeps track of someone's sales (eg: jewellery shop). There would be tables with around 20000 records that
would keep track of the stock items (wouldn't change much). The bulk of the
work is based on sales made which of course would vary. It's probably fair
to say that in any one year, there would say 40000 transactions (sales).
If I wrote the front end in VS.net VB, would Access be stable enough
for a back end? If not, what are other options that I should be considering?
TIA Michelle
PS: If I also carrying out compacting on a regular basis, would this
help? Is there such a thing as 'compact and repairing' too often?
Presumably, you received my reply before the original message. I was pointing
out that the offensive message was not, in fact posted by the person who is
know here by the name of salad, but by an imposter posting through an
anonymous remailer.
On Wed, 28 Jan 2004 19:10:24 +1000, "-Michelle-" <mi********@yahoo.com> wrote: I take offense to your comments. I have posted questions on here before and I am always thankful for the answers that I get.
I also cannot be held responsible what happens to your loins when reading my email address.
Michelle
"Steve Jorgensen" <no****@nospam.nospam> wrote in message news:or********************************@4ax.com.. . This message is a forgery.
On Wed, 28 Jan 2004 09:56:38 +0100, Salad <oi*@vinegar.com> wrote:
> >Your email name "milky swirl" causes a twinge in my loins. > > > >-Michelle- wrote: > >> This is a general question about back ends. >> >> Using in the scenario of a single user machine or *possibly* 2networked >> machines. Therefore using SQL Server is not really an option. >> >> I need to write a database that keeps track of someone's sales (eg: >> jewellery shop). There would be tables with around 20000 records thatwould >> keep track of the stock items (wouldn't change much). The bulk of thework >> is based on sales made which of course would vary. It's probably fairto >> say that in any one year, there would say 40000 transactions (sales). >> >> If I wrote the front end in VS.net VB, would Access be stable enoughfor a >> back end? If not, what are other options that I should be considering? >> >> TIA >> Michelle >> >> PS: If I also carrying out compacting on a regular basis, would thishelp? >> Is there such a thing as 'compact and repairing' too often? >> >> >> > > > > > > > > > > > > > >
Thanks for the explanation. I actually never received the original message.
"Steve Jorgensen" <no****@nospam.nospam> wrote in message
news:7l********************************@4ax.com... Presumably, you received my reply before the original message. I was
pointing out that the offensive message was not, in fact posted by the person who
is know here by the name of salad, but by an imposter posting through an anonymous remailer.
On Wed, 28 Jan 2004 19:10:24 +1000, "-Michelle-" <mi********@yahoo.com>
wrote:I take offense to your comments. I have posted questions on here before
andI am always thankful for the answers that I get.
I also cannot be held responsible what happens to your loins when reading
myemail address.
Michelle
"Steve Jorgensen" <no****@nospam.nospam> wrote in message news:or********************************@4ax.com.. . This message is a forgery.
On Wed, 28 Jan 2004 09:56:38 +0100, Salad <oi*@vinegar.com> wrote:
> >Your email name "milky swirl" causes a twinge in my loins. > > > >-Michelle- wrote: > >> This is a general question about back ends. >> >> Using in the scenario of a single user machine or *possibly* 2 networked >> machines. Therefore using SQL Server is not really an option. >> >> I need to write a database that keeps track of someone's sales (eg: >> jewellery shop). There would be tables with around 20000 records
thatwould >> keep track of the stock items (wouldn't change much). The bulk of
thework >> is based on sales made which of course would vary. It's probably
fairto >> say that in any one year, there would say 40000 transactions
(sales). >> >> If I wrote the front end in VS.net VB, would Access be stable enough for a >> back end? If not, what are other options that I should be
considering? >> >> TIA >> Michelle >> >> PS: If I also carrying out compacting on a regular basis, would this help? >> Is there such a thing as 'compact and repairing' too often? >> >> >> > > > > > > > > > > > > > >
Another fake via an anonymous remailer, of course.
On 28 Jan 2004 14:31:17 -0000, An****************@See.Comment.Header
(MacDermott) wrote: Oh come on! Michelle, you obviously are aware of the allusions you make with "milky swirl"?
-Michelle- wrote:
I take offense to your comments. I have posted questions on here before and I am always thankful for the answers that I get.
I also cannot be held responsible what happens to your loins when reading my email address.
Michelle
"Steve Jorgensen" <no****@nospam.nospam> wrote in message news:or********************************@4ax.com... This message is a forgery.
On Wed, 28 Jan 2004 09:56:38 +0100, Salad <oi*@vinegar.com> wrote:
> >Your email name "milky swirl" causes a twinge in my loins. > > > >-Michelle- wrote: > >> This is a general question about back ends. >> >> Using in the scenario of a single user machine or *possibly* 2 networked >> machines. Therefore using SQL Server is not really an option. >> >> I need to write a database that keeps track of someone's sales (eg: >> jewellery shop). There would be tables with around 20000 records that would >> keep track of the stock items (wouldn't change much). The bulk of the work >> is based on sales made which of course would vary. It's probably fair to >> say that in any one year, there would say 40000 transactions (sales). >> >> If I wrote the front end in VS.net VB, would Access be stable enough for a >> back end? If not, what are other options that I should be considering? >> >> TIA >> Michelle >> >> PS: If I also carrying out compacting on a regular basis, would this help? >> Is there such a thing as 'compact and repairing' too often? >> >> >> > > > > > > > > > > > > > >
An****************@See.Comment.Header (NB) wrote: Comments: This message did not originate from the above address. It was remailed by two or more anonymous mail services.
Please ignore this posting.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: dba_db2 at nospam gmx.net |
last post by:
Looking at
http://www-306.ibm.com/software/data/db2/linux/validate/
it told us that db2 v8.1 is not validated yet for suse90 professional ed.
Do you have any experience regarding the stability...
|
by: jameso321 |
last post by:
Hi,
We run an MS Access 2000 DB with about 15 users.
It is on a Win 2000 Server (SP4) machine and runs through Citrix
Metaframe Presentation Server 3.0.
--------------------------
|
by: Joe Ross |
last post by:
I've been working with Microsoft support for over 3 weeks now on an
intermittent General Network Error we're seeing in our production
environment between our ASP.NET application and SQL Server...
|
by: Dominic |
last post by:
Hi all,
We've just migrated to IIS 6.0 / Windows Server 2003. We are now
experiencing some stability problem what we did not experience in IIS
5.0 / Windows 2000 Server. Our ASP.NET application...
|
by: ZorpiedoMan |
last post by:
I'm new to the world of sockets, and this question is not VB specific:
If multiple clients access the same server on the same port, and the server
is set up to do some async communication, does...
|
by: Jim Hubbard |
last post by:
http://www.eweek.com/article2/0,1759,1774642,00.asp
|
by: Jim M |
last post by:
I'm porting my Access 2003 backend to SQL Server 2005 in order to
accomodate more users with more stability. I want to encrypt the
columns with client names, addresses and phone numbers because we...
|
by: =?Utf-8?B?VGltIFRhZmZsaW5nZXI=?= |
last post by:
Hello,
I'm developing an application with one parent table and 12 child tables.
The parent table is patient information and the children contain such things
as lab results, medications,...
|
by: sixthscroll |
last post by:
Hi everyone, it's been a very long time since I've programmed, so speak real slow.
I need to use good old DOS C++ (I'm using borland C++ 5.5 compiler with no IDE and therefore no syntax checking)...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |