Re: Access / ASP hacked insert

"Gord D via AccessMonster.com" <u4943@uwe> wrote in
54d9210ac8e87@uwe:">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
.

Relevant Pages

  • Re: Sign In/Out Program
    ... ADO is capable of MULTI USER that the database is open by many user at ... used DAO and ms access database for single user only. ... DAO works well with Jet. ... but mdb is a file-based database and will have the same ...
    (microsoft.public.vb.general.discussion)
  • Re: ACCESS and ASP
    ... you should be aware that earlier versions of Jet required a "*" ... > Please post ASP questions in ASP groups, ... > When you delete a record from a database, ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)
  • Re: Can Access handle it?
    ... The maximum size of a Jet (MDB) database is 2GB, so at 50 MB per month, ... Follow-up questions should in general be posted to the ...
    (microsoft.public.access.externaldata)
  • Re: update 500000 records with adodb.recordset resize the mdb from 140M to 2G
    ... > 4) I was talking about a database with 1 table because I moved this table ... > out from the original mdb. ... since this mdb database is a front end to an oracle database, ... Oracle is almost infinitely more capable than Jet? ...
    (microsoft.public.vb.database.ado)
  • Re: Saving Back-End Data As mdf
    ... your JET database to SQL Server in order to use it with VB.NET, ... is perfectly capable of working with JET (MDB) databases. ...
    (microsoft.public.access.formscoding)