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

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
rajendradewani
Forum Newbie
Posts: 3
Joined: Tue Nov 11, 2014 4:58 am

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

Post 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
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

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

Post 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.
rajendradewani
Forum Newbie
Posts: 3
Joined: Tue Nov 11, 2014 4:58 am

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

Post 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.
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

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

Post 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?
rajendradewani
Forum Newbie
Posts: 3
Joined: Tue Nov 11, 2014 4:58 am

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

Post 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
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

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

Post by requinix »

My feedback would be the same as mattficken's.

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