Dear David,
Having managed a team of up to 16 sales persons I have subjective reality on
the fact that the best salespersons are at best ordinary record keepers.
Add to that the fact that I would want them prospecting and selling rather
than
doing data entry.
Therefore I would see a viable option would be to allow them access to all the
data they need to perform their job and allow them to add new records to empty
copies of the key tables that would be imported into the main database on
the weekly update.
It would not be too much work at all to create an import routine from the copy
tables. This would work best if changed addresses, contacts etc were a minor
task that could be imparted to a data entry person.
At 05:27 PM 26/08/2001 +0100, you wrote:
>We currently run a three machine network under win98, but having taken on a
>Business Development Manager, It has been decided he will be given a Laptop
>and will have a full version of the DB on his stand alone laptop.
>
>We consider he will come to the office once a week and upload his database,
>leaving later that day with an upgraded and packed new version. I've
>developed a long and meaningful relationship with 'the men's room' just
>thinking about the implications and have made two important discoveries
>which may be of help to anyone in a similar situation in the future -
>Adrenalin has a smell and it's coloured.
>
>Having posed relatively few questions in the past, perhaps 'long service'
>entitles me to these.
>
>1. Autonumbering (say cliID) in the above situation.
>Currently a simple autonumber increments by 1 for each new client.
>False inserts are ignored - having gaps in the numbering sequence is not an
>issue.
>
>2. How do I tackle the following situation.
>Monday we all start with the same database.
>The Bus Dev Mgr gets his version on his laptop
>Tues/Wed/Thur/Fri he meets several Clients and makes some changes to their
>data on his machine.
>During that same week, we at Base also make changes to some of those same
>clients on our Base database.
>The following Monday BusDevMgr comes in to upload his laptop and later that
>day leaves with a fully updated and packed version.
>
>PC Anywhere with evening downloads is something I have considered, but that
>will not overcome the issues the above situation will create. I have
>devoured Anne Gillihans Inside R:Base and am now thinking euthanasia is the
>next best move!
>
>I know from past experience those of you who feel able will give your best
>advice and will commit a fair bit of thought and time to your answers.
>Again I can only say Thanks in advance, but as this is such an important
>area, I'm sure there are many 'silent learners' like me who will also
>benefit greatly from your learned solutions.
>
>David Atkinson
>skidbusters.co.uk
>
>[EMAIL PROTECTED]
Warmest regards,
Tom Grimshaw
coy: Just For You Software
tel: 612 9552 3311
fax: 612 9566 2164
mobile: 0414 675 903
post: PO Box 470 Glebe NSW 2037 Australia
street: 3/66 Wentworth Park Rd Glebe NSW 2037
email: [EMAIL PROTECTED]
web: www.just4usoftware.com.au
This email and any files transmitted with it are confidential to the
intended recipient and may be privileged. If you have received this email
inadvertently or you are not the intended recipient, you may not
disseminate, distribute, copy or in any way rely on it. Further, you should
notify the sender immediately and delete the email from your computer.
Whilst we have taken precautions to alert us to the presence of computer
viruses, we cannot guarantee that this email and any files transmitted with
it are free from such viruses.
