Fra: John Coyle [EMAIL PROTECTED]
Dag, we've used Access too for various applications over the years,
including an Access 2 program that currently runs in 38 hospitals in our
state, and an Access 95 (became 97) program that manages the maintenance of
our city council's mobile phones and
DougF,
I don't know which version of Access you have been exposed to, but
from what you say, I think you have run way over to the far side.
Access97 is pretty stable in a single user environment, but not for
shared applications. Access2000 is a _lot_ better in this respect.
Take the AutoPug as
On 10 Sep 2003 at 9:12, Doug Franklin wrote:
Maybe I'm biased, in part, by the types of apps that I've worked
on with
databases in general and Access in particular. To me, you don't
go from
small to medium sized until you're talking about 100k records or
so.
Large doesn't start until
On 10 Sep 2003 at 14:30, Alan Abbott wrote:
Anyone any experience with MySQL?
We use MySQL for a project at work.
It has proven to be very stable. It was simple to install,
and has required no particular maintenance at all.
Don't know much about APIs available. The front-end we have is web
Another vote for FileMaker. Easiest to program that I ever saw.
Sylwester Pietrzyk wrote:
on 10.09.03 5:54, Doug Franklin at [EMAIL PROTECTED] wrote:
If it is, avoid it at all costs. Are you using OSX? If so, there are
tons of open source databases out there, and almost any of them will
beat
Mark, you may want to avoid thumbnails in the database if you're
talking huge amounts of pictures. If the database provides
a picture name that you can find quickly with a decent picture
browser and an organized series of picture folders, you'll probably
be able to ZIP or RAR your database to a
On Thu, 11 Sep 2003 12:39:12 +0200, Jostein wrote:
DougF,
I don't know which version of Access you have been exposed to, but
from what you say, I think you have run way over to the far side.
You're right. I was forced, against my will, judgement, and advice, to
implement serious, large
Lon Williamson [EMAIL PROTECTED] wrote:
Mark, you may want to avoid thumbnails in the database if you're
talking huge amounts of pictures. If the database provides
a picture name that you can find quickly with a decent picture
browser and an organized series of picture folders, you'll probably
John Coyle [EMAIL PROTECTED] wrote:
Dag, we've used Access too for various applications over the years,
including an Access 2 program that currently runs in 38 hospitals in our
state, and an Access 95 (became 97) program that manages the maintenance of
our city council's mobile phones and radios
Mark, you may want to avoid thumbnails in the database if you're
talking huge amounts of pictures.
BTW, I am sure someone has mentioned -- but, if they haven't, link
thumbnails, do not embed them in the database. Embedding graphics in an Access
database
bloats the whole thing memory-wise and
Fra: Doug Franklin [EMAIL PROTECTED]
On Tue, 09 Sep 2003 09:22:49 -0400, Mark Roberts wrote:
Is there anyone on the list with Access experience who can answer some
questions?
There's only one question that matters when Access is involved. And
the answer is run fast, run far, run
on 10.09.03 5:54, Doug Franklin at [EMAIL PROTECTED] wrote:
If it is, avoid it at all costs. Are you using OSX? If so, there are
tons of open source databases out there, and almost any of them will
beat Access in the long term.
And there is always very good FileMaker - for both - Classic
Hi,
Wednesday, September 10, 2003, 8:52:02 AM, you wrote:
Fra: Doug Franklin [EMAIL PROTECTED]
On Tue, 09 Sep 2003 09:22:49 -0400, Mark Roberts wrote:
Is there anyone on the list with Access experience who can answer some
questions?
There's only one question that matters when Access
OK, I've had a look:
You could start by trying this:
Under tools you choose relations and make a one to many link from the film number
in the film table to the film number in the image table. If you have mistyped some
film number you may get an error.
Next, when making a form for image data
[EMAIL PROTECTED] wrote:
Mark wrote:
What I'm most interested in is a way of automatically populating fields
in the Individual prints table with information from the film rolls
table after I enter the film roll # in a form.
OK, I've had a look:
You could start by trying this:
Under
On Wed, 10 Sep 2003 09:15:53 +0100, Bob Walkden wrote:
Despite all its faults, Access is an extremely useful
prototyping tool.
That I'll agree with. Prototype to your heart's content. And it's OK
for small databases with low turnover in the data, if you don't mind
taking customer calls
On Wed, 10 Sep 2003 9:52:02 +0200, [EMAIL PROTECTED] wrote:
[...] for small firms and home use it's OK. [...]
A critical caveat. I agree. For home use it's probably OK.
The only problem we had was that our based was built in Access
2.0, but when Access 97 arrived it turneed out that M$ had
to
look at the later versions though Office 97 is loaded on my machine.
--graywolf
http://graywolfphoto.com
- Original Message -
From: Doug Franklin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 10, 2003 9:12 AM
Subject: Re: Building a photo database. Any MS Access
På onsdag, 10. september 2003, kl. 15:23, skrev Mark Roberts:
This little project of mine is only for my personal use and will stay
on
Access 97 forever. It's just kind of nice to have a database that
works
exactly the way I want it and doesn't do anything more or less than I
need.
Just
Hi,
Wednesday, September 10, 2003, 2:30:15 PM, you wrote:
Anyone any experience with MySQL?
http://www.pgro.uk7.net/qu071401.htm
and
http://www.pgro.uk7.net/brand1.htm
should tell you all you need to know about MySQL.
I worked for a dot.com a few years ago who had their warehousing
database
Hi,
Wednesday, September 10, 2003, 2:30:15 PM, you wrote:
Anyone any experience with MySQL?
http://www.pgro.uk7.net/qu071401.htm
and
http://www.pgro.uk7.net/brand1.htm
should tell you all you need to know about MySQL.
Yep. It isn't a suitable tool for database wonks.
It's
Coyle
Brisbane, Australia
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 10, 2003 5:52 PM
Subject: Re: Re: Building a photo database. Any MS Access experts out there?
Fra: Doug Franklin [EMAIL PROTECTED]
On Tue, 09 Sep 2003 09:22:49
I've been putting together a photo database for myself using Microsoft
Access (it's the database I've got so that's what I'm using).
I now have it doing pretty much what I want it to do; I have a table
that holds information about each roll of film (roll ID #, film type,
camera used, year of
I've got an old database in Access '97 if you want to see and example of how it may be
done.
It's now about 700k, but if you have a new version of Access I can convert it to
Access 2002 and remove most of the data (which is in Norwegian - so you wouldn't want
it any way :-).
I haven't used it
I guess that was confusing :-)
Fra: [EMAIL PROTECTED]
It's now about 700k, but if you have a new version of Access I can convert it to
Access 2002 and remove most of the data (which is in Norwegian - so you wouldn't
want it any way :-).
I haven't used it for a while, but have exported
[EMAIL PROTECTED] wrote:
I've got an old database in Access '97 if you want to see and example of how it may
be done.
Actually, Access 97 is what I'm using.
What I'm most interested in is a way of automatically populating fields
in the Individual prints table with information from the film
I've been putting together a photo database for myself using Microsoft
Access (it's the database I've got so that's what I'm using).
I now have it doing pretty much what I want it to do; I have a table
that holds information about each roll of film (roll ID #, film type,
camera used, year of
I didn´t get as far as thumbnails, but it is possible to have sub
schemes and in the schemes. I´ve done this to insert a list of
categories (search words). You may be able to do the same thing as I
have if you insert a sub table incorporating the film information in
the scheme for each
Andre Langevin [EMAIL PROTECTED] wrote:
For those who might know: is Access available for Mac?
No. It's the only Microsoft Office app not available for Mac.
Is File Maker able to do such a job?
It should be. Don't know how many capabilities Access and File Maker
share, but I know people have
: [EMAIL PROTECTED]
Onderwerp: Building a photo database. Any MS Access experts out there?
I've been putting together a photo database for myself using Microsoft
Access (it's the database I've got so that's what I'm using).
I now have it doing pretty much what I want it to do; I have a table
database. Any MS Access experts out
there?
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 8bit
[EMAIL PROTECTED] wrote:
I've got an old database in Access '97 if you want to see and example
of how it may be done.
Actually, Access 97 is what
Mark Roberts wrote:
What I'm most interested in is a way of automatically populating fields
in the Individual prints table with information from the film rolls
table after I enter the film roll # in a form.
It sounds like you're trying to make an un-normalized data base here.
Access is
Last time I looked at FileMaker, it was
a) relational (a good thing)
b) one hell of a lot easier to learn than Access.
Andre Langevin wrote:
Mark, I cannot help much as I am myself in the process of finding a way
to do it (on a Mac). So I will rather be following advices.
For those who might
As an aside, I use this:
http://www.lightboxsoftware.com/
Not much use in Windows, but as a way of keeping thumbnails, it works fine...
Cheers,
Cotty
___/\__
|| (O) | People, Places, Pastiche
||=| www.macads.co.uk/snaps
_
Free UK Mac Ads
Message -
From: Mark Roberts [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 09, 2003 3:22 PM
Subject: Building a photo database. Any MS Access experts out there?
I've been putting together a photo database for myself using Microsoft
Access (it's the database I've got so
PROTECTED]
Sent: Tuesday, September 09, 2003 9:22 AM
Subject: Building a photo database. Any MS Access experts out there?
I've been putting together a photo database for myself using Microsoft
Access (it's the database I've got so that's what I'm using).
I now have it doing pretty much what I
On Tue, 09 Sep 2003 09:22:49 -0400, Mark Roberts wrote:
Is there anyone on the list with Access experience who can answer some
questions?
There's only one question that matters when Access is involved. And
the answer is run fast, run far, run until you're foaming at the
withers, but get away
On Tue, 09 Sep 2003 10:13:57 -0400, Mark Roberts wrote:
What I'm most interested in is a way of automatically populating fields
in the Individual prints table with information from the film rolls
table after I enter the film roll # in a form.
Just define them as auto-increment fields, as long
On Tue, 9 Sep 2003 10:48:18 -0400, Andre Langevin wrote:
For those who might know: is Access available for Mac?
If it is, avoid it at all costs. Are you using OSX? If so, there are
tons of open source databases out there, and almost any of them will
beat Access in the long term.
TTYL,
39 matches
Mail list logo