473,327 Members | 2,071 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,327 software developers and data experts.

Saving split database on network and local

Our servers went down for over 6 hours yesterday and I was asked if
there was a way to store the database on the server and a local station
at the same time.

My datbase is split and the tables are linked. Would there be a way to
modify the table links to direct them to two seperate backends? Could
there also be a non-linked table stored in the frontend alongside the
table links?

Our endpoint would be to have a mirror on the network drive that all
users could use, but in the even of another server downtime, the
dispatcher could use the mirrored tables that are stored on the local
drive without using a different frontend MDE?

Thanks

Dave

Nov 13 '05 #1
7 2352
> My datbase is split and the tables are linked. Would there be a way to
modify the table links to direct them to two seperate backends? Could
there also be a non-linked table stored in the frontend alongside the
table links?


Why would you want to have double links?
In case the network gets down you can copy the backend-db to a local station, refresh the links and work on the local station with the local db.
You can use code to refresh the links automatically. I do this with all my apps.
(Well in fact I delete the link and recreate it, this 'sometimes' works better because links can get corrupted)
Code to just relink is here:
http://www.mvps.org/access/tables/tbl0009.htm

--
Hope this helps
Arno R
Nov 13 '05 #2
Our server is not located in the same place we are. If the network
connections drops, I cannot get to the server. If I were to have a
mirrored backend locally, using the code you linked to me would provide
a near-seamless backup. The only issue now is how to establish a local
backend and have it exist with a network backend.

Thank you for your help

Dave

Nov 13 '05 #3
Dave,
Maybe you could automate some kind of 'pseudo' backup-mirroring procedure??
Could you send your data from the server to you locally, every hour or so ?
You can automate this from within your mde-frontend.
When the appp is running it sends the date every hour or so.
If you are the only user this will work. If it's multi-user it's more difficult.
I 'think' you will have to make more backups then, because you can not be *sure* such a 'live'-backup is a good one.

Good luck,
Arno R

<ny******@yahoo.com> schreef in bericht news:11*********************@o13g2000cwo.googlegro ups.com...
Our server is not located in the same place we are. If the network
connections drops, I cannot get to the server. If I were to have a
mirrored backend locally, using the code you linked to me would provide
a near-seamless backup. The only issue now is how to establish a local
backend and have it exist with a network backend.

Thank you for your help

Dave

Nov 13 '05 #4
It is multi-user after the data is entered. The primary key is our
incident # which is generated from the dispatcher. Once a call is
placed a dispatch card is started and a incident # (PK) is generated.
From there the dispatcher can click a button to generate a new report

(Incident or Property) based on the incident type. Everything is
dependant on that incident #. So, in one sense it is multi-user as we
can use different stations to complete the reports, but it stems from
the generation of the PK from the dispatcher. Hope that is not
confusing.

If the network goes down, it is not a big deal if the reports are not
completed as they will not be able to be emailed to the commander and
higher, but the chronoligical(sp) integrity needs to be maintained. To
do this I would need a backup generated after each incident card is
completed. I am figuring if I can have the backend saved locally and on
the network at the same time, it would prevent a lagtime for creating a
backup after each card.

Thanks
Dave

Nov 13 '05 #5
I've been reading about replication and it sounds like the way to go. I
cannot find anything here or other places about an automatic synch or
an ongoing synch as long as the database is open.

Any ideas?

Thanks
Dave

Nov 13 '05 #6
Dave,
I have never used replication myself, but from what I know about replication I think it will not be your solution.
When your network goes down you can't replicate anymore...

Maybe your first idea (double tables, double links) was not so bad at all.
I think I understand your problem now...
I am figuring if I can have the backend saved locally and on
the network at the same time, In that scenario I would not save the whole backend but only the new records.

Just an idea here: Maybe this is what you are after?
You could have *exact* duplicates of your data-input-tables in a local 'replica'-backend.
Link the 'same' tables two times, first from your backend, second from your local 'replica'
Name your second linked 'replica-table' the same as your first linked table but 'Replica' added
Like: TabInput and TabInputReplica
You can now duplicate every new record to these tables. (I would use Transactions here.)
In case of a Network-failure you only have to rename the links (and other stuff like stop duplicating...)
It's difficult but you get the idea? It is the best I can think of right now.
--
Hope this helps
Arno R
<ny******@yahoo.com> schreef in bericht news:11*********************@o13g2000cwo.googlegro ups.com... I've been reading about replication and it sounds like the way to go. I
cannot find anything here or other places about an automatic synch or
an ongoing synch as long as the database is open.

Any ideas?

Thanks
Dave

Nov 13 '05 #7
Figured it out. Maybe not the best,but it works so far.

<CODE in afterupdate>

DoCmd.SetWarnings False
DoCmd.CopyObject acoutputtable, "tabelname", acTable, "tablename"
DoCmd.SetWarnings True

</CODE>

Thank you so much for your help.

that way I can quickly copy only the table after each record is
changed.

Thanks for

Nov 13 '05 #8

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

Similar topics

3
by: Sam | last post by:
I have developed a small database which is setup with the front end and backend files. There are 12 linked tables withe the datafile located on our server. Now the boss wants to be able to...
12
by: Corey Burnett | last post by:
I have a client that has a split database (front-end/back-end). They are also using Access security - MDW file. The front end MDE file, the back end MDB file, and the MDW file are all located on...
1
by: Tardus Merula | last post by:
We have just put a new samba server on the lab premises and upgradede all workstations to 100 MB/s, in order to avoid using 10-mile radio link, hoping that this would enable us to operae our...
5
by: Mark | last post by:
I have a VB 6 program that I have saved an audio file to using DAO and the appendchunk as is shown at http://support.microsoft.com/kb/103257/EN-US/. ; I have it working fine in that app (it saves...
2
by: Michael | last post by:
We have an ASP.NET 2.0 web application running on a Windows 2003 domain controller. Part of that application needs to read and write files from and to a network share ( living on a MAC Xserveraid)...
17
by: shineofleo | last post by:
Here is the situation: I wrote a VB programm, which stores all the information in a single Access database file using jet engine. It worked well, however one of my customs reported that there was...
7
by: DanZaMan | last post by:
Just a query about how clever access is, I'm using access 97. When using a "split" database with a separate front-end and with the data file on a separate server on the network how does access...
4
by: corey11 | last post by:
I'm a very low-level developer with limited VB knowledge but nonetheless was able to put together a very user-friendly and extremely helpful Access 97 database for my company some 10 years back. We...
3
by: =?Utf-8?B?SFJzb2Z0IEluZm9ybcOhdGljYQ==?= | last post by:
Dear Friends I'm new with asp.net. I have a asp.net 2.0 application hosted in a ISP, that don't permit instal of Firebird database. I need this application to access a firebird database that is...
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: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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.