Re: [BCAB] DATABASE APPLICATION Steve Bingham 28 Sep 2011 16:37 BST

Excel is out because my main table has double the number of records allowed
by Excel - maximum rows per sheet is only 65000!!

I have looked at Excel and it has possibilities but I would need to change
the basis of my database.

Obviously I did a lot of work to set up the current system including writing
a complex update program and other programs to allowing browsing in various
ways.

One option I have been looking at is converting the whole things to a set of
html documents. It is comparatively easy to write a program to generate the
html. Modern search facilities could then be used to do a lot of the work
currently done by the indexes. This would have been fairly easy with the
Windows XP search but it does not look so easy in Windows 7. I cannot for
example find out how to search all the documents in a given folder for a
known phrase. It should be possible but I haven't found out how.

Steve

-----Original Message-----
From: bcab-bounces@lists.bcab.org.uk [mailto:bcab-bounces@lists.bcab.org.uk]
On Behalf Of Graham Page
Sent: 28 September 2011 13:53
To: 'BCAB Discussion List'
Subject: Re: [BCAB] DATABASE APPLICATION

Creating a relational database with a number of linked tables in excel could
be possible but it is likely to be rather tricky.  You would need to use a
workbook and refer to data in different worksheets within that workbook.

-----Original Message-----
From: bcab-bounces@lists.bcab.org.uk [mailto:bcab-bounces@lists.bcab.org.uk]
On Behalf Of Alan Philpott
Sent: 28 September 2011 11:08
To: BCAB Discussion List
Subject: Re: [BCAB] DATABASE APPLICATION

Absolutely; glad you agree.

-----Original Message-----
From: bcab-bounces@lists.bcab.org.uk
[mailto:bcab-bounces@lists.bcab.org.uk]On Behalf Of Richard
Godfrey-McKay
Sent: 28 September 2011 10:59
To: 'BCAB Discussion List'
Subject: Re: [BCAB] DATABASE APPLICATION

Steve, I've always found that Excel has met my needs in this respect.
Admittedly it was usually client databases, but I was surprised at how much
you could do which I hadn't realised.

Richard

Richard Godfrey-McKay

Telephone: 01738-445 880

Mobile: 07791 452 593

-----Original Message-----
From: bcab-bounces@lists.bcab.org.uk [mailto:bcab-bounces@lists.bcab.org.uk]
On Behalf Of Steve Bingham
Sent: 28 September 2011 10:47
To: 'BCAB Discussion List'
Subject: [BCAB] DATABASE APPLICATION

Hi

Does anybody know of a reasonably accessible alternative to Microsoft
Access.

I have a fairly substantial database at present running on a very old
version of dBase III in an DOS window on a Windows XP computer. It has
survived several computer upgrades but has now reached the end of the line
because our new computers are all 64-bit machines and, of course, the old
dBase III will not run on them.

The database consists of three main tables each with multiple indexes and a
number of subtables.

I have spent some time contemplating switching to Microsoft Access but I
have find that it is too formal and not really accessible enough. I could
use it but not very happily.

Any suggestions would be welcome.

Steve Bingham

--
To find out more about BCAB and the benefits that membership can bring,
please visit our website:
http://www.bcab.org.uk/

To manage your subscription to the BCAB mailing list, please visit our
website:
http://www.bcab.org.uk/bcab-discussion-list/

To discuss matters relating to the mailing list, please email
moderator@bcab.org.uk.

--
To find out more about BCAB and the benefits that membership can bring,
please visit our website:
http://www.bcab.org.uk/

To manage your subscription to the BCAB mailing list, please visit our
website:
http://www.bcab.org.uk/bcab-discussion-list/

To discuss matters relating to the mailing list, please email
moderator@bcab.org.uk.

__________ NOD32 6499 (20110927) Information __________

This message was checked by NOD32 antivirus system.
http://www.eset.com

--
To find out more about BCAB and the benefits that membership can bring,
please visit our website:
http://www.bcab.org.uk/

To manage your subscription to the BCAB mailing list, please visit our
website:
http://www.bcab.org.uk/bcab-discussion-list/

To discuss matters relating to the mailing list, please email
moderator@bcab.org.uk.

--
To find out more about BCAB and the benefits that membership can bring,
please visit our website:
http://www.bcab.org.uk/

To manage your subscription to the BCAB mailing list, please visit our
website:
http://www.bcab.org.uk/bcab-discussion-list/

To discuss matters relating to the mailing list, please email
moderator@bcab.org.uk.