Help with linking to online Data

[dcroe05]

I'm pulling my hair out trying to figure out how to link to (or import) data from an online Access DB.

Here's the set up...
I've written an application, we'll Call it dbX, that's on a network drive and several people have access to it.

I've written a Webpage for others to submit requests. There is on online access database, dbY, which collects this information into a table.

So how can I make the table in dbY accessible from within dbX?

 

[JoeAtWork]

I'm not clear in what form you want to give the data to your users. Since you already save the information to the database from a web request, you must already know how to connect to the database (I assume with ADO or ADO.NET).

So if you just want to display the data to your users, you should be able to use the same connection to retrieve the data and render it to a webpage. If your web app is ASP.NET, that would be fairly trivial using a bound GridView control.

If your looking to set up some sort of live link to the database, I can't see how that's possible. You might look at creating a web service that returns data.

 

[dcroe05]

JoeAtWork,

dbY, the one that collect the data from the web is simply an ASP page created using FrontPage. dbX, the Access application, isn't used or accessed over the web at all.

A loose analogy would be a Help Desk request application.

I was hoping for a live link, but I'd be happy with some sort of data return.

I'm not sure what you mean when you suggest a "web service".

 

[JoeAtWork]

Here's a tutorial on using ADO to retrieve information from a database and display it on a web page:

http://www.w3schools.com/ado/default.asp

If you google "ASP ADO" you will be overwhelmed with information.

A web service is a way to make function calls over the internet to a web server. You can create them with ASP.NET, or with other non-Microsoft technologies.

 

[dcroe05]

I may have been unclear. I don't want to display anything on a webpage. I want to bring the data into another Access Database so I can work with it.