10-13-03, 17:18 #1Registered User
- Join Date
- Oct 2003
Unanswered: [Q] How to Open Access database with Linked Table???
I've googled and didn't find much information on this matter... Maybe I don't know where to look for...
Okay... I've got a db1.mdb file from my potential client... He wants me create a little working demo to see if this project is good for them or not...
(Flash project that is linked to the database via PHP...)
When I tried to open the file in MS Access 2002, it seems to be opening fine, but when I double click on one of table, I get to see this message...
ODBC--connection to 'BiltmoreORS' failed.
(What is that black dot thing right next to the icon??? What does that mean???)
So, I went to ODBC section and added an User DNS entry like this...
Setting - Control Panel - Administrative Tools - Data Sources (ODBC)
User DNS - Add - Microsoft Access Driver (*.mdb) - Finish
Data Source Name : BiltmoreORS
Description : BiltmoreORS Database
Database - Select - db1.mdb - OK
(I had not add any login/pass information in it cuz I have not gotten any from him thinking that there is none involved in it...)
But that didn't let me open the database either...
It seems like it has linked table that it cannot be found since I get this when I right click on the table and select Linked Table Manager...
So... What would be the things that I have to ask him so that I can work on this at home??? As you can see, I am not good at Access, so I need your help desperately...
Thank you very much...