Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006

    Anyone using Access frontends w/ SharePoint List backends?

    I took a simple 5 table database and pushed the tables out to a commercially provided SharePoint site as Lists, then linked the Lists as if they were tables. That way I can still run my Access reports while users can modify the data either through the SharePoint site, or through the Access frontend.

    This is great as an "accessible anywhere" client server database app.
    But the Lists are really lightweight compared to the standard Access tables (i.e. - no real relationships, ID field can't be renamed, etc.)

    I was just curious if anyone else has any experience with this.?

  2. #2
    Nem3s1S is offline Novice
    Windows Vista Access 2007
    Join Date
    Sep 2009
    Have you tried right clicking on the column title in sharepoint and choose Edit/Delete Column? When you do this SharePoint takes you to the edit page where you can edit the Column Name and change the type of information that goes into the column (i.e. Single Line Text, Number, Currency). Let me know if this helps

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

Similar Threads

  1. I can't create a drop-down list box
    By cpuser in forum Access
    Replies: 4
    Last Post: 02-18-2008, 10:11 AM
  2. list box
    By lead27 in forum Forms
    Replies: 0
    Last Post: 07-21-2007, 04:09 AM
  3. saving a list box to access table
    By newguy357 in forum Forms
    Replies: 0
    Last Post: 05-05-2006, 12:22 PM
  4. Problems with a query in a list box
    By admaldo in forum Forms
    Replies: 1
    Last Post: 04-05-2006, 05:28 PM
  5. Query List
    By sanjshah in forum Queries
    Replies: 3
    Last Post: 03-25-2006, 08:01 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