By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,830 Members | 2,271 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,830 IT Pros & Developers. It's quick & easy.

Accessing a locked MS Access Table with PHP

P: 2
I'm currently working on a project for my stage and im having slight problems accessing a locked MS Access table

I have password and username for the table but i can't seem to figure out how to implement these in my coding so that i may then use the table.

im sure theres a way but i have yet to find it.

thanks in advance
Feb 20 '07 #1
Share this Question
Share on Google+
3 Replies


Motoma
Expert 2.5K+
P: 3,235
I'm currently working on a project for my stage and im having slight problems accessing a locked MS Access table

I have password and username for the table but i can't seem to figure out how to implement these in my coding so that i may then use the table.

im sure theres a way but i have yet to find it.

thanks in advance
Welcome to theScripts Porthos.
Could you paste in the code you have, so we can see what you have tried?
Feb 20 '07 #2

P: 2
$conn = new COM("ADODB.Connection") or die('Connect start ADO.');
$conn -> Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=*.mdb;");

that is what i have as a connection

now im guessing that this is the right argument syntax
Open(source,actconn,mode,createopt,opt,username,ps word)

but i cant seem to get it to work in php...
Feb 20 '07 #3

Motoma
Expert 2.5K+
P: 3,235
$conn = new COM("ADODB.Connection") or die('Connect start ADO.');
$conn -> Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=*.mdb;");

that is what i have as a connection

now im guessing that this is the right argument syntax
Open(source,actconn,mode,createopt,opt,username,ps word)

but i cant seem to get it to work in php...
Have you tried using the ADOdb Database Abstraction Library for this?

[PHP]
$db =& ADONewConnection('access');
$dsn = "Driver={Microsoft Access Driver (*.mdb)};Dbq=d:\\northwind.mdb;Uid=Admin;Pwd=;";
$db->Connect($dsn);
[/PHP]
Feb 20 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.