Can anyone share so insights as to anyone having successfully been able to upload an access database into SharePoint where the end users can alter, edit, deleted and save the information on the back end so that everyone else could see the changes made by others? The current SharePoint v2.0 allows me to upload a document and when I do it this way it will successfully take the whole database and even open it up in access but the problem we are having is the end users can make changes but the information just won't stay saved.
Please help with any suggestions. I have search Google extensively and there are only examples going from MS Access 2007 to SharePoint v3.0
4 6747
Can anyone share so insights as to anyone having successfully been able to upload an access database into SharePoint where the end users can alter, edit, deleted and save the information on the back end so that everyone else could see the changes made by others? The current SharePoint v2.0 allows me to upload a document and when I do it this way it will successfully take the whole database and even open it up in access but the problem we are having is the end users can make changes but the information just won't stay saved.
Please help with any suggestions. I have search Google extensively and there are only examples going from MS Access 2007 to SharePoint v3.0
Sharepoint is great for "Document" sharing and versioning. I don't know that it would be the ideal place for my database. A lot of the SharePoint can interact with SQL Server - if that is the case then you would actually be storing your database in a database.
Make sure all of the users have read/write access to the SharePoint folder and that all linked objects contain the full UNC (I.E. \\myserver\myfo lder\mydb.mdb) If you have linked ODBC tables, all users and/or groups have to have access to the ODBC source (SQL Server, Oracle, etc) as well. The security for the ODBC is seperate from Sharepoint.
Thx again for you help jaxjagfan, I can see you are indeed a valuable asset to this forum and I am sure myself and others appreciate your time and efforts invested.
I was ensured that every end user had read/write access to the SharePoint folder. This can be seen by each end user only. They tell me that they can read, write, edit, delete info on the database but when they close it and reopen it the information that was just entered or edited is no longer there. This is all new to me;
UNC (I.E. \\myserver\myfo lder\mydb.mdb) If you have linked ODBC tables, all users and/or groups have to have access to the ODBC source (SQL Server, Oracle, etc) as well. The security for the ODBC is seperate from Sharepoint.
Would you be willing to help me get thru this?
Thx again for you help jaxjagfan, I can see you are indeed a valuable asset to this forum and I am sure myself and others appreciate your time and efforts invested.
I was ensured that every end user had read/write access to the SharePoint folder. This can be seen by each end user only. They tell me that they can read, write, edit, delete info on the database but when they close it and reopen it the information that was just entered or edited is no longer there. This is all new to me;
Would you be willing to help me get thru this?
Is document versioning turned on? As changes are made to the database then SharePoint will save a new version of the database while maintaining the original with its original data.
I'm by no means a SharePoint guru. Just know enough to be dangerous :D
I'd recommend a SharePoint or Microsoft forum for a more definitive answer.
Is document versioning turned on? As changes are made to the database then SharePoint will save a new version of the database while maintaining the original with its original data.
I'm by no means a SharePoint guru. Just know enough to be dangerous :D
I'd recommend a SharePoint or Microsoft forum for a more definitive answer.
I wouldn't even know where to check is versioning is turned on. Do you have any recommendations for a SharePoint forum?
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: CoreyMas |
last post by:
Hello everyone,
Here is what I want to do.
I have an xml file that i have created using the dataset method writexml
(with schema). I want to write this to sharepoint. Do I have to do anything
to the filename property of the writexml method to save it to sharepoint?
I have never worked with sharepoint, so I need some assistance.
|
by: M. Jerine |
last post by:
Anyone know how to fix this problem? I'm running Windows
Server 2003 with MS Sharepoint Portal Server 2003. After
installing, I'm trying to access the "Sharepoint Central
Administration" web page and I get this error:
Access to the
path "D:\WINDOWS\Microsoft.NET\Framework\v1.1.4322
\Temporary ASP.NET Files\root\ad623ef9\1f9bb075" is
denied.
|
by: aaron.kempf |
last post by:
team
so i have a nice little list in sharepoint.. about 15k items
i've got the simplest little join statement in access; and im trying to
UPDATE the sharepoint list via an access query.
so im joining between my access table and then sharepoint list and i
get the infamous 'numeric field overflow'.
|
by: Neil |
last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is
upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server
at the same time. We're moving to SQL Server 2005, and, since he already has
licenses for Office Pro 2002, he wants to upgrade to that.
I've been saying that we need to upgrade to Access 2003, not 2002, even if
Office is kept at 2002. We are also looking to do a fair amount of...
|
by: craigc |
last post by:
hi,
i have recently migrated an app from my local machine to our dev web
server and i'm trying to upload a document from my local hard drive via
the web server to a sharepoint installation.
i'm getting the following error :
System.IO.DirectoryNotFoundException: Could not find a part of the path
"C:\Documents and Settings\cumminc\Desktop\1.jpg". at
| |
by: jasmith |
last post by:
How will Access fair in a year? Two years? .... The new version of
Access seems to service non programmers as a wizard interface to
quickly create databases via a fancy wizard. Furthermore, why would
you even continue to use Access as a backend when you have a much
superior option in SQL express?
What about as a future front-end development tool? Let's get serious.
Microsoft continues to publish numerous articles and videos on how you...
|
by: Bob Alston |
last post by:
Anyone know of any features of the new Access 2007 that will improve on
the ability of Access to work in a web environment???
Bob
|
by: Anns via AccessMonster.com |
last post by:
My establishment has about 20 ms access db's that will be converted over (see
subject).
When we pull all the BE's over to SQL and the FE's on Sharepoint (.net)
surely we don't have to change every user face, we should be able to use the
same FE in as before as now on Sharepoint?
ANSWER:
|
by: tregewitz |
last post by:
I am uploading a zip file using an HttpWebRequest and a PUT operation
to Sharepoint (2003) from a Windows Form application. When I upload
the same file using the Sharepoint Portal Web UI itself, the file
uploads in 1/3 the time. If I copy the file over the network using
Windows Explorer, it also copies in about 1/3 of the time.
I don't understand why it is taking so much longer transferring it in
this way.
I've tried several...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |