General Back End Stability question

**Steve Jorgensen** · Nov 12 '05, 07:35 PM

Re: General Back End Stability question

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-" <milkyswirl@yah oo.com> wrote:
[color=blue]
>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?
>
>[/color]

**David W. Fenton** · Nov 12 '05, 07:35 PM

Re: General Back End Stability question

Steve Jorgensen <nospam@nospam. nospam> wrote in
news:oppd105o7r h9ov2oaj9gne6fc jf1a3qbuq@4ax.c om:
[color=blue]
> 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).[/color]

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

**Steve Jorgensen** · Nov 12 '05, 07:35 PM

Re: General Back End Stability question

On Tue, 27 Jan 2004 23:47:11 GMT, "David W. Fenton"
<dXXXfenton@bwa y.net.invalid> wrote:
[color=blue]
>Steve Jorgensen <nospam@nospam. nospam> wrote in
>news:oppd105o7 rh9ov2oaj9gne6f cjf1a3qbuq@4ax. com:
>[color=green]
>> 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).[/color]
>
>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.[/color]

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.

**Steve Jorgensen** · Nov 12 '05, 07:36 PM

Re: General Back End Stability question

This message is a forgery.

On Wed, 28 Jan 2004 09:56:38 +0100, Salad <oil@vinegar.co m> wrote:
[color=blue]
>
>Your email name "milky swirl" causes a twinge in my loins.
>
>
>
>-Michelle- wrote:
>[color=green]
>> 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?
>>
>>
>>[/color]
>
>
>
>
>
>
>
>
>
>
>
>
>
>[/color]

**-Michelle-** · Nov 12 '05, 07:36 PM

Re: General Back End Stability question

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" <nospam@nospam. nospam> wrote in message
news:orue101v8v vt9srcv4uo5ko5m be9fgfdff@4ax.c om...[color=blue]
> This message is a forgery.
>
> On Wed, 28 Jan 2004 09:56:38 +0100, Salad <oil@vinegar.co m> wrote:
>[color=green]
> >
> >Your email name "milky swirl" causes a twinge in my loins.
> >
> >
> >
> >-Michelle- wrote:
> >[color=darkred]
> >> This is a general question about back ends.
> >>
> >> Using in the scenario of a single user machine or *possibly* 2[/color][/color][/color]
networked[color=blue][color=green][color=darkred]
> >> 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[/color][/color][/color]
would[color=blue][color=green][color=darkred]
> >> keep track of the stock items (wouldn't change much). The bulk of the[/color][/color][/color]
work[color=blue][color=green][color=darkred]
> >> is based on sales made which of course would vary. It's probably fair[/color][/color][/color]
to[color=blue][color=green][color=darkred]
> >> 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[/color][/color][/color]
for a[color=blue][color=green][color=darkred]
> >> 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[/color][/color][/color]
help?[color=blue][color=green][color=darkred]
> >> Is there such a thing as 'compact and repairing' too often?
> >>
> >>
> >>[/color]
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >[/color]
>[/color]

**Steve Jorgensen** · Nov 12 '05, 07:36 PM

Re: General Back End Stability question

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-" <milkyswirl@yah oo.com> wrote:
[color=blue]
>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" <nospam@nospam. nospam> wrote in message
>news:orue101v8 vvt9srcv4uo5ko5 mbe9fgfdff@4ax. com...[color=green]
>> This message is a forgery.
>>
>> On Wed, 28 Jan 2004 09:56:38 +0100, Salad <oil@vinegar.co m> wrote:
>>[color=darkred]
>> >
>> >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[/color][/color]
>networked[color=green][color=darkred]
>> >> 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[/color][/color]
>would[color=green][color=darkred]
>> >> keep track of the stock items (wouldn't change much). The bulk of the[/color][/color]
>work[color=green][color=darkred]
>> >> is based on sales made which of course would vary. It's probably fair[/color][/color]
>to[color=green][color=darkred]
>> >> 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[/color][/color]
>for a[color=green][color=darkred]
>> >> 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[/color][/color]
>help?[color=green][color=darkred]
>> >> Is there such a thing as 'compact and repairing' too often?
>> >>
>> >>
>> >>
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >[/color]
>>[/color]
>[/color]

**-Michelle-** · Nov 12 '05, 07:36 PM

Re: General Back End Stability question

Thanks for the explanation. I actually never received the original message.

"Steve Jorgensen" <nospam@nospam. nospam> wrote in message
news:7lve10dfr4 35a31r579tm1pja 5pks3v1sc@4ax.c om...[color=blue]
> Presumably, you received my reply before the original message. I was[/color]
pointing[color=blue]
> out that the offensive message was not, in fact posted by the person who[/color]
is[color=blue]
> 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-" <milkyswirl@yah oo.com>[/color]
wrote:[color=blue]
>[color=green]
> >I take offense to your comments. I have posted questions on here before[/color][/color]
and[color=blue][color=green]
> >I am always thankful for the answers that I get.
> >
> >I also cannot be held responsible what happens to your loins when reading[/color][/color]
my[color=blue][color=green]
> >email address.
> >
> >Michelle
> >
> >
> >"Steve Jorgensen" <nospam@nospam. nospam> wrote in message
> >news:orue101v8 vvt9srcv4uo5ko5 mbe9fgfdff@4ax. com...[color=darkred]
> >> This message is a forgery.
> >>
> >> On Wed, 28 Jan 2004 09:56:38 +0100, Salad <oil@vinegar.co m> 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[/color]
> >networked[color=darkred]
> >> >> 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[/color][/color][/color]
that[color=blue][color=green]
> >would[color=darkred]
> >> >> keep track of the stock items (wouldn't change much). The bulk of[/color][/color][/color]
the[color=blue][color=green]
> >work[color=darkred]
> >> >> is based on sales made which of course would vary. It's probably[/color][/color][/color]
fair[color=blue][color=green]
> >to[color=darkred]
> >> >> say that in any one year, there would say 40000 transactions[/color][/color][/color]
(sales).[color=blue][color=green][color=darkred]
> >> >>
> >> >> If I wrote the front end in VS.net VB, would Access be stable enough[/color]
> >for a[color=darkred]
> >> >> back end? If not, what are other options that I should be[/color][/color][/color]
considering?[color=blue][color=green][color=darkred]
> >> >>
> >> >> TIA
> >> >> Michelle
> >> >>
> >> >> PS: If I also carrying out compacting on a regular basis, would this[/color]
> >help?[color=darkred]
> >> >> Is there such a thing as 'compact and repairing' too often?
> >> >>
> >> >>
> >> >>
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >>[/color]
> >[/color]
>[/color]

**Steve Jorgensen** · Nov 12 '05, 07:37 PM

Re: General Back End Stability question

Another fake via an anonymous remailer, of course.

On 28 Jan 2004 14:31:17 -0000, Anonymous-Remailer@See.Co mment.Header
(MacDermott) wrote:
[color=blue]
>Oh come on! Michelle, you obviously are aware of the allusions you make
>with "milky swirl"?
>
>
>-Michelle- wrote:
>[color=green]
>> 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" <nospam@nospam. nospam> wrote in message
>> news:orue101v8v vt9srcv4uo5ko5m be9fgfdff@4ax.c om...[color=darkred]
>>> This message is a forgery.
>>>
>>> On Wed, 28 Jan 2004 09:56:38 +0100, Salad <oil@vinegar.co m> 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[/color]
>> networked[color=darkred]
>>> >> 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[/color]
>> would[color=darkred]
>>> >> keep track of the stock items (wouldn't change much). The bulk of the[/color]
>> work[color=darkred]
>>> >> is based on sales made which of course would vary. It's probably fair[/color]
>> to[color=darkred]
>>> >> 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[/color]
>> for a[color=darkred]
>>> >> 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[/color]
>> help?[color=darkred]
>>> >> Is there such a thing as 'compact and repairing' too often?
>>> >>
>>> >>
>>> >>
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>>[/color]
>>
>>[/color][/color]

**Tony Toews** · Nov 12 '05, 07:38 PM

Re: General Back End Stability question

Anonymous-Remailer@See.Co mment.Header (NB) wrote:
[color=blue]
>Comments: This message did not originate from the above address.
> It was remailed by two or more anonymous mail services.[/color]

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

Tony's Main Microsoft Access Page

http://www.granite.ab.ca/accsmstr.htm

Tony's Microsoft Access Hint's, Tips and FAQ