How can I dynamically create a MS Access database?

[michaaal]

On my web server, I want my ASP code to check and see if the file called
"SECURITY.MDB" exists and if it doesn't then I want it to dynamically create
it with a table called "USERLIST" that contains the fields "USERNAME" and
"PASSWORD". How would I do this?

[Bob Barrows]

michaaal wrote:

> On my web server, I want my ASP code to check and see if the file
> called "SECURITY.MDB" exists and if it doesn't then I want it to
> dynamically create it with a table called "USERLIST" that contains
> the fields "USERNAME" and "PASSWORD". How would I do this?

To see if a database file exists:
[url]http://www.aspfaq.com/show.asp?id=2351[/url]

To create a database:
[url]http://www.aspfaq.com/show.asp?id=2029[/url]

HTH,
Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[michaaal]

> To create a database:

> [url]http://www.aspfaq.com/show.asp?id=2029[/url]

Bob I appreciate the above link, but when i run it I get this error message
in my browser...

a.. Error Type:
Provider (0x80004002)
No such interface supported
/include.inc, line 39

It seems that my computer doesn't like the "cat.create..." command. Any
thoughts?

T

[Bob Barrows]

michaaal wrote:

>> To create a database:
>> [url]http://www.aspfaq.com/show.asp?id=2029[/url]

>
> Bob I appreciate the above link, but when i run it I get this error
> message in my browser...
>
> a.. Error Type:
> Provider (0x80004002)
> No such interface supported
> /include.inc, line 39
>
> It seems that my computer doesn't like the "cat.create..." command.
> Any thoughts?
>
> T

I can't tell without seeing the code you attempted to use. The code works
for me. Is your MDAC installation up-to-date?

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"