<html><div style='background-color:'><DIV>
<P>I am using the SelHeight property to get the number of selected records on a continuous form. The thing is...all of a sudden (that should be a secret Access command) AllOfASudden<BR>SelHeight is returning zero when records ARE selected...this is wreaking havoc on my otherwise very nice delete routine. Anybody seen anything like this? All the other 'Sel' values are fine (SelTop,SelWidth). I have closed it out, compacted repaired - I have not decompiled yet. </P></DIV>_d<BR><BR><BR>
<DIV></DIV>
<DIV><FONT face="Geneva, Arial, Sans-serif" color=#6666ff size=2><EM>"Things are only free to the extent that you don't pay for them." </EM></FONT></DIV>
<DIV><FONT color=#33cc66></FONT></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>>From: John Skolits <ASKOLITS@OT.COM>
<DIV></DIV>>Reply-To: accessd@databaseadvisors.com
<DIV></DIV>>To: accessd@databaseadvisors.com
<DIV></DIV>>Subject: RE: [AccessD] Replication Manager or Briefcase
<DIV></DIV>>Date: Tue, 13 May 2003 10:14:08 -0400
<DIV></DIV>>
<DIV></DIV>>MessageSo if I understand this, you suggest foregoing the FE/BE design,
<DIV></DIV>>place everything in one DB and use replication? HMMM interesting.
<DIV></DIV>>
<DIV></DIV>>But, if I have 5 of 7 users on a local network, I would want their data
<DIV></DIV>>refreshes to be immediate on the data tables. The remote users won't care if
<DIV></DIV>>they refresh only periodically.
<DIV></DIV>>I would think that in this scenario, I would prefer to have a FE/BE design
<DIV></DIV>>on the local network with the one shared BE being a replica. On the remotes,
<DIV></DIV>>I would also want FE/BE design but all their individual BEs be separate
<DIV></DIV>>replicas.
<DIV></DIV>>But, now I'm mixing a shared BE and remote replica BEs. Is this a bad idea?
<DIV></DIV>>
<DIV></DIV>>In addition, I like the idea of one replica on a local server (sub-hub)
<DIV></DIV>>managed by a synchronizer and then synchronized with the main hub replica.
<DIV></DIV>>But, I thought each replica on the satellite PCs had to have a drop box. If
<DIV></DIV>>that's so, don't you have to install RepMnger on each PC have to have the
<DIV></DIV>>drop boxes?
<DIV></DIV>>
<DIV></DIV>>Gee, a lot to learn.
<DIV></DIV>>
<DIV></DIV>>John
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>> -----Original Message-----
<DIV></DIV>> From: accessd-bounces@databaseadvisors.com
<DIV></DIV>>[mailto:accessd-bounces@databaseadvisors.com]On Behalf Of Arthur Fuller
<DIV></DIV>> Sent: Tuesday, May 13, 2003 9:06 AM
<DIV></DIV>> To: accessd@databaseadvisors.com
<DIV></DIV>> Subject: RE: [AccessD] Replication Manager or Briefcase
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>> No you do not have to install RM on each machine. I have quite a bit of
<DIV></DIV>>experience (and good stories) with RM, so allow me....
<DIV></DIV>>
<DIV></DIV>> In my first experiments with replication, I needed to replicate a db among
<DIV></DIV>>4 branch offices connected over the net with a vpn. In this phase, each
<DIV></DIV>>office had a server that was being hit by each local pc. The server at HQ
<DIV></DIV>>had the synchronizer installed, and it replicated among the office servers
<DIV></DIV>>every 15 minutes. It worked flawlessly. Then I got to thinking that this
<DIV></DIV>>same scenario would work locally, and eliminate 90% of the net traffic that
<DIV></DIV>>a classic FE/BE would normally incur. So I set up a synchronizer on each
<DIV></DIV>>branch server, and a replica on each local pc. The branch server
<DIV></DIV>>synchronized the local pcs with the server BE every 5 minutes, and the HQ
<DIV></DIV>>server synchronized the branch server replicas.
<DIV></DIV>>
<DIV></DIV>> All replicas were set up as managed replicas, save one: the master
<DIV></DIV>>replica, which resided on my development box, alongside my own managed
<DIV></DIV>>replica. When I modified tables etc. and changed the FE to work against the
<DIV></DIV>>master correctly, tested etc., I was then ready to publish the changes. I
<DIV></DIV>>manually synched my master replica with my local replica. Five minutes later
<DIV></DIV>>it synched with the branch replica, propagating the changes both locally and
<DIV></DIV>>company-wide. It worked flawlessly for months, until eventually we migrated
<DIV></DIV>>to SQL 2000.
<DIV></DIV>>
<DIV></DIV>> As a result of these experiments, I am now convinced that the classic
<DIV></DIV>>FE/BE setup is obsolete. The setup outlined above, even for a single office
<DIV></DIV>>with say 20 users, is dramatically faster than the classic layout.
<DIV></DIV>>
<DIV></DIV>> Arthur
<DIV></DIV>>
<DIV></DIV>> -----Original Message-----
<DIV></DIV>> From: accessd-bounces@databaseadvisors.com
<DIV></DIV>>[mailto:accessd-bounces@databaseadvisors.com] On Behalf Of John Skolits
<DIV></DIV>> Sent: May 13, 2003 8:45 AM
<DIV></DIV>> To: accessd@databaseadvisors.com
<DIV></DIV>> Subject: RE: [AccessD] Replication Manager or Briefcase
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>> Andrew,
<DIV></DIV>>
<DIV></DIV>> Thanks for getting back to me. I looked at Mike's site (haven't been
<DIV></DIV>>there for a while- Gee I wish he had a search tool).
<DIV></DIV>>
<DIV></DIV>> I also posted on the MS newsgroup and Mike responded. Here was his
<DIV></DIV>>comment:
<DIV></DIV>>
<DIV></DIV>> "Do not use the briefcase. It is less painful to hit your hand with a
<DIV></DIV>>hammer
<DIV></DIV>> than to put yourself through that kind of pain.
<DIV></DIV>> MichKa [MS]"
<DIV></DIV>>
<DIV></DIV>> I like the way he is so direct. Anyway, I've been doing a lot of reading
<DIV></DIV>>from newsgroup postings and I'm confused about one thing.
<DIV></DIV>> I'm getting the impression that I do have to install the Rep Mngr app on
<DIV></DIV>>each machine.
<DIV></DIV>> I'm thinking that I will want to periodically do indirect Sync to my hub
<DIV></DIV>>database but in order to do that, I will need the synchronizer on each PC.
<DIV></DIV>>
<DIV></DIV>> Here is a posting that talks about it. Is this person wrong or do I
<DIV></DIV>>misunderstand something.
<DIV></DIV>> Go to the following link and select the posting with the topic: "What is
<DIV></DIV>>the best way to do this"
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>http://support.microsoft.com/newsgroups/default.aspx?NewsGroup=microsoft.pub
<DIV></DIV>>lic.access.replication&SLCID=US&ICP=GSS3&sd=GN&id=fh;en-us;newsgroups
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>> John
<DIV></DIV>>
<DIV></DIV>> -----Original Message-----
<DIV></DIV>> From: accessd-bounces@databaseadvisors.com
<DIV></DIV>>[mailto:accessd-bounces@databaseadvisors.com]On Behalf Of Haslett, Andrew
<DIV></DIV>> Sent: Monday, May 12, 2003 11:06 PM
<DIV></DIV>> To: 'accessd@databaseadvisors.com'
<DIV></DIV>> Subject: RE: [AccessD] Replication Manager or Briefcase
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>> Check out Michael Kaplans site:
<DIV></DIV>> http://www.trigeminal.com
<DIV></DIV>>
<DIV></DIV>> He's the guru of Access Replication, and among other things, has made
<DIV></DIV>>his own 'replication manager' much more powerful than the one from MS. The
<DIV></DIV>>are a number of excellent articles on replication on his site also.
<DIV></DIV>>
<DIV></DIV>> Additionally, you shouldn't need to install a replication manager on
<DIV></DIV>>each machine.
<DIV></DIV>>
<DIV></DIV>> Cheers,
<DIV></DIV>> Andrew
<DIV></DIV>>
<DIV></DIV>> ----Original Message-----
<DIV></DIV>> From: John Skolits [mailto:askolits@ot.com]
<DIV></DIV>> Sent: Tuesday, 13 May 2003 1:34 AM
<DIV></DIV>> To: accessd@databaseadvisors.com
<DIV></DIV>> Subject: [AccessD] Replication Manager or Briefcase
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>> I'm trying to decide which is the best method to handle replication.
<DIV></DIV>>
<DIV></DIV>> This will involve around 7 users.
<DIV></DIV>>
<DIV></DIV>> I have 2 office locations: 1 in Philadelphia and 1 in Cleveland. The
<DIV></DIV>>are connected with an Asynchronous line. Therefore the data connection will
<DIV></DIV>>be slow. They will eventually switch to a regular T1 line, but not for a few
<DIV></DIV>>months.
<DIV></DIV>>
<DIV></DIV>> I have looked at the Replication Manager which looks like a good fit
<DIV></DIV>>but I would have to install it on all the PC's and (I believe) have the
<DIV></DIV>>synchronizer running on the server where everyone would replicate to. I
<DIV></DIV>>would then do indirect synchronization.
<DIV></DIV>>
<DIV></DIV>> Someone said they used the Briefcase to do the synchronizations.
<DIV></DIV>>With that method, I would not have to install Replication Manager on all the
<DIV></DIV>>PC's.
<DIV></DIV>>
<DIV></DIV>> This is not mission critical information so the briefcase looks like
<DIV></DIV>>a better solution with much less programming overhead.
<DIV></DIV>>
<DIV></DIV>> Anyone have any insights on this?
<DIV></DIV>>
<DIV></DIV>> John
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>> IMPORTANT - PLEASE READ ********************
<DIV></DIV>>
<DIV></DIV>> This email and any files transmitted with it are confidential and may
<DIV></DIV>>
<DIV></DIV>> contain information protected by law from disclosure.
<DIV></DIV>>
<DIV></DIV>> If you have received this message in error, please notify the sender
<DIV></DIV>>
<DIV></DIV>> immediately and delete this email from your system.
<DIV></DIV>>
<DIV></DIV>> No warranty is given that this email or files, if attached to this
<DIV></DIV>>
<DIV></DIV>> email, are free from computer viruses or other defects. They
<DIV></DIV>>
<DIV></DIV>> are provided on the basis the user assumes all responsibility for
<DIV></DIV>>
<DIV></DIV>> loss, damage or consequence resulting directly or indirectly from
<DIV></DIV>>
<DIV></DIV>> their use, whether caused by the negligence of the sender or not.
<DIV></DIV>>_______________________________________________
<DIV></DIV>>AccessD mailing list
<DIV></DIV>>AccessD@databaseadvisors.com
<DIV></DIV>>http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>>Website: http://www.databaseadvisors.com
<DIV></DIV></div><br clear=all><hr>Protect your PC - <a href="http://g.msn.com/8HMJENUS/2755??PS=">Click here</a> for McAfee.com VirusScan Online </html>