I've built a simple DB and I'm having my users test it at a different
location running on a single workstation. Mean while I'm making
changes to the forms and reports on my workstation. How do I update
those changes to their database without losing data in the tables? Do
I copy and paste the specific form into the test DB?
4  1768 
On 3 Feb 2004 23:00:23 -0800 in comp.databases. ms-access, ma*******@byu.e du (Mark Lees) wrote: I've built a simple DB and I'm having my users test it at a different
location running on a single workstation. Mean while I'm making
changes to the forms and reports on my workstation. How do I update
those changes to their database without losing data in the tables? Do
I copy and paste the specific form into the test DB?
The usual method is to split the database into front-end forms,
queries, reports and code and another one with just the tables in,
then just replace the front end. There is a wizard to help you with
this and a linked table manager for re-linking the tables in a
different location.
--
A)bort, R)etry, I)nfluence with large hammer.
Trevor Best <bouncer@localh ost> wrote in message
The usual method is to split the database into front-end forms,
queries, reports and code and another one with just the tables in,
then just replace the front end. There is a wizard to help you with
this and a linked table manager for re-linking the tables in a
different location.
Trevor:
Thanks. A few questions though. 1. Can you split a database on a
single workstation? (I'm assuming so) 2. Where does the back end get
stored (default database folder?). How do you actually replace the
front end?
Thanks
Mark
On 5 Feb 2004 10:35:33 -0800 in comp.databases. ms-access, ma*******@byu.e du (Mark Lees) wrote: Trevor Best <bouncer@localh ost> wrote in message
The usual method is to split the database into front-end forms,
queries, reports and code and another one with just the tables in,
then just replace the front end. There is a wizard to help you with
this and a linked table manager for re-linking the tables in a
different location.
Trevor:
Thanks. A few questions though. 1. Can you split a database on a
single workstation? (I'm assuming so)
Yes.
2. Where does the back end get
stored (default database folder?).
Anywhere you want, use the linked table manager to tell the front-end
where the back-end is.
How do you actually replace the
front end?
You make the changes in your development PC, copy the MDB over to the
client's PC, since the back-end is separate, you don't overwrite their
data in doing so.
--
A)bort, R)etry, I)nfluence with large hammer.
Trevor:
I really appreciate the help!
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: khan |
last post by:
this is my code, it is updating QTY on Hand when you make a new sale or
if you got some product returned. Now as it is updating QTY when qty
textbox lost focus if some one is going through records and whenever
this qty text box will losee focus it will be fired and change the
quantity in the product table. I want it, to be fired only ig user...
|
by: willow1480 |
last post by:
I am developing a small little Service Control Application. I am
using a listview control with checkboxes and getting the list of
services I want to control from a text file. When you check a
checkbox, it should either stop the service or start the service
depending on each respective service's status. I want the listView
to update the...
|
by: BG |
last post by:
We're having trouble writing the code to update a UI control (label.Text)
from a secondary thread. We're using C# with Windows Forms.
We have a main form named MainForm, a splash screen form named SplashScreen,
and a C# class library named BackgroundProcess.
|
by: DW |
last post by:
I've gotten this question a couple of times in interviews and I don't know
what they are looking for:
How do you update a control's property, such as a textbox.text property,
from a thread, in .NET? It seems to me you just update it normally. What
are the interviewers looking for here? Thanks.
- W
|
by: trint |
last post by:
I have a textbox (textBox7) that isn't updating..
Is there a way, after I type new text in it, to have it update?
It seems to be fairly normal:
public class Form1
: System.Windows.Forms.Form
{
private System.Windows.Forms.TextBox textBox7;
......
private void InitializeComponent()
| | |
by: Chad |
last post by:
Hello Everybody,
I am trying to update a few textboxes automatically in vb.net. I have a
timer updating the variables which are assigned to the textbox.text
attribute, I would like to have the textbox then update its display. I am
using a parent form with two child forms, both child forms are displayed and
would like to automatically update...
|
by: explode |
last post by:
My table has 5 columns: Broj iksice, Prezime, Ime, Broj indeksa, Broj
pohadjanja.
This is the code in the dataset designer VB made it by it self:
Private Sub InitClass()
Me.columnBroj_iksice = New System.Data.DataColumn("Broj iksice",
GetType(Double), Nothing, System.Data.MappingType.Element)...
|
by: sara |
last post by:
I have a Memo field in a table to hold notes from a conversation a
social worker has had with a client (this is for a non-profit).
If the user needs to update the memo field, I need to find the
original record (which I am doing fine - getting the correct key)
and
I need to update the "notes" with the new value from the form, which I
store...
|
by: aaronyoung |
last post by:
I have created custom navigation buttons and Record Number indicators on several forms that are used to review and update records based on a query.
My On Current event to update the "Record X of Y" is
Private Sub Form_Current()
Dim frm As Form, LastRec As Long
Set frm = Forms!ReviewSearchRecordsForm
|
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...
|
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...
| | |
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. ...
|
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...
|
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...
|
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...
|
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...
|
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...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
