473,320 Members | 2,097 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Accessing a locked MS Access Table with PHP

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
3 1726
Motoma
3,237 Expert 2GB
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
$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
3,237 Expert 2GB
$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

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

Similar topics

3
by: James Bird | last post by:
Hello In order to perform a hetrogeneous join (I think that's what they're called) between MySQL and another database, I've created an Access database containing linked tables from each...
2
by: Anastassios Giannaras | last post by:
Hello I have made an small access Database that is used by 4-5 people every day. Very often through the users get the message "Could Not Update; Currently Locked" There is an entry about that...
1
by: James Bird | last post by:
Hello In order to perform a hetrogeneous join (I think that's what they're called) between MySQL and another database, I've created an Access database containing linked tables from each...
1
by: University of Toronto | last post by:
Hi gang, Hopefully someone can help us out. In short - Access 2002, db split into a front end and back end. It appears that our backend db is locked. Our form bound to one table won't allow...
1
by: James Bird | last post by:
Hello In order to perform a hetrogeneous join (I think that's what they're called) between MySQL and another database, I've created an Access database containing linked tables from each...
14
by: johnsobd | last post by:
I am accessing an existing Foxpro database, of which I have no control over. I have been successful in accessing all the tables except for one. This one table I can access the first 9 fields in...
2
by: gbergeson | last post by:
I have the following code in an Access 2003 database: Dim myConnecion As ADODB.Connection Set myConnection = CurrentProject.Connection Dim myTable As ADODB.Recordset With myTable ...
5
by: breal | last post by:
I have a db table that holds a list of ports. There is a column in_use that is used as a flag for whether the port is currently in use. When choosing a port the table is read and the first...
11
by: fniles | last post by:
One of our application uses VB6 and Access97 database. Another application uses VB.NET 2005. This morning for about 15 seconds when the application tries to read either a query or a table from the...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.