Link to a database on Intranet-server or web-server.

  • Thread starter Thread starter Roland
  • Start date Start date
R

Roland

when I try to link to a table on on Intranet-server or web-
server from a local access database (2002) I get a message
that the file name is not guilty. I type the URL-
addres //www.xxxxx/database/file.mde.
Why doesn't it work?
 
Is there any way to have a local client Access database use data from a web
server? I know it can be done if the database on the server is SQL Server,
via an Access Project. What about if the database on the server is an Access
database?

Thanks,

Mick Ruthven
 
Many people use Access as a back end to small web sites.
Not the best idea but it works.

You can use the ASP pages that are generated and interact that way.

You cannot use your local copy of Access and "point it" at the web site and
interact with it, if that is what you are getting at.
 
I was thinking of using Access as a special-purpose front end, not a back
end, residing on the client machine, and using the data in an Access
database on a web server. As I said, I know you can do that via an Access
Project if the web-server database is SQL Server (that is true, isn't it,
because I've done it), but I don't know if it's possible if the web-server
database is an Access database.
 
You can only do that if the client is on the same network as the web server.

http and Access do not go together.

Terminal Services is another way to handle remote issues.
--
Joe Fallon
Access MVP



Mick Ruthven said:
I was thinking of using Access as a special-purpose front end, not a back
end, residing on the client machine, and using the data in an Access
database on a web server. As I said, I know you can do that via an Access
Project if the web-server database is SQL Server (that is true, isn't it,
because I've done it), but I don't know if it's possible if the web-server
database is an Access database.
 
Joe, you do agree, don't you, that you can connect an Access client front
end to a SQL Server database on a web server using an Access Project?


Joe Fallon said:
You can only do that if the client is on the same network as the web server.

http and Access do not go together.

Terminal Services is another way to handle remote issues.
 
Joe, I was using the SQL Server Access Project as an example of what does
work, and asking if there were some way we could do the same type of thing
with an Access mdb database on the web server. I take it the answer is No.
 
Back
Top