473,856 Members | 1,670 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How can I update forms and tables in a shared Access database?

We have an Access database Sch_S.mdb in the shared driver S across the
network. I have a copy of that database in my local driver C, named as
Sch_C.mdb. As per users' request I added some check boxes in the main
form of the database, and added some relevant subroutines in that form.

Now I need to put the modified database Sch_C.mdb to the shared S
driver. Since new data had been added to tables (say T1, T2) in
Sch_S.mdb while I was working with Sch_C.mdb, I have to update the main
form to Sch_S.mdb, or to update data in tables T1 and T2, in
Sch_C.mdb. What is the best way to do that?

What I am thinking is the following:
1. Send a note to users to stop using this shared database Sch_S.mdb
(or open Sch_S.mdb for exclusive use, so others will not be able to use
it)
2. Delete all data in tables T1 and T2 in Sch_C.mdb, then import data
from T1, T2 in Sch_S.mdb to T1, T2 in Sch_C.mdb
3. Move Sch_S.mdb to a back up folder in shared driver S, so we can
recover the old version in case of trouble.
4. Copy Sch_C.mdb from C to S, and Change its name to Sch_S.mdb
(Actually I am using the same name Sch.mdb in C and S)

Is that way working? Is there a simpler way to do that?

Thank you very much for your help!

Nov 13 '05 #1
3 3718
Split your database into a Front End, with everything but the tables
and a Back End with just the tables. Using the linked table manager,
point the Front End at the Back End tables. Note that you'll have to
be careful to change the links as you install your new Front End on
the server. Once you have the split configuration going, you can make
your changes and then just install the Front End, changing links as
required. Life will get a bit more complex when your changes require
a change in the table design. When that happens you're back into the
issue of getting the data from the older format into the new format
with no one else using the database.

A further complication is that best practice dictates that each user
have a copy of the Front End on their desktop. For ideas on how to
make it all work, look on Tony Toews's site for FE Updater.

HTH
--
-Larry-
--

"Frank" <tu**@yahoo.com > wrote in message
news:11******** *************@g 44g2000cwa.goog legroups.com...
We have an Access database Sch_S.mdb in the shared driver S across the network. I have a copy of that database in my local driver C, named as Sch_C.mdb. As per users' request I added some check boxes in the main form of the database, and added some relevant subroutines in that form.
Now I need to put the modified database Sch_C.mdb to the shared S
driver. Since new data had been added to tables (say T1, T2) in
Sch_S.mdb while I was working with Sch_C.mdb, I have to update the main form to Sch_S.mdb, or to update data in tables T1 and T2, in
Sch_C.mdb. What is the best way to do that?

What I am thinking is the following:
1. Send a note to users to stop using this shared database Sch_S.mdb
(or open Sch_S.mdb for exclusive use, so others will not be able to use it)
2. Delete all data in tables T1 and T2 in Sch_C.mdb, then import data from T1, T2 in Sch_S.mdb to T1, T2 in Sch_C.mdb
3. Move Sch_S.mdb to a back up folder in shared driver S, so we can
recover the old version in case of trouble.
4. Copy Sch_C.mdb from C to S, and Change its name to Sch_S.mdb
(Actually I am using the same name Sch.mdb in C and S)

Is that way working? Is there a simpler way to do that?

Thank you very much for your help!

Nov 13 '05 #2
Thank you very much for your help. I am trying to do that way...

Frank

Nov 13 '05 #3
I got some good reading on splitting here:

http://www.members.shaw.ca/AlbertKal...plit/index.htm
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com
http://www.members.shaw.ca/AlbertKallal
Nov 13 '05 #4

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

Similar topics

8
3356
by: Jan van Veldhuizen | last post by:
The UPDATE table FROM syntax is not supported by Oracle. I am looking for a syntax that is understood by both Oracle and SqlServer. Example: Table1: id name city city_id 1 john newyork null
0
1279
by: Neoharuo | last post by:
I am working on a VB2003 project that accesses a SQL Server database. The first two forms (frmA, frmB) are almost identicle as far as the processes and data access and updating. I've set it up so that they both use shared functions to access and update the data but two their respective tables. Neither form is open at the same time. I set up just one SqlDataAdapter that has a mulit-table select that pulls in the entire database and uses just...
4
2294
by: HEATHER CARTER-YOUNG | last post by:
Please help. I have two databases - one I'm designing that will be our in-house data mgmt system (db1) and another that is a federally-mandated system (db2). We must submit data from db2 but don't want to use this db for our data mgmt needs. Some of the fields in db1 are shared with db2 but the structure and field names are different. When I'm updating/creating records in db1 I want it to see if the record exists in db2 (shared ID number),...
7
2437
by: PC Datasheet | last post by:
Looking for suggestions ---- A database was designed for a national automobile inspection program. In it's simplest form, the database has two tables: TblOwner OwnerID <Year/Make/Model owned by owner, Owner name/address, etc) TblInspection InspectionID
11
3577
by: DFS | last post by:
Architecture: Access 2003 client, Oracle 9i repository, no Access security in place, ODBC linked tables. 100 or so users, in 3 or 4 groups (Oracle roles actually): Admins, Updaters and ReadOnly. Each group sees a different set of menu options when they open the client and login to Oracle. For the sake of speed I use pass-through queries here and there for updates and deletes. I update their SQL property in code and execute them.
7
1824
by: gthompson | last post by:
Is this possible: Read fields(rows/columns) from one sql database table (TableA). Then edit/update the same 'field' in TableA; and in TableB edit/update a different field - all at the same time? This is the current situation in an Access Form using Sql for the backend. We would like to convert this Access Form to a Web Form using Visual Studio.net and VB.net. Please help. Thanks, gthompson
2
2342
by: Scotty | last post by:
I get stuck to write an update, insert and delete command, i am looking for some help to start Whats the best way to update 2 tables toe the database (Access) below my code used to load my data.(2 tables) Do someone has a good sample code to help me? Many thanks in advance, Marc.
5
2187
by: explode | last post by:
I made a procedure Public Sub Novo(ByVal nova1 As String, ByVal nova2 As String) that creates a new oledbDataAdapter with insert update select and delete commads. I also added that commands can change depending how many columns are in a Table. I add a new column with this code: Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click Try...
9
2608
by: zmickle | last post by:
Experts and books all say that you can share an Access back end on a shared drive with the front end running on each host computer. I have a simple database that tracks student data and it is shared between 4 staff memebers. Each staff computer has a copy of the front-end (linked tables, forms, and queries). They basically only use one form. The form works like this
0
9923
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9767
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11081
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10806
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,...
0
9544
agi2029
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...
1
7939
isladogs
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...
0
5773
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4592
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
3
3214
bsmnconsultancy
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...

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.