"Gord D via AccessMonster.com" <u4943@uwe> wrote in
news:54d9210ac8e87@uwe:
David W. Fenton wrote: I have a small ASP website with an Access2000 database.
No, actually, you don't.
You have a small ASP webisite with a Jet 4 database that you used
Access 2000 to create.
Because of that, your problem is not an Access question.
Sorry but i'm sure it is an Access database. When I double click
the file Guestbook.mdb the window caption says "Microsoft Access".
Is there another way i can confirm this. Sometimes there is a
Help... About feature. Could you tell me where to find the Help
menu?
No, if it's being used by ASP, ASP is using *none* of the Access
aspects of the file. It only uses Jet objects, tables and queries.
ASP knows nothing of forms or reports, etc., and those are the
Access objects, which are stored in Jet tables.
You can create an MDB without using Access at all, simply by using
DAO commands. The resulting MDB is smaller and leaner because it
lacks all the properties that Access adds to tables and queries.
I don't do anything but Access development, so I've never had any
call to use Jet only, but if I were using an MDB for the data on a
web page, I might consider creating it programmatically with Jet
alone precisely to get the leaner MDB file out of it.
You could still use Access to view the file directly, as it won't
add the properties after the Jet objects are created (though it will
show then, say, in table view, with no value for those properties).
As to what Windows Explorer tells you, that has zilch to do with the
actual content of a file. If you took a Microsoft word file and
changed the extension from DOC to MDB, it, too will be listed as a
Microsoft Access file, even though you know perfectly well that it
is nothing of the sort.
--
David W. Fenton
http://www.bway.net/~dfenton
dfenton at bway dot net
http://www.bway.net/~dfassoc