Hi, hoping someone can help.
Access 2003, WinXP.
I have built a database that uses synchro to co-ordinate with the
mothership.
All is well.
The person i built it for wants the satellites to be able to edit the
entries in their database until it is synchro-ed(sic?) with the mothership.
At that point they should only be able to add new entries and not edit
existing records.
Is this possible?
Any and all responses welcome.
--
Sharktyyfa
9  1525 
In general if they are working on the tables using a form where the
AllowAdditions is set to "yes" and the AllowEdits is set to "No" this would
suffice to meet one of your needs, but not the "in between Synch I can edit"
criterion.
Well, it is a conundrum, no doubt about it. Because you are asking to allow
them to selectively edit SOME records, but not ALL records, presumably from
the same table.
I guess one way is to work with a duplicate table ... When they synch, dump
the entire reservoire into another table, and let the Forms work from this
table. The second table gets flushed / refilled with every synch.
Just curious, Does synching cause items they "add" ... to get added to the
mother ship's tables? If so, added records will need to be added to both the
copied table and the main table on the satellite machine.
Just some dumb guesses as to procedure, don't know what kind of a
performance hit we're talking creating a second set of table(s).
"Sharktyyfa " <sh********@sha rktyyfa.com.tw> wrote in message
news:42******@c lear.net.nz... Hi, hoping someone can help.
Access 2003, WinXP.
I have built a database that uses synchro to co-ordinate with the
mothership.
All is well.
The person i built it for wants the satellites to be able to edit the
entries in their database until it is synchro-ed(sic?) with the
mothership.
At that point they should only be able to add new entries and not edit
existing records.
Is this possible?
Any and all responses welcome.
--
Sharktyyfa
Hi mate,
Thanks for the reply.
The client's plan is to have editing ability on the mothership only. The
mothership is a complete record and so is each laptop once synched.
The story behind it is that they have one employee who is not too competent
so they want to limit their potential to cause damage as they can check the
new ones added each day from the laptop.
I know, I know, I wouldn't let the employee near the laptop but there you
have it.
Cheers,
--
Sharktyyfa
"William Benson" <wbenson1(SPAMS UCKS)@nycap.rr. com> wrote in message
news:uc******** ******@tk2msftn gp13.phx.gbl... In general if they are working on the tables using a form where the
AllowAdditions is set to "yes" and the AllowEdits is set to "No" this
would suffice to meet one of your needs, but not the "in between Synch I
can edit" criterion.
Well, it is a conundrum, no doubt about it. Because you are asking to
allow them to selectively edit SOME records, but not ALL records,
presumably from the same table.
I guess one way is to work with a duplicate table ... When they synch,
dump the entire reservoire into another table, and let the Forms work from
this table. The second table gets flushed / refilled with every synch.
Just curious, Does synching cause items they "add" ... to get added to the
mother ship's tables? If so, added records will need to be added to both
the copied table and the main table on the satellite machine.
Just some dumb guesses as to procedure, don't know what kind of a
performance hit we're talking creating a second set of table(s).
"Sharktyyfa " <sh********@sha rktyyfa.com.tw> wrote in message
news:42******@c lear.net.nz... Hi, hoping someone can help.
Access 2003, WinXP.
I have built a database that uses synchro to co-ordinate with the
mothership.
All is well.
The person i built it for wants the satellites to be able to edit the
entries in their database until it is synchro-ed(sic?) with the
mothership.
At that point they should only be able to add new entries and not edit
existing records.
Is this possible?
Any and all responses welcome.
--
Sharktyyfa
In which case, all you need to do is synch, dump all data from the mother
ship into both the synched table and the editable one, and all forms and
editable queries will have the editable table as the source table? Bloat
anyone?
"Sharktyyfa " <sh********@sha rktyyfa.com.tw> wrote in message
news:42******@c lear.net.nz... Hi mate,
Thanks for the reply.
The client's plan is to have editing ability on the mothership only. The
mothership is a complete record and so is each laptop once synched.
The story behind it is that they have one employee who is not too
competent so they want to limit their potential to cause damage as they
can check the new ones added each day from the laptop.
I know, I know, I wouldn't let the employee near the laptop but there you
have it.
Cheers,
--
Sharktyyfa
"William Benson" <wbenson1(SPAMS UCKS)@nycap.rr. com> wrote in message
news:uc******** ******@tk2msftn gp13.phx.gbl... In general if they are working on the tables using a form where the
AllowAdditions is set to "yes" and the AllowEdits is set to "No" this
would suffice to meet one of your needs, but not the "in between Synch I
can edit" criterion.
Well, it is a conundrum, no doubt about it. Because you are asking to
allow them to selectively edit SOME records, but not ALL records,
presumably from the same table.
I guess one way is to work with a duplicate table ... When they synch,
dump the entire reservoire into another table, and let the Forms work
from this table. The second table gets flushed / refilled with every
synch.
Just curious, Does synching cause items they "add" ... to get added to
the mother ship's tables? If so, added records will need to be added to
both the copied table and the main table on the satellite machine.
Just some dumb guesses as to procedure, don't know what kind of a
performance hit we're talking creating a second set of table(s).
"Sharktyyfa " <sh********@sha rktyyfa.com.tw> wrote in message
news:42******@c lear.net.nz... Hi, hoping someone can help.
Access 2003, WinXP.
I have built a database that uses synchro to co-ordinate with the
mothership.
All is well.
The person i built it for wants the satellites to be able to edit the
entries in their database until it is synchro-ed(sic?) with the
mothership.
At that point they should only be able to add new entries and not edit
existing records.
Is this possible?
Any and all responses welcome.
--
Sharktyyfa
"William Benson" <wbenson1(SPAMS UCKS)@nycap.rr. com> wrote in
news:uc******** ******@tk2msftn gp13.phx.gbl: I guess one way is to work with a duplicate table ... When they
synch, dump the entire reservoire into another table, and let the
Forms work from this table. The second table gets flushed /
refilled with every synch. Just curious, Does synching cause items
they "add" ... to get added to the mother ship's tables? If so,
added records will need to be added to both the copied table and
the main table on the satellite machine.
Not an attractive option in a replicated application, which the
poster failed to explain clearly.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
"William Benson" <wbenson1(SPAMS UCKS)@nycap.rr. com> wrote in
news:uD******** ******@TK2MSFTN GP14.phx.gbl: In which case, all you need to do is synch, dump all data from the
mother ship into both the synched table and the editable one, and
all forms and editable queries will have the editable table as the
source table? Bloat anyone?
You're assuming synchronization in code, not via Jet replication.
Your suggestions are useless in a replicated scenario.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
"Sharktyyfa " <sh********@sha rktyyfa.com.tw> wrote in
news:42******@c lear.net.nz: Access 2003, WinXP.
I have built a database that uses synchro to co-ordinate with the
mothership.
All is well.
The person i built it for wants the satellites to be able to edit
the entries in their database until it is synchro-ed(sic?) with
the mothership.
At that point they should only be able to add new entries and not
edit existing records.
Is this possible?
You *still* didn't follow Larry's suggestion to include the word
REPLICATION in the subject. Because of that, I missed this new
thread and replied in the original one.
The suggestion to change the AllowEdits property of the forms on the
laptops is the best solution. However, it is not foolproof -- you'd
still need to secure your data tables.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Right, sorry. So - have you offered the OP a better plan, or are you not
aware of any? I was trying to help the OP, sorry if I goofed.
"David W. Fenton" <dX********@bwa y.net.invalid> wrote in message
news:Xn******** *************** **********@24.1 68.128.78... "William Benson" <wbenson1(SPAMS UCKS)@nycap.rr. com> wrote in
news:uD******** ******@TK2MSFTN GP14.phx.gbl:
In which case, all you need to do is synch, dump all data from the
mother ship into both the synched table and the editable one, and
all forms and editable queries will have the editable table as the
source table? Bloat anyone?
You're assuming synchronization in code, not via Jet replication.
Your suggestions are useless in a replicated scenario.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
"William Benson" <wbenson1(SPAMS UCKS)@nycap.rr. com> wrote in
news:O#******** ******@TK2MSFTN GP14.phx.gbl:
David W. Fenton" <dX********@bwa y.net.invalid> wrote in message news:Xn******** *************** **********@24.1 68.128.78... "William Benson" <wbenson1(SPAMS UCKS)@nycap.rr. com> wrote in
news:uD******** ******@TK2MSFTN GP14.phx.gbl:
In which case, all you need to do is synch, dump all data from
the mother ship into both the synched table and the editable
one, and all forms and editable queries will have the editable
table as the source table? Bloat anyone?
You're assuming synchronization in code, not via Jet replication.
Your suggestions are useless in a replicated scenario.
Right, sorry. So - have you offered the OP a better plan, or are
you not aware of any? I was trying to help the OP, sorry if I
goofed. "
Yes, but I posted in the original thread, because I was expecting
the new thread to have "replicatio n" in the subject, as Larry Linson
had recommended.
I suggested the same thing you suggested for setting the editing
properties of the form, well before I'd read either of your answers.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
What's the ol' expression: No good deed goes unpunished? :-)
"David W. Fenton" <dX********@bwa y.net.invalid> wrote in message
news:Xn******** *************** ***********@24. 168.128.78... "William Benson" <wbenson1(SPAMS UCKS)@nycap.rr. com> wrote in
news:O#******** ******@TK2MSFTN GP14.phx.gbl:
David W. Fenton" <dX********@bwa y.net.invalid> wrote in message news:Xn******** *************** **********@24.1 68.128.78... "William Benson" <wbenson1(SPAMS UCKS)@nycap.rr. com> wrote in
news:uD******** ******@TK2MSFTN GP14.phx.gbl:
In which case, all you need to do is synch, dump all data from
the mother ship into both the synched table and the editable
one, and all forms and editable queries will have the editable
table as the source table? Bloat anyone?
You're assuming synchronization in code, not via Jet replication.
Your suggestions are useless in a replicated scenario.
Right, sorry. So - have you offered the OP a better plan, or are
you not aware of any? I was trying to help the OP, sorry if I
goofed. "
Yes, but I posted in the original thread, because I was expecting
the new thread to have "replicatio n" in the subject, as Larry Linson
had recommended.
I suggested the same thing you suggested for setting the editing
properties of the form, well before I'd read either of your answers.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: JohnH |
last post by:
I have an ASP app (developed with Interdev 6) which uses
a DTC listbox (server-side) bound to a recordset to allow
the user to make a selection. This works fine until the
number of records in the record set seems to hit a limit
(not determined the exact limit, but seems to be c. 400).
If there are too many records, the app just hangs until
it hits the scripttimeout limit. I've tried increasing
both the command timout (I'm using an ADO...
|
by: mimisam |
last post by:
I have a table with a few hundreds records of products information. I
need to retrieve the top 10 records based on the sum of the products
quantity. My query is as below:
Select *, sum(qty) as SUMQTY ,sum(amount) as SUMAMOUNT from tdetail
group by barcode order by SUMQTY desc limit 10;
This query gave me 10 records of products(barcode). My problem is that
i need to have another 2 fields for the percentage calculation(
eg.sum(qty) of...
|
by: D. Dante Lorenso |
last post by:
I need to know that original number of rows that WOULD have been returned
by a SELECT statement if the LIMIT / OFFSET where not present in the
statement.
Is there a way to get this data from PG ?
SELECT
... ;
----> returns 100,000 rows
|
by: Hannu |
last post by:
Hi.
In the ldb file you can see the users of the mdb-file. If you open the
mdb-file your machine and username will be written in the lbd- file.
Allthough you close the mdb-file your name won't disappear from the
ldb-file, before every user has closed the mdb-file.
I have heard that there will be problems if the amount of users will
be over 10 in mdb-files. Is that true?
Hannu
|
by: deko |
last post by:
Is there any way to limit the number of records loaded into a ListBox?
I looked at qdf.MaxRecords (to apply to the query that is the RowSource of
the ListBox) but that only applies to ODBC data sources. I also looked at
Tools > Options > Edit/Find and tried setting the "Don't display lists where
more than this number of records read:" property, but that doesn't help.
The List Box in question is supposed to allow scrolling/browsing of...
| | |
by: VM |
last post by:
How can I limit the use of the PC's virtual memory? I'm running a process
that basically takes a txt file and loads it to a datatable. The problem is
that the file is over 400,000 lines long (77 MB) and after a while I get the
Windows message saying that the virtual memory's getting really low. Plus
the machine gets really sluggish (with multi-threading). Is it possible to
use the virtual memory until it reaches a certain limit and then use...
|
by: campbellwarren |
last post by:
Does anyone know how I could limit the number of rows allowed in a MS
Access table... want to limit it to 1.
|
by: claudia.carlotti |
last post by:
Anyone knows how to avoid the limit to 36000 records that access has
with a combo box?
Any help will be appreciated.
Many Thanks... Claudia
|
by: BEETHOVEN |
last post by:
I have an option group called Issue_Type on my main form
F1_Member_Demographics_Main. When I select one of the 3 options on the
main form from the option group Issue_Type I want to limit the sub
form F2_Member_Issues records based on the combo box Issue_Code_T1.
Option Group Issue_Type on main form:
1=Complaint
2=Grievance
3=Appeal
|
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: 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: 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: 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: 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...
| |
