Hello,
I am developing an Access 2013 database and am in the final stages. I have an excel work book I need to open and be able to edit from the database via a command button. The excel workbook happens to reside on the company share point site. I can get it to open, problem is that it only opens in read only, and doesn't provide an option to change to edit... is there a way to code the command button to open the excel file in edit mode with or without a prompt to do so? I wanted to convert the spreadsheet to an access form, but its too complicated for me to do so and I am on a tight deadline.
Is it possible that when I put the database on the share the problem will go away on its own? could I get that lucky?
Thanks for your input!
sooli
3  4658  twinnyfo 3,653
Recognized Expert Moderator Specialist
sooli,
Placing the DB on the share will not help, as MS Access will either 1) not function the same or have the same features you want as a SharePoint database or 2) have the same issue you are having now, only that users will download the DB from SharePoint.
Your problem sounds more like a Network/SharePoint permissions issue and not an MS Access problem.
We can, however, help you access the Spreadsheet via an MS Access Form, but, again, if the permissions you have are for read only, you will face the same challenges you have right now.
Hope to continue to assist....
jforbes 1,107
Recognized Expert Top Contributor
You may very well be running into a file sharing permissions problem. But I noticed you mentioned opening the spreadsheet from SharePoint. I believe there is an option when opening a file from SharePoint to open in edit mode vs read only. So, I'm curious how are you launching the Spreadsheet. Could you provide your code?
@ Twinnyfo - that's what I found out, unfortunately I don't know who to ask to change it.
@ jforbes
its just a hyperlink attached to the button via the Hyperlink address in properties. But I got a work around for it and reduced the buttons on the form down to one. Found that if i just linked it to the share-point location, the user can then click the spreadsheet they need to open and it opens with the option for read only or edit.
Thanks for your input.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Marc Schellens |
last post by:
fstream.open( name, mode) fails
fstream.fail() returns true.
How can I find out what went wrong?
(ie. file does not exist for reading, permissions...)
thanks,
marc
|
by: webstuff |
last post by:
Hi,
I'm getting a 'Type mismatch' exception when calling the
Word.Application.Documents.Open method when using the Office XP 2003
PIAs. the actual error is:
...
|
by: Rob |
last post by:
Strange problem. I have a number of datagrids in my
application. I have some custom security on my forms and
set my datagrid ReadOnly property to true when the user
does not have enough...
|
by: Suma |
last post by:
Hi
To open a notepad file, right now I am using Process.start. But this does not ensure that the file is opened in readonly mode
How can I make a notepad file open in Readonly mode
I do not...
|
by: Ron |
last post by:
Hello,
the following sub (below) reads an excel file to a webpage
using BinaryReader. If anyone tries to modify the excel
file from the browser this places the excel file in
ReadOnly mode, and...
| | |
by: BSGY |
last post by:
Hello
app.Documents.Open("TEMPLATE.DOC", False, False, False, "", "", False, "",
"") doesnt work on server.
But it is working in my computer.
What is the problem, what can i do ?
|
by: phamer |
last post by:
Hello. My switchbaord contains 2 options: add a record and edit a
record. So, of course, if I click add a record, the first form opens
in add mode; if I click edit, the first form opens in edit...
|
by: Steph |
last post by:
hello,
because msdn is so poor... somebody did he write a similar script ?
(DTE/DTE2)
_applicationObject.Documents.Open(docPath, "?string kind?", false);
i must type the "string kind"... but...
|
by: RKovach |
last post by:
I am automating Word and getting the existing instance if available using the following:
Word.Application oWord = null;
Word.Document oDoc = null;
object oMissing =...
|
by: BHerz |
last post by:
I have an Access 2007 application which displays the File Name of documents located on a Windows SharePoint V3 Site.
When you click on the file name the file opens in "Read Only" format.
I am not...
|
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,...
| | |
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,...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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 ...
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |
