uploading and reading MSAccess databases

rustek

I am really hoping someone out there can help me.

I have created a php login scenario on an external isp's cgi servers.

So far so good, but as new users create their logins I'd like the php registration process to look up a database table that holds valid passwords so not just any Tom Dick or harry can register.

My problem is this: I don't hold the database. It is an MS Access databe maintained elsewhere in the country.

Is there anyway the database maintainer can, for example, ftp the MSAccess table (or query) straight to the server that holds my sql datafiles (the ones used in my php logins)

And then, what would be required for my php script to make the required checks?

Thanks for your help - Everyday I learn a heap more.

Danni

Hmmm maybe try something like this?

<%
Set MyConn = Server.CreateObject("ADODB.Connection")
MyConn.Open "FILEDSN=http://MyTable_dsn.dsn"
%>

<%
SQL_query = "SELECT * FROM Friends"
Set RS = MyConn.Execute(SQL_query)
%>

ect ect.

rustek

Hi Danni and thanks for the reply. (Love the Pic BTW)

Please excuse my ignorance as this is an area I am only just getting into and I really need a lot of hand-holding.

Do I assume from your script that the dbase table I would be looking up has to have a dsn extension? If so how do I create that from MS Access and where should it be stored. I am OK with creating tables from inside php as these are automatically stored on my isps sql server.

How would the remote MSAccess dbase holder ftp the dsn file?

Danni

Morning, 🙂

Id suggest reading over this, it may help.

http://author.webpub.net/devinfo/mdb/show-insert_and_verify.asp

rustek

Now THAT I like.
Thanks.

I will look over this and see if I can use it in my app.

You ever in the UK I'll buy you a drink.

Cheers x