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 7 2378
> 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
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
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******** *************@o 13g2000cwo.goog legroups.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
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(s p) 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
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
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******** *************@o 13g2000cwo.goog legroups.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
Figured it out. Maybe not the best,but it works so far.
<CODE in afterupdate>
DoCmd.SetWarnin gs False
DoCmd.CopyObjec t acoutputtable, "tabelname" , acTable, "tablename"
DoCmd.SetWarnin gs 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 take a laptop offsite and still have
access, (even if read only) to the main data file (to be able to add records
in 1 table would also be useful).
I would like to be able to get the user to press a command button which
|
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 a shared
folder on the file server. They have two populations of users - local
and remote. *ALL* users currently get to the system via a Citrix
login. They log in to Citrix and get a Citrix desktop. Then they
start the application via a...
|
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 MsAccess based LIMS database over
the network. While a standalone version, with both program and Data folder
on the local drive (C) the application works excelently, the moment we move
the Data ( e.i. the Tables) folder to a networked drive and...
|
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 to an access database and I can
save the data back to a file using getchunk and everything works correctly).
The issue is that I am now trying to access the database in VB.NET 2003
through an OleDBDataAdapter (Jet 4.0 connection) and can't get it...
|
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) on the same network segment.
I mapped a drive on the server to that share. When mapping the drive, I
could enter access credentials for the shares (an account from the Mac side
that does not exist in the windows domain). Using Windows Explorer,...
| |
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 some
problems with this programm. I checked, the log files showed that the
database was corrupted.
The customer told me that there no 'illegal' operation such as pull out
the plug, or kill the programm via task manager...
So is there any...
|
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 handle
the data; Does it transfer all the data across the network and process
it locally on the front end or does it process it on the server the
data file is held on?
If I put my queries in the access data file on the server would this
result...
|
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 use the database for inventory, job costing, employee records, timecard recording, nearly everything except the hard core accounting. The database is shared by 20 users over a network. Every 3 or 4 years I archive and purge the data to keep the...
|
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 installed in a
Windows 2008 Server in another place, ie, in my local network.
This is for test only, but I intend to create this app to real clients that
has another win32 app that uses the database in local network
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |