473,320 Members | 1,699 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,320 software developers and data experts.

General Back End Stability question

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?

Nov 12 '05 #1
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?


Nov 12 '05 #2
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
Nov 12 '05 #3
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.
Nov 12 '05 #4
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?







Nov 12 '05 #5
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?






Nov 12 '05 #6
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?
>>
>>
>>
>
>
>
>
>
>
>
>
>
>
>
>
>
>


Nov 12 '05 #7
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 that
would
>> 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?
>>
>>
>>
>
>
>
>
>
>
>
>
>
>
>
>
>
>

Nov 12 '05 #8
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?
>>
>>
>>
>
>
>
>
>
>
>
>
>
>
>
>
>
>



Nov 12 '05 #9
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
Nov 12 '05 #10

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

Similar topics

2
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...
19
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. --------------------------
7
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...
1
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...
2
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...
182
by: Jim Hubbard | last post by:
http://www.eweek.com/article2/0,1759,1774642,00.asp
0
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...
8
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,...
1
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)...
0
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...
0
isladogs
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...
0
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...
0
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...
1
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)...
1
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...
1
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....
0
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
0
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...

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.