Page 1 of 1

Does PHP supports read/write from Linked tables in ms-access

Posted: Tue Nov 11, 2014 5:03 am
by rajendradewani
HI,
I have a ms-access file which has linked table. The linked table is connected to a ODBC source (e.g MS-SQL or 3rd Party ODBC Driver).
WebPage(php) Apache, connecting to a ODBC DSN of MS-Access, MS-Access is having linked tables. Linked tables as from another ODBC source.
On the PHP Page, When I am trying to connect the ms-access odbc dsn , I am able to connect.
But when I query any of the linked tables, PHP is not able to query and is failing.

Does php has capabilities to read/write to linked tables in ms-access file.
Or it is issue with MS-Access
Or is it I am missing something.

Regards
Rajendra Dewani

Re: Does PHP supports read/write from Linked tables in ms-ac

Posted: Tue Nov 11, 2014 5:23 am
by requinix
Normally I would say "Try it and find out", but you did and it didn't work. So no, that kind of functionality isn't available. It's probably something that only Access can read and understand.

Re: Does PHP supports read/write from Linked tables in ms-ac

Posted: Fri Nov 14, 2014 5:19 am
by rajendradewani
requinix wrote:Normally I would say "Try it and find out", but you did and it didn't work. So no, that kind of functionality isn't available. It's probably something that only Access can read and understand.
Yes, I did try and it did not work,
I used other programming language, ASP.NET and I am able to read.

So Either MS-Access's Linked table is not supported on PHP ( Access issue ) Or PHP is not supporting Linked tables from MS-Access ( PHP issue)

I want to know is it an issue with ms-access or issue with php.

Re: Does PHP supports read/write from Linked tables in ms-ac

Posted: Fri Nov 14, 2014 2:21 pm
by requinix
I don't know that. I doubt very many people on this planet know the answer to that.

Is your ASP.NET code using ODBC to connect, or another driver?

Re: Does PHP supports read/write from Linked tables in ms-ac

Posted: Tue Dec 09, 2014 2:48 am
by rajendradewani
Hi,

Microsoft says, its an bug/issue of PHP

https://social.msdn.microsoft.com/Forum ... =accessdev

Requesting you to please share your feedback
Regards
Raj

Re: Does PHP supports read/write from Linked tables in ms-ac

Posted: Tue Dec 09, 2014 1:05 pm
by requinix
My feedback would be the same as mattficken's.

Bug #68578 MS-Access's Linked tables are Not supported on PHP