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

Frank

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

Subscribe Reply

3704

Larry Daugherty

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

Frank

Thank you very much for your help. I am trying to do that way...

Frank

Nov 13 '05 #3

Albert D. Kallal

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

Similar topics

3329

common UPDATE syntax for SqlServer and Oracle

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

Microsoft SQL Server

1262

Can I update a multi-Table SQL Server Data Adapter in VB2003?

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...

.NET Framework

2276

Want updates in .mdb file to update other .mdb file too

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...

Microsoft Access / VBA

2411

Update foreign key before appending records to central database

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

Microsoft Access / VBA

3544

MS Access, Oracle 9i, security, and pass-thru update queries

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...

Microsoft Access / VBA

1809

Update 2 different Tables from one record?

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...

ASP.NET

2308

using strongly typed dataset update problem

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.

.NET Framework

2152

New columns and update problem...!

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...

Visual Basic .NET

2592

Multi user locking after first update

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...

Microsoft Access / VBA

7697

What is ONU?

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...

General

7612

Changing the language in Windows 10

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...

Windows Server

8120

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

7672

The easy way to turn off automatic updates for Windows 10/11

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...

Windows Server

7968

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

6283

AI Job Threat for Devs

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...

Career Advice

3640

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2113

transfer the data from one system to another through ip address

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

C# / C Sharp

937

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General