Rejoin Split Database & Autonumbers

Article View: a2i.lists.inet-access

Article #77

Back to a2i.lists.inet-access Previous Next

#77

From: John Crolla
Date: Sun, 30 Apr 2000 00:00

17 lines
1428 bytes

Two Questions - Can you help?

1. Not being into VB and only using the built-in commands in MS Access I was
wondering if anyone can help me rejoin a split database. I want to work from
home on the office database but it wont run on my laptop unless connected to
the server at work.
If I download it from work and try to work off line I get  path fault.

2. After foolishly setting autonumbers which creates holes in records is
there a way to change from autonumbers to a formula that would commence from
the last autonumber and increment each time by one. In other words can I
change a Field Type without losing the existing entries.

Any help in language that a novice would understand would be appreciated.

John Crolla
john@jcrolla.freeserve.co.uk

Technical Details

Message-ID: <8eh3ec$p3j$1@newsg4.svr.pol.co.uk>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f61c3,eb50005d8c1c75a6,start
X-Google-Attributes: gidf61c3,public
From: "John Crolla" <john@jcrolla.freeserve.co.uk>
Subject: Rejoin Split Database & Autonumbers
Date: 2000/04/30
Message-ID: <8eh3ec$p3j$1@newsg4.svr.pol.co.uk>
X-Deja-AN: 617454694
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
X-Complaints-To: abuse@theplanet.net
X-Trace: newsg4.svr.pol.co.uk 957092108 25715 62.136.35.144 (30 Apr 2000 10:55:08 GMT)
Organization: Customer of Planet Online
X-MSMail-Priority: Normal
NNTP-Posting-Date: 30 Apr 2000 10:55:08 GMT
Newsgroups: a2i.lists.inet-access