Hi,
I have a flat database I created to share information and track pmt information. I have created Front Page "Database Results" pages to display pertinent information so that I only have to update the database in one place (my "back-up") - then I copy it to the Front Page (Intranet) server.
My institution is now wanting to use Sharepoint exclusively as our Intranet. But I am unable to move the database to Sharepoint. Not completely sure why. I saw the information about the new version of Access and how it will be very interactive with Sharepoint. But for now - that isn't the experience.
So...I am trying to get some kind of interactive or updatable queries into Sharepoint from the database I work in. I can only find information about how to create a linked querie FROM Sharepoint TO MS Access. Is there a way I can do it FROM Access TO Sharepoint?
The users now want to have some interactivity with the data instead of the FP "Database Results" pages. The Access "Data Access" pages leave too much to be desired - so can't use them.
Are there any other methods that one could suggest?
Thanks for your time!!!
I have a flat database I created to share information and track pmt information. I have created Front Page "Database Results" pages to display pertinent information so that I only have to update the database in one place (my "back-up") - then I copy it to the Front Page (Intranet) server.
My institution is now wanting to use Sharepoint exclusively as our Intranet. But I am unable to move the database to Sharepoint. Not completely sure why. I saw the information about the new version of Access and how it will be very interactive with Sharepoint. But for now - that isn't the experience.
So...I am trying to get some kind of interactive or updatable queries into Sharepoint from the database I work in. I can only find information about how to create a linked querie FROM Sharepoint TO MS Access. Is there a way I can do it FROM Access TO Sharepoint?The users now want to have some interactivity with the data instead of the FP "Database Results" pages. The Access "Data Access" pages leave too much to be desired - so can't use them.
Are there any other methods that one could suggest?
Thanks for your time!!!
