Results 1 to 2 of 2
  1. #1
    shaunacol is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Sep 2012
    Posts
    55

    Unhappy Exporting to sharepoint web database

    My company wants to collect details about clients, their communications etc and would like it to be accessible from 'on the road' so we are considering using sharepoint to host a web database in MS access 2010.

    The sticking point is what a web enabled database can do and in particular I am worried about repoting and also about the regular importing of client details where I import emails from outlook (then I have a series of queries which breaks down the emails and updates the client table). So I am thinking of doing the following, but interested if people think this will work and if it is the best solution:

    1. Create a web enabled database which the sales force can access from anywhere. Call this database 1.
    2. Create another MS Access database (not web) which performs the function of importing data from emails (the lady who does this is always in office and has MS Access licence). Call this database 2. I can then link this to the 'working data' of database 1 so the lady can run the import and other complex reports which i believe the web version wont support
    3. Do regular 'pushes' of the new leads from database 2 to database 1



    What do people think? Will this work? My experience with sharepoint and web enabled databases is thruogh reading only so if there are any major things i havent thought through feel free to point them out. thanks!

  2. #2
    shaunacol is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Sep 2012
    Posts
    55
    this could be worded better point 2. should read

    Create another MS Access database (not web) which performs the function of importing data from emails (the lady who does this is always in office and has MS Access licence). Call this database 2. I would then like to link the 'working data' of database 1 into the back end of database 2 so the lady can see the real data, update it and run complex reports on it that (I believe) he cant do on the web version

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Importing and exporting data from a Sharepoint site
    By siddharthnk in forum SharePoint
    Replies: 0
    Last Post: 06-15-2012, 09:28 PM
  2. Replies: 0
    Last Post: 06-05-2012, 12:28 AM
  3. Issues Web Database in Sharepoint
    By abriscoe in forum SharePoint
    Replies: 6
    Last Post: 05-31-2012, 11:03 AM
  4. Replies: 0
    Last Post: 03-21-2012, 11:58 AM
  5. Sharepoint Lists vs Web database as backend
    By is49460 in forum SharePoint
    Replies: 1
    Last Post: 10-28-2011, 04:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums