473,320 Members | 1,802 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.

Networking Database

I have recently placed an access database (back end) on a network folder.
The standalone pc's accessing the network have in their own respective C
drives a copy of the database (minus the table). I have linked the backend
source table to these front end database copies.
The networking has been working nicely but the other day, I got a message
when trying to access the database stating that the format is not a
recognizable one... ie i simply could not open it.
I think it was corrupted. Anyhow, I deleted the database and I went to use a
copy of a front end database, minus the data to recreate the main network
database. But these too were corrupted as I could not open them either.
Finally I managed to get a seperate backup copy of the database and set it
up as the network database to replace the corrupted one.

Note the following if these may have contributed to the corruption:
- I did not split the database as i had simply copied the database to each
of the pc's on the network (minus the table data) and then linked the source
backend table to the access database copies in the pc's.
- I had not set up a workgroup - do I really need to ? will that affect the
database in the long term ?
- in the Options section, under the Default Record Locking area, i had
ticked "no locks". I feel maybe I should have ticked "Edited Record" to have
avoided the corruption of the database as there would not have been a clash
in editing a particular record between users at any given time.
- finally, i did not compact and repair the database and certainly not on a
regular basis as recommended by microsoft, which may have contributed to the
corruption ?
Any comments from the above as to the possible cause so I can avoid it in
the future.
Nov 13 '05 #1
6 1824
ken
Hi,
I'm about to implement the same thing. Is there a place somewhere which
would tell us how to properly set up something like this?

Thanks

Nov 13 '05 #2
I think your problems stemmed from not using a split database. I've
read that the more traffic there is during read/write occuring at the
same time, the better chance of corruption. As I understand it, the
database being split would prevent or lessen the chance of it
happening.

I would also use the compac/repair at a regular basis.

Good luck!

Dave

Nov 13 '05 #3
"Gary" <g4****@hotmail.com> wrote in
news:42***********************@news.optusnet.com.a u:
I have recently placed an access database (back end) on a network
folder. The standalone pc's accessing the network have in their
own respective C drives a copy of the database (minus the table).
I have linked the backend source table to these front end database
copies. The networking has been working nicely but the other day,
I got a message when trying to access the database stating that
the format is not a recognizable one... ie i simply could not open
it. . . .
That means that the back end has been flagged as possibly corrupt.
It doesn't necessarily mean it *is* corrupt.

Work your way through:

http://www.granite.ab.ca/access/corruptmdbs.htm

That has everything you need for diagnosing the problem.
. . . I think it was corrupted. Anyhow, I deleted the database and
I went to use a copy of a front end database, minus the data to
recreate the main network database. But these too were corrupted
as I could not open them either. Finally I managed to get a
seperate backup copy of the database and set it up as the network
database to replace the corrupted one.
Why didn't you just make a copy of the back end and try to compact
it?
Note the following if these may have contributed to the
corruption: - I did not split the database as i had simply copied
the database to each of the pc's on the network (minus the table
data) and then linked the source backend table to the access
database copies in the pc's.
I can't see how that would cause a problem. It doesn't matter if you
have unused data tables in the front ends.
- I had not set up a workgroup - do I
really need to ? will that affect the database in the long term ?
Well, you're always using a workgroup file, whether you set it or
not, and logging in silently as ADMIN. But, no this has nothing to
do with the problem.
- in the Options section, under the Default Record Locking area, i
had ticked "no locks". I feel maybe I should have ticked "Edited
Record" to have avoided the corruption of the database as there
would not have been a clash in editing a particular record between
users at any given time.
No, optimistic or pessimistic locking has no effect whatsoever on
database corruption. That choice only affects how edit collisions
are determined, and works only when everything is already operating
correctly.
- finally, i did not compact and repair
the database and certainly not on a regular basis as recommended
by microsoft, which may have contributed to the corruption ?


Yes, regular maintenance is absolutely necessary to insure the
long-term health of your data. It could be that your database was
carrying undetected corruption for a very long time. I've seen
databases entirely lost from corruption that was then found to have
been present in backups going back weeks and months.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #4
"DaveA" <ny******@yahoo.com> wrote in
news:11**********************@f14g2000cwb.googlegr oups.com:
I think your problems stemmed from not using a split database. . .


Er, I read this in the original post:

The standalone pc's accessing the network have in their own
respective C drives a copy of the database (minus the table). I
have linked the backend source table to these front end
database copies.

as indicating that it was already split.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #5
"ken" <ge****@gmail.com> wrote in news:1118330047.085982.107660
@o13g2000cwo.googlegroups.com:
Hi,
I'm about to implement the same thing. Is there a place somewhere which
would tell us how to properly set up something like this?

Thanks


Yes. It's called, "install a real RDBMS system on the server" and store
your data in that. Be it MySQL, PostGres 8.0, Oracle, DB2, SQL Server,
Firebird/Interbase, whathaveyou.

Not only will it be faster, it'll be more robust.

by using a remote MDB file with a client MDB front-end, you still run the
risk of a network outage, frustrated user, wandering cat, whathaveyou,
doing something to interrupt your connecton to the non-comingled MDB file
while their "client" is trying to write data to the backend MDB file, and
it'll get corrupted. Like what happened to you.

Except for MySQL (until MySQL 5.0 is released), all the other RDBMS have
what is known as a transaction, and all updates happen witin the confines
of a transaction, which can roll back all changes made for a session if a
hiccup like the above occurs, keeping the rest of the data intact.
Nov 13 '05 #6
corey lawson <corey.lawson@worldnetdotattdotnet> wrote in
news:Xn*********************************@127.0.0.1 :
"ken" <ge****@gmail.com> wrote in news:1118330047.085982.107660
@o13g2000cwo.googlegroups.com:
I'm about to implement the same thing. Is there a place somewhere
which would tell us how to properly set up something like this?
Yes. It's called, "install a real RDBMS system on the server" and
store your data in that. Be it MySQL, PostGres 8.0, Oracle, DB2,
SQL Server, Firebird/Interbase, whathaveyou.


This is an overly pessimistic answer.

I have never once had a client who used a server back end, and not
one client has ever lost data, except to bugs in Jet (the early
versions of Jet 4 were disastrous -- a client lost 3 whole
records!!!) or to lack of backups.
Not only will it be faster, it'll be more robust.
No, it won't necessarily be faster. It may, in fact, be slower after
a conversion to a server back end, unless your original front end
was engineered with that conversion in mind.
by using a remote MDB file with a client MDB front-end, you still
run the risk of a network outage, frustrated user, wandering cat,
whathaveyou, doing something to interrupt your connecton to the
non-comingled MDB file while their "client" is trying to write
data to the backend MDB file, and it'll get corrupted. Like what
happened to you.
Yes, that risk is always there, but in my more than 10 years of
experience with Access applications using Jet back ends, data loss
is very, very uncommon.
Except for MySQL (until MySQL 5.0 is released), all the other
RDBMS have what is known as a transaction, and all updates happen
witin the confines of a transaction, which can roll back all
changes made for a session if a hiccup like the above occurs,
keeping the rest of the data intact.


If your data is very important and the possibility of the loss of
any data at all untenable, then, yes, a server back end could be a
good idea.

But it comes with substantial administrative overhead, and requires
a lot more knowledge to get running efficiently than a pure
Access/Jet solution.

People who have recurrent corruption with Access databases simply
aren't competent at designing applications and adminstering their
network/application.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #7

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

Similar topics

5
by: KevinGPO | last post by:
Two quick queries: 1. I have programmed a little network performance monitor. It monitors a set of remote hosts over a network. It gets the CPU statistics and all gets collected at one of the...
7
by: Brian Keogh | last post by:
Hi, I'm a student learning TCP/IP networking at University. Although I understand all about TCP/IP Networking in Java I am expected to understand the basics of C with regard to these programs as...
46
by: H.A. Sujith | last post by:
Why doesn't the standard library provide (at least basic) networking facilities using TCP/IP ?
0
by: petro | last post by:
I am trying to deploy an asp.net application to my web server. My application uses system.data.oledb to connect to an oracle database. On my development machine I have the oracle client 10g...
1
by: archie197 | last post by:
I have a database program using VB and MySql, however I want it to work in LAN flatform so that it is distributed and many could use it however. I don't have any Idea how would I do that since I...
1
by: chinaemerem ibeawuchi | last post by:
What is the difference between URL networking and Socket networking? with an example of each type and state why the choosen networking technique is most appropriate for the example.
10
by: Fenix [Youth Director] | last post by:
Hello, I am in need of advice or examples of how I should build my database for a small non-profit youth computer gaming organization. I am a beginner at database design and I know this project...
6
by: darrel | last post by:
Hello there VB wizards. I have a few questions, regarding how networking works with Visual Basic. It's like this - I have a PC that has the database of all my system. It's like a central database pc....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
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)...
0
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...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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.