I am updating/improving a working database for a non-profit
organization. I am thinking of making a copy of the database at the
office, bringing the copy to my house, making the changes and then
copying the new/improved database back to the hard drive of the PC at
the office. While I am working on the copy of the database at home,
the database has data being entered into it at the office.
My question is: how can I copy the new database back to the PC at the
office and still keep the data that has been entered while I was
working on the database? Almost all of the data that is entered goes
into one table. Can I --copy/export/set that table aside-- , install
the new database and then pull that table into the new database? I am
not familiar with importing and exporting and I don't know if it works
for individual tables. I am looking for a sort of "best practices"
way to make these updates/improvements.
Thanks in advance for your help, tips and advice. 2 1845
Split the database into two:
- back end, contains tables only;
- front end, links tables, and has all other objects.
You can then update the front end without overwriting the b.e.
There is a splitter built in:
Tools | Database Utilities | Splitter
We have used this technique since version 1 of Access, and never even
consider developing any other way. More information: http://allenbrowne.com/ser-01.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"RC" <rc*********@ya hoo.com> wrote in message
news:3c******** *************** ***@posting.goo gle.com... I am updating/improving a working database for a non-profit organization. I am thinking of making a copy of the database at the office, bringing the copy to my house, making the changes and then copying the new/improved database back to the hard drive of the PC at the office. While I am working on the copy of the database at home, the database has data being entered into it at the office.
My question is: how can I copy the new database back to the PC at the office and still keep the data that has been entered while I was working on the database? Almost all of the data that is entered goes into one table. Can I --copy/export/set that table aside-- , install the new database and then pull that table into the new database? I am not familiar with importing and exporting and I don't know if it works for individual tables. I am looking for a sort of "best practices" way to make these updates/improvements.
Thanks in advance for your help, tips and advice.
Thank You! An easy and elegant solution. Fabulous. I will read up
on this Splitter Utility. It sounds perfect.
"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message news:<40******* *************** *@freenews.iine t.net.au>... Split the database into two: - back end, contains tables only; - front end, links tables, and has all other objects. You can then update the front end without overwriting the b.e.
There is a splitter built in: Tools | Database Utilities | Splitter
We have used this technique since version 1 of Access, and never even consider developing any other way. More information: http://allenbrowne.com/ser-01.html
-- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org.
"RC" <rc*********@ya hoo.com> wrote in message news:3c******** *************** ***@posting.goo gle.com... I am updating/improving a working database for a non-profit organization. I am thinking of making a copy of the database at the office, bringing the copy to my house, making the changes and then copying the new/improved database back to the hard drive of the PC at the office. While I am working on the copy of the database at home, the database has data being entered into it at the office.
My question is: how can I copy the new database back to the PC at the office and still keep the data that has been entered while I was working on the database? Almost all of the data that is entered goes into one table. Can I --copy/export/set that table aside-- , install the new database and then pull that table into the new database? I am not familiar with importing and exporting and I don't know if it works for individual tables. I am looking for a sort of "best practices" way to make these updates/improvements.
Thanks in advance for your help, tips and advice. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Ryan.Chowdhury |
last post by:
This is a general question regarding the use of view and stored
procedures. I'm fairly new to databases and SQL.
I've created a SQL database using an Access Data Project ("ADP") and
I'm satified with the table structure. I've moved on to building some
front ends for our users.
I'm running into situations where I want subreports to be built from
queries that are dependent on the values in other controls.
I've played with stored...
|
by: Dale Walker |
last post by:
Was wondering if anyone knew of any references for solving particular
database problems with Access.
For example, how to create databases with transaction tables (I know
they're not built in to Access, so I want to know how to construct
something similar myself), general ideas on keeping track of financial
information (e.g. simple nominal ledgers), how to simply append data
to both sides of a one-many pair from a similar one-many linked...
|
by: Marlene |
last post by:
Hi All
I have the following scenario, where I have found all the duplicates
in a table, based on an order number and a part number (item).I might
have something like this:
Order PODate Rec Qty Invoice# Item
Supplier Status POReceivedDate
570133 03/09/2004 50 0 DMEDIUM L0010 PENDING 03/09/2004
570133 03/09/2004 50 0 DMEDIUM L0010 PENDING 03/09/2004
570133 03/09/2004 50 0 DMEDIUM L0010 PENDING 03/09/2004
|
by: A P |
last post by:
Hi!
I have created a sample datagrid that can update data on a database. Please
help me solve the problem, I have attached both aspx and code behind
(aspx.vb):
______________________
datagrid.aspx
|
by: Doug Bell |
last post by:
Hi,
I thought I had this sorted this morning but it is still a problem.
My application has a DataAccess Class.
When it starts, it:
Connects to a DB (OLE DB)
If it connects it uses an OleDbCommand with an SQL String and the connection
it has a DataAdapter with the command
then it fills the DataSet's DataTable with the streamed data.
| |
by: mike11d11 |
last post by:
I'm trying to create an application that will have multiple users
working off a table on a SQL server. Since multi users will be
updating different records at any given moment, how can i get those
changes and merge them into my current Dataset. I've been playing
around with the GetChanges method and Acceptchanges but they just dont
seem to be pulling over the changes and updating my Dataset. Maybe if
someone could give me a sample of...
|
by: Aaron Reimann |
last post by:
I have a lot of check boxes. This is an update of the check boxes, I
want something was checked, then to do an insert (which is currently
working), if something is no longer checked...delete the checkbox
join/link that is in the database.
So, the insert/checked is working, but the "unchecking" is not working.
I don't know how to compare an array of what was not checked.
Here is my code:
if (is_array($_POST)) {
|
by: bbasberg |
last post by:
Hello,
I have been struggling with this problem for DAYS and have googled my heart out as well as reading any books I could get my hands on but I cannot find any specific references to my problem. I have been able to successfully loop through a directory reading spreadsheets that insert records into an Access database. The spreadsheets in said directory are all of the same format but have different values in the cells. It's when I turned...
|
by: jonbartlam |
last post by:
Hi There
I'm not sure what exactly is going wrong here. I'm writing an application that retreives a table from a database (tbl_internalfaults) and updates it. (Actually, just the status column will need updating with 'CLOSED' where necessary.)
I have been trying to use the OLEDB command builder to build the statement to update the database however it is returning an error whenever I try to do this.
I already have a dataset full of data, 1...
|
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...
|
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,...
| |
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...
|
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: 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: 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...
|
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: 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...
| |