Lost in Linking

[jermadem]

the situation is as follows...

i have a web page with a personnel section which is generated from an Access database...
someone else who works here, who has more up to date personnel information, wants to be the one to update that section by just updating his own database table and having that reflected on the web page. So, instead of giving him access to our web server (where my database is), we created a new database and put it on our network server in a place that he and I can both access it.
Now, i've done the Get External Data > Link Tables thing and have that new table in my own database, but when i try to use it to generate the web content, it gives me this error: "[Microsoft][ODBC Microsoft Access Driver] Disk or network error."
I've verified the link with Linked Table Manager, but still nada...
Is it a DNS/ODBC type error or something? Does it have to know the path to the linked database as well?

thanks

 

[Navyguy]

Hi there jermadem

I have pretty limited knowlege when it comes to this stuff, but what I was thinking is that your web page is "looking" at the linked table (which holds nothing but the pathname to the data table) instead of looking at the actual data table. If you copied the data to your DB it would probably work, but that sort of defeats the purpose I suppose.

Just a thought, but like I said I really don't know much about this stuff.