Web Linked Information from Database (1 Viewer)

[access2010]

We would like to place our Access 2003 = Portfolio_Website.Mdb = onto our web site which will be accessible from our web page.
Our live database is = Portfolio_Sources.Mdb
Our web database is = Portfolio_Website.Mdb

Was I correct in linking the table = Portfolio_Website_T = from
= Portfolio_Website Mdb = to the = Portfolio_Sources.Mdb =

My problem is how to get the data from
= Portfolio_Sources.Mdb = to = Portfolio_Website.Mdb =

Your suggestions will be appreciated
Thank you.
Nicole

 

[theDBguy]

Hi. If you want to use a web page to work with your databases, you don't really have to connect them. Your web page code should do that. Otherwise, you could combine the two databases into one for your web page.

 

[access2010]

Thank you, TheDBguy, for your note.
The charity that I volenteer at only wants CERTAIN information available to the staff visiting their web page and that was why I created a LIMITED amount of viewable Web Site Data.
The data that will be available will be data retrieved from Yahoo on the Equities which are in their Endowment.
Could you please suggest how I can Populate The data in the Linked Table?

Thank you.
Nicole

 

[theDBguy]

Thank you, TheDBguy, for your note.
The charity that I volenteer at only wants CERTAIN information available to the staff visiting their web page and that was why I created a LIMITED amount of viewable Web Site Data.
The data that will be available will be data retrieved from Yahoo on the Equities which are in their Endowment.
Could you please suggest how I can Populate The data in the Linked Table?

Thank you.
Nicole

Hi. Populating a separate database for your "web only" clients should not be a problem. Are you limiting the columns or the records? If the "web only" database is simply for "looking," then the simplest approach might be to create local tables, in your main database, for export to the "web only" database. Each time you export the data, the old data is replaced.

Of course, you can also link the "web only" database to your main database and use UPDATE or APPEND queries to populate the "web only" tables. Either way, you would probably do these data updates locally and then replace the db file on your web server with the new file.

Hope that helps...

 

[access2010]

Thank you for your note.
Could you please let me know, as to what I have done wrong as my Update Query is not working?
===
The database in the Web Site will be updated every week with changed data.
Would we be better off to use an Update or Append Query?

Thank you.
Nicole

 

[theDBguy]

Thank you for your note.
Could you please let me know, as to what I have done wrong as my Update Query is not working?
===
The database in the Web Site will be updated every week with changed data.
Would we be better off to use an Update or Append Query?

Thank you.
Nicole

Hi. Not in front of a computer right now, so I will take a look later.

Sent from phone...