Microsoft SharePoint
Jan 22, 2007I 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?
ADVERTISEMENT
Windows Sharepoint Compared To Microsoft Access
May 4, 2007Does anyone know the main differences of using Windows Sharepoint to share data compared with Access?
View 8 Replies View RelatedHELP!!! Error: [Microsoft][ODBC Microsoft Access Driver] Invalid SQL Statement Expect
Mar 27, 2007My main experience is with MySQL and PHP so I'm kindof stumbling around in the dark here. Heres my story:
We recieved a new server and migrating from (Windows Server 2000, IIS 5.0, Access 2000) to (Windows Server 2003, IIS 6.0, Access 2003) has been nothing but problems.
I have setup IIS to work with ASP, I've also setup a system DSN. The access file was copied over from the previous server. We're running Access 2003 and now I can't seem to get this ASP script to work.
When I try to upload a file to the script I get this error:
Line: 42
Char: 7
Error: HELP!!! Error: [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement expected 'DELETE','INSERT','PROCEDURE','SELECT', OR 'UPDATE'.
Code: 0
Url: (URL address blocked: See forum rules)
Here is the part of Connect.asp that errors:
Code:<script LANGUAGE="javascript"><!--var DSNString, TheDF, TheRS;//DSNString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C: hedata estdisbo.mdb;User Id=admin;Password=;";//DSNString = "Driver={Microsoft Access Driver (*.mdb)};Dbq=C: hedata estdisbo.mdb;Uid=Admin;Pw d=;"DSNString = "DSN=testweb; UID=; PWD=";function public_ConToDB(){ TheDF = DP.CreateObject("RDSServer.DataFactory",this.text1.value);DC.DataSpace=DP;DC.Server = this.text1.value;DC.Connect = DSNString;//DC.Connect="d: hedatadisboweb.udl";}function public_GetRS(SQLCommand){ TheRS = TheDF.Query(DSNString,SQLCommand);DC.SourceRecordset=TheRS;return (TheRS);}function public_GetDC(){ return (DC);}//--></script>
Its included in a file called FileRead.htm here is the part that refers to the error lines:
Code: var TheFile, FileStrm;// Retrieved field namesvar M_ssn, M_inits, M_Lname, M_Fname, M_DSSN, M_ruc, M_paycode;var M_normamt, M_payamt, M_pgrp, M_poe, M_pltcd, Payrollnum, Payrolldate;// var Trash, FieldData, FieldNames;var TrashLineNum = 1;// Create the file Stream Object (ReadOnly)TheFile = new ActiveXObject("Scripting.FileSystemObject");FileStrm = TheFile.OpenTextFile(FName,1,false);// Setup the Database Connectionvar SQLCommand, TheRS, TheConnection, DSNString, Commands, MyDC;FieldNames = new Array("ssn","inits","lname","fname","dssn","ruc","cco", "payamt","normamt","notsureone","pgrp","poe", "pltcode","recstatus","paychgflg","paystatuscode", "payrollnum","payrolldate");// Connect the the DatabaseDataLib.ConToDB();MyDC = DataLib.GetDC();// Get Payroll NumberPString = prompt("Enter Payroll Number","025");Payrollnum = parseInt(PString,10);// Get Payroll DateDString = prompt("Enter Payroll Date","20000101");Payrolldate = DateLib.FromMil(DString);// Setup the Database Connectionvar NumRecs = 0;//MyTest = DataLib.GetRS("PaydayUpdate1");alert("About to cross into the CurExtract!!!");MyRS = DataLib.GetRS("SELECT * FROM CurExtract");
I set an alert after this line but it doesn't pop up.
ANY HELP WOULD BE VERY GREATLY APPRECIATED. I'll be checking this very frequently.
Sincerly,
Joseph Russell
Microsoft Access & Microsoft SQL.
Aug 7, 2006Questions / Help :
What I would like to know about Microsoft SQL Server & Access 2003 :
I am a novice at creating my own database.
I would like to use Microsoft SQL Server & Access 2003 .
I have in the last 3 months read all I can about creating a database in Microsoft Access 2003 .
Now I need to learn about Microsoft SQL Server, and it is very different from Access 2003.
I have purchase many bussiness applications over the last 5 years, and fount that over software are to rigid, as I need something very specifil to my bussness.
If you intend to reply, please be very specific & in plain English.
Can someone help me ?
1Can Microsoft SQL Server 2000 work with Microsoft access 2003.
a.Is this do-able .
2Can Mysql also work with Microsoft access 2003
3What is the difference between Microsoft SQL Server & Mysql.
4And any other information that may help me.
Thank You For Your Time.
John Calcitrai.
Access And Sharepoint
Jun 18, 2007Apologies 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.
Converting From Microsoft Access 2.0 To Microsoft Access 2003
Jul 10, 2006Hello everyone,
I would like to convert a database, which was made for me, in order to enable it to be used on my current system.
I get the error message below when trying to open the database in Microsoft Access 2003.
The database was made using Microsoft Access 2.0.
Will I need Microsoft Access 2.0 to update/delete the database all the time?
Or can I convert this to be used with Microsoft Access 2003?
I have tried opening the file exclusively and I get the same error.
I have selected Show Help and it advises me to import all the objects from the database into a new database. This can`t be achieved as I can`t open the file to retrieve the contents.
http://images6.theimagehosting.com/error.6de.PNG
Thank you very much for your help and all responses are appreciated,
Sam
Converting From Microsoft Access 2.0 To Microsoft Access 2003
Jul 10, 2006Hello everyone,
I would like to convert a database, which was made for me, in order to enable it to be used on my current system.
I get the error message below when trying to open the database in Microsoft Access 2003.
The database was made using Microsoft Access 2.0.
Will I need Microsoft Access 2.0 to update/delete the database all the time?
Or can I convert this to be used with Microsoft Access 2003?
I have tried opening the file exclusively and I get the same error.
I have selected Show Help and it advises me to import all the objects from the database into a new database. This can`t be achieved as I can`t open the file to retrieve the contents.
http://images6.theimagehosting.com/error.6de.PNG
Thank you very much for your help and all responses are appreciated,
Sam
Publish Access To Web Without SharePoint?
Jan 21, 2012Access to Web. Is it possible to publish access to web without SharePoint?
View 4 Replies View RelatedHosting Access On Sharepoint
Jun 12, 2015I 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.
Can I Publish A Access/SQL Application On SharePoint
Feb 4, 2008I 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
Copying Sharepoint Database To Local
Aug 10, 2005Hello,
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
Linking Access To Internet Without SharePoint?
Aug 7, 2015I 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.
Linking Two Access Databases In Sharepoint
Aug 22, 2012I 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?
Forms :: Transferable Controls To Sharepoint Or Office 365
Jul 25, 2013I 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.
Modules & VBA :: DAO Seek Linked Tables From SharePoint
Dec 18, 2013I 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?
Tables :: Sharepoint Linked Table Uneditable
Aug 27, 2013I'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?
Accurately Splitting Up Last-name / First-name From A Sharepoint Link Into A Query?
May 30, 2012I'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]," "));
General :: How To Save Sharepoint ACCDB To Standalone Front-end
Feb 11, 2015I 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.
Tables :: Change In Sharepoint List Not Taking Effect?
Jul 24, 2013I 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.
Tables :: Code To Refresh Sharepoint List Links?
Oct 29, 2012I 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.
General :: How To Split A Database For Uploading To Sharepoint Site
Dec 14, 2012Is 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 RelatedGeneral :: Reorder Records In A Sharepoint Access Database
Jun 8, 2015I 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?
General :: Linking Of Excel Sheets In SharePoint Directly To MS Access
Nov 4, 2013I 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.
General :: Disable SharePoint Access Setting Option For Certain User
Oct 3, 2014I 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 RelatedQueries :: Access Web 2010 - Accessing Sharepoint Author And Modifier?
Mar 1, 2015We'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?
Queries :: Crosstab Query And Cache List Data (sharepoint)
May 20, 2014My 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;