Limit to New records only after synchro

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********@sharktyyfa.com.tw> wrote in message
news:42******@clear.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

Nov 13 '05 #2

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(SPAMSUCKS)@nycap.rr.com> wrote in message
news:uc**************@tk2msftngp13.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********@sharktyyfa.com.tw> wrote in message
news:42******@clear.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

Nov 13 '05 #3

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********@sharktyyfa.com.tw> wrote in message
news:42******@clear.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(SPAMSUCKS)@nycap.rr.com> wrote in message
news:uc**************@tk2msftngp13.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********@sharktyyfa.com.tw> wrote in message
news:42******@clear.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

Nov 13 '05 #4

"William Benson" <wbenson1(SPAMSUCKS)@nycap.rr.com> wrote in
news:uc**************@tk2msftngp13.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

Nov 13 '05 #5

"William Benson" <wbenson1(SPAMSUCKS)@nycap.rr.com> wrote in
news:uD**************@TK2MSFTNGP14.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

Nov 13 '05 #6

"Sharktyyfa" <sh********@sharktyyfa.com.tw> wrote in
news:42******@clear.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

Nov 13 '05 #7

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********@bway.net.invalid> wrote in message
news:Xn*********************************@24.168.12 8.78...

"William Benson" <wbenson1(SPAMSUCKS)@nycap.rr.com> wrote in
news:uD**************@TK2MSFTNGP14.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

Nov 13 '05 #8

"William Benson" <wbenson1(SPAMSUCKS)@nycap.rr.com> wrote in
news:O#**************@TK2MSFTNGP14.phx.gbl:

David W. Fenton" <dX********@bway.net.invalid> wrote in

message news:Xn*********************************@24.168.12 8.78...
"William Benson" <wbenson1(SPAMSUCKS)@nycap.rr.com> wrote in
news:uD**************@TK2MSFTNGP14.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 "replication" 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

Nov 13 '05 #9

Limit on HTML listbox entries?

What's the ol' expression: No good deed goes unpunished? :-)

"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:Xn**********************************@24.168.1 28.78...

"William Benson" <wbenson1(SPAMSUCKS)@nycap.rr.com> wrote in
news:O#**************@TK2MSFTNGP14.phx.gbl:

David W. Fenton" <dX********@bway.net.invalid> wrote in
message news:Xn*********************************@24.168.12 8.78...
"William Benson" <wbenson1(SPAMSUCKS)@nycap.rr.com> wrote in
news:uD**************@TK2MSFTNGP14.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 "replication" 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

Nov 13 '05 #10

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

ASP / Active Server Pages

getting other data after using LIMIT?

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

MySQL Database

Find original number of rows before applied LIMIT/OFFSET?

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

PostgreSQL Database

Limit of users in Ms-Access?

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

How to limit records displayed in ListBox?

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

How to limit use of virtual memory in my Win application?

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

C# / C Sharp

set a limit to the number of rows allowed in a table

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.

Access limit a combo to 36000 records

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

Limit Sub Form records based on Main Form

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