This may soud the most basic question in the world, but how do i create an access database for use online?

I need oue with the collums 'username' & 'password' and i need my program to be able to read/ write to them. how do i do it?

I have opened up access and created a normal database, but how do i do one of the ones used on the web?

Please help if you can

KGB

There is no difference between your access database created on the desktop compared to one that is used on the web. All you need to do is to create an ASP connection script which access the database.

eg:

Dim strdbconone
Set strdbconone = Server.CreateObject("ADODB.Connection")
strdbconone = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("databasepath.mdb") & ";Jet OLEDBatabase Password=password;"

The above will create a connection to the database (replace 'databasepath' with you database path & password with your password if applicable)

The next script will create the recordset:

Dim rsPersonIDCheck
Set rspersonIDCheck = Server.CreateObject("ADODB.Recordset")
Dim strSQL
strSQL = "SELECT username, password FROM Person ;"
rsPersonIDCheck.Open strSQL, strdbconone

From this you can read and display records, if you wish to add records to the table then you need to open the table with the appropriate lock and command (adLockOptimistic) eg:


Set rsPersonIDCheck = Server.CreateObject("ADODB.Recordset")
rsPersonIDCheck.Open "tblUsers", strdbconone, 2,2

This will allow you to write to the database.
Once finished do not forget to close the recordset and database connection.

Hope this helps you,

If you need more help then PM me and i should be able to send you an example script.

Rich

Thanks, is there any particular format i need to save my database in, i am using dreamweaver to write to the database, so the code i should not need

thanks,

KGB

You'll just use the standard Access file format. Your database file should end with the .mdb extension.

it does, but where do i save it?

Save it anywhere your ASP script has access to.
When you set up the connection as in kingrich's post, change the path to point to your database.

thanks guys, in the end i managed to get a MySQL database to work

Thanks anyway

KGB