Access And Sharepoint

Jun 18, 2007

Apologies if this sounds vague , but I have developed a number of reports for an sql database which have selection criteria in certain forms. nothing too sophisticated . The company wants to increase the availability of the reports and the selection forms. Unfortunately Access on everyones PC is not part of the plan.
The concensus in the IT team is that Sharepoint is the route.

Does anyone know what would be required (in the way of programs , expertise etc) to convert or adapt an access database so that the forms and subsequent reports would be available sharepont.

I have had a dig around and I am not sure that our IT boys have got the full picture, I think that Sharepoint is dependent on access but I am not certain.

View Replies


ADVERTISEMENT

Publish Access To Web Without SharePoint?

Jan 21, 2012

Access to Web. Is it possible to publish access to web without SharePoint?

View 4 Replies View Related

Hosting Access On Sharepoint

Jun 12, 2015

I would like to publish my access file in sharepoint but I know very little about sharepoint and how to attain a free or testing or trial account. Essentially I would like others to access and edit the file on the web simultaneously.

All youtube sites speaks to how to get started using sharepoint but always assuming that you already have access but this is not my case. I need to know how to acquire sharepoint.

On my computer there is a sharepoint application which I installed but it seems to have no purpose.

View 11 Replies View Related

Can I Publish A Access/SQL Application On SharePoint

Feb 4, 2008

I have a Access - front end / SQL Server - back end application. I use an ODBC connection. I want to publish this on share point. The users have a windows account but they are not on the network. I can not create an ODBC connection for them. There is any way they can use this application?
Can I connect in different way to SQL?

Any help will be appreciaied. Thanks,
Mary

View 1 Replies View Related

Linking Access To Internet Without SharePoint?

Aug 7, 2015

I currently utilize my company's LAN structure to run my Access database from. The LAN structure is abhorrently slow. So slow that often the database crashes upon opening or can take many minutes to complete a menial command.

I realize that connecting my database to the internet would be a better solution (as our internet connection seems to work better). This would allow many users to interact with the database more easily as well. I also realize that SharePoint is the standard method of connecting the database either by linking tables or publishing the database itself. However, my company does not have SharePoint and I am tired of battling with them on obtaining it.

Is there another way to connect/link Access tables to the internet without SharePoint? One that is FREE. I know with Access 2003 you could connect Access to an HTML webpage, but I think Microsoft got rid of that functionality with 2010 and beyond to force users into utilizing SharePoint.

View 6 Replies View Related

Linking Two Access Databases In Sharepoint

Aug 22, 2012

I currently have two Access Databases (one with the raw 'data' and the other with the queries and reports that turn it into 'information' - the data database links into the other).

For contingency purposes, I now want to move both Databases onto sharepoint in case I have a system failure on my laptop (I don't have a server I can put these on). When I upload these onto Sharepoint the second database still seems to link to the file on my computer..

Is there a way I can get a Database to link into another database that's held on sharepoint?

View 1 Replies View Related

Windows Sharepoint Compared To Microsoft Access

May 4, 2007

Does anyone know the main differences of using Windows Sharepoint to share data compared with Access?

View 8 Replies View Related

General :: Reorder Records In A Sharepoint Access Database

Jun 8, 2015

I have an Access Database published as an app in my SharePoint.

When launch the app my records are shown in a form in ascending order. How can I have them displayed in descending order?

View 1 Replies View Related

General :: Linking Of Excel Sheets In SharePoint Directly To MS Access

Nov 4, 2013

I have a number of Excel spreadsheets (data sources) hosted on Sharepoint that I need to link to one single Access database.

At first. I cannot link the spreadsheets directly to Access because Access cannot read the spreadsheets on SharePoint to make the links.

Secondly, I can export the spreadsheets from SharePoint to a local folder on my PC and keep them 'refreshed'. The problem with this is that I cannot link Access to the local refreshed spreadsheets because of the (auto) extention .iqy. Access does not know the extention .iqy and hence the two cannot be linked at all.

Thus: How do I link an Excel spreadsheet hosted on SharePoint to MS Access.

View 3 Replies View Related

General :: Disable SharePoint Access Setting Option For Certain User

Oct 3, 2014

I just published an access database to sharepoint. However, after I set some user as contributor, those users can see structure of my database, and export tables to excel directly. Is there anyway that we can remove the access to "Setting"?

View 2 Replies View Related

Queries :: Access Web 2010 - Accessing Sharepoint Author And Modifier?

Mar 1, 2015

We're running an Access 2010 web database.

As expected when we published to Sharepoint additional fields were added to the Access tables [App Created By] and [App Modified by]. We want to use these fields for Audit information however they are always empty. How should they be populated?

View 3 Replies View Related

Splitting Access Database - Upload Back End Portion To SharePoint Site

May 12, 2015

I am attempting to split my Access Database and will upload the back-end portion to a SharePoint site. No matter what I do, I continue to get a "Not a valid file name" error.

View 1 Replies View Related

Tables :: Date / Time Field In Access 2010 Modified In Sharepoint List

Dec 2, 2013

I have a table in my Access 2010 Database with few date/time fields. I have set different formats like Short Time, Medium Time etc. But when I link this table to Sharepoint list, all the date/time fields have been modified to their default format (General Date).

Is there a way we can keep the formats as such even after linked to Sharepoint list? If not, is there a workaround?

View 2 Replies View Related

Microsoft SharePoint

Jan 22, 2007

I am running Windows Server 2003 for my company and require Microsoft SharePoint.

I've had a look on Microsoft.com but it confuses me with all kinds of stuff....

What do i need?

View 2 Replies View Related

Copying Sharepoint Database To Local

Aug 10, 2005

Hello,

I have a database that the table is located on a sharepoint website. This worked out well in the beginning but now that the database has thousands of records, it has slowed up a bit. What I want to do is at the load of the the database, it will automatically copy Sharepoint table to a local table located on the computer to speed up querys and such.

I was thinking an append query, am I right?


Mateo

View 1 Replies View Related

Forms :: Transferable Controls To Sharepoint Or Office 365

Jul 25, 2013

I believe a sharepoint BE with an Access FE is just a data stream isn't it? I don't think the displays are actually form objects, they're just representations and the data in the background streams to and fro.

What controls and placeholders on forms *not* to use if an Access application will eventually be migrated to Sharepoint or Office 365? I don't have much experience with either of these.

View 9 Replies View Related

Modules & VBA :: DAO Seek Linked Tables From SharePoint

Dec 18, 2013

I have two tables linked from SharePoint in Access 2007.

I need to update one table based on the data in another

My questions are

What is the best way to open linked tables - dynaset? Recordset?

are can I use the seek method?

View 1 Replies View Related

Tables :: Sharepoint Linked Table Uneditable

Aug 27, 2013

I'm just starting out to learn SharePoint, which I utterly hate thus far but anyway. So I have successfully linked to the sharepoint list in my DB, but I cannot edit any values for some reason. I can edit them in sharepoint and both systems update, but when I type in ANY box in access I get "Invalid arguement" error.... also note the new record button near the record navigators is greyed out so I can't add a record either.

I noticed that my library user group has URL... set to Read while all others are set to full control... is this the cause or something else?

View 1 Replies View Related

Accurately Splitting Up Last-name / First-name From A Sharepoint Link Into A Query?

May 30, 2012

I'm trying to separate LastName, FirstName into separate fields : FirstName and LastName. The code I have is working for the most part. But I had to create a separate query with the replace statement to get rid of the ","... Looking at the data now, I had people with names like Mac Buren, Tony and I'm only picking up the Mac part in my query.

Code:
SELECT Left([Employee Name],InStr([Employee Name]," ")) AS qryLastName, Right([Employee Name],Len([Employee Name])-InStrRev([Employee Name]," ")) AS [First Name], Employees.*
FROM Employees
ORDER BY Left([Employee Name],InStr([Employee Name]," "));

View 4 Replies View Related

General :: How To Save Sharepoint ACCDB To Standalone Front-end

Feb 11, 2015

I have a sharepoint database accdw which works well as I can update something and sync it to the server, and another user with the same database can receive the changes just by syncing.

However, I want to share a version of this database with a different start up form, some restricted forms etc. If I make a copy of the accdb it creates and make changes to that, it still synchronises those changes and they affect my own version.

What is the correct way to create a different database version from my accdw?

All I want to do is take the accdb it creates, change the startup form and give it to somebody to use.

View 1 Replies View Related

Tables :: Change In Sharepoint List Not Taking Effect?

Jul 24, 2013

I am importing data from a sharepoint list on to Access 2007, as linked data where any changes I make on Access is made to the list and vice versa. However, I recently made a change to one of the column types and this change is not being made on Access. I have changed a column type from choice to single line of text but I still see the list of choices when I access the list on Access 2007.

I have refreshed the list by right clicking the linked list and pressing refresh list. The list is set to not cache the list and is not set to work offline so cannot see why the change is not being made. I don't want to mess with the list be removing it and re-adding it as I have multiple queries set up which are being fed in to an excel file I use to create reports from the data. I have no knowledge of VBA, so there is none of that being used on Access.

View 1 Replies View Related

Tables :: Code To Refresh Sharepoint List Links?

Oct 29, 2012

I found 2 examples of code to refresh my attached table link to sharepoint lists.

I have a scheduled task open my Access 2010 db and an autoexec macro runs and closes the db.

My problem is my tables disconnect from sharepoint 2010 and the update fails.

I added the code I found to a module and added a line in my macro to run the code. Now I cannot get the code to work.

Am I at least on the right track? I just want to know before I spend many hours getting this code to work.

These are the two locations of code I found.

[URL]

I think part of my problem is that I have a regular table that I add a txt file to that is not linked to sharepoint so I need to exclude it from the code.

View 4 Replies View Related

General :: How To Split A Database For Uploading To Sharepoint Site

Dec 14, 2012

Is there a tutorial on how to split a database so that it can be uploaded to a sharepoint site and one part of it allows updates and the other part only viewing?

View 3 Replies View Related

Queries :: Crosstab Query And Cache List Data (sharepoint)

May 20, 2014

My data is on Sharepoint. I have a simple Crosstab query that works well unless I choose the option "Cache List Data". In that case I get a Type Mismatch error.

Code:
TRANSFORM Sum(PivotData.QuoteTotal) AS SumOfQuoteTotal
SELECT PivotData.FullName
FROM PivotData
GROUP BY PivotData.FullName
PIVOT PivotData.StatusText;

View 1 Replies View Related

Queries :: (Enter Parameter Value) Error When Updating SharePoint Table / List

Jun 24, 2015

I have a list (table) that I've created in sharepoint 2010.I link to the sharepoint table with Access 2010 to update mass amounts of items at once. Some of the queries have no problem updating the sharepoint items, but other queries require me to "Enter Paramater Value."

In this particular queries; I'm trying to populate field A with dates from field B, when field A is null.

---------------------
UPDATE Table 1 SET Table.[FieldA] = [FieldB]
WHERE (((Table 1.[FieldA]) Is Null));
--------------------

When I run the above, I receive the "Enter Parameter Value" input box.All records have Field B populated (it's actually the created date.)

The goal is for field A to be populated with the values in Field B, without the query asking for parameters.

Note; I can go in each individual record and update them via access, one at a time. But it's the running of the update query that failing.

Edit: Removed spaces in table and field names.

View 2 Replies View Related

General :: Multi Users Making Synchronous Changes To SharePoint List In Citrix Environment

May 27, 2013

I currently have the following setup for my database which is working as desired when only being used by one user at a time:

Front end: Access 2010 database in Citrix
Back end: SharePoint List

The problem is that only one user can open the Access Database at a time since this action locks the database for other potential users. The locking occurs due to this link to the back end SharePoint list.

allow multiple users to update the SharePoint list through the access database at the same time?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved