473,324 Members | 2,541 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Updating a Linked table while DB form is running????

Hello all...

well here's what's up:

I have a link excel table to my DB (that will have 3-4 people in at one time). I was wondering how to make it so I can update and save the excel table while the 3-4 people have the form running that is linked to? Any help on this would rule. thanks alot everyone.
Apr 11 '07 #1
3 3045
pks00
280 Expert 100+
Not sure how u can update a excel file with multiple users
This is tricky as Excel is not multiuser

Only way I could possibly think of is if u create a table based on the excel file, users then modify this table. Then u need to synchronise the updates
Apr 11 '07 #2
Not sure how u can update a excel file with multiple users
This is tricky as Excel is not multiuser

Only way I could possibly think of is if u create a table based on the excel file, users then modify this table. Then u need to synchronise the updates
I was able to make the excel doc a share doc so as many peopel as I wanted can use it at once so that should be a problem if that's what your concerned about.
Apr 12 '07 #3
Here is how I made the table a shared file. But how can I make it, so I can update and the file while I'm in the the DB and form that is linked the table. that is my main question. I get a locked error

Share a workbook
1. Create a workbook you want to make available for multiuser editing, and enter any data you want to provide.
If you want to include any of the following features, add them now: merged cells, conditional formats, data validation, charts, pictures, objects including drawing objects, hyperlinks, scenarios, outlines, subtotals, data tables, PivotTable reports, workbook and worksheet protection, and macros. You can't make changes to these features after you share the workbook.
2. On the Tools menu, click Share Workbook, and then click the Editing tab.
3. Select the Allow changes by more than one user at the same time check box, and then click OK.
4. When prompted, save the workbook.
5. On the File menu, click Save As, and then save the workbook on a network location accessible to the intended users. Use a shared network folder, not a Web server.
6. Check any links to other workbooks or documents, and fix any that are broken.
How?
1. On the Edit menu, click Links.
The Links command is unavailable if your file does not contain linked information.
2. Click Check Status to update the status for all links in the list. This may take a while if there are a lot of links, or if the source workbook for the links is on a network location, and the network is slow.
3. Check the status in the Status column, select the link, and then take the action needed.
OK** No action required, the link is working and up to date.
Unknown* Click Check Status to update the status for all links in the list.
N/A** The link uses Object Linking and Embedding (OLE) or Dynamic Data Exchange (DDE). Microsoft Excel cannot check the status of these types of links.
Error: Source not found** Click Change Source, and select another workbook.
Error: Worksheet not found** Click Change Source, and then select another worksheet. The source may have been moved or renamed.
Warning: Values not updated** Click Update Values. The link was not updated when the workbook was opened.
Warning: Source not recalculated** Click Open Source, and calculate the workbook by pressing F9. The workbook may be set to manual calculation. To set to automatic calculation, on the Tools menu, click Options, select the Calculation tab, and then click Automatic.
Warning: Undefined or non-rectangular name** Some names cannot be resolved until the source workbook is opened. Click Open Source, switch back to the destination workbook, and click Check Status. If this does not resolve the problem, make sure the name is not misspelled or missing. Switch to the source workbook, and then on the Insert menu, point to Name, and then click Define, and look for the name.
Warning: Open source to update values** Click Open Source. The link cannot be updated until the source is open.
Source is open** The status of a link cannot be checked.
Values updated from filename* No action required, the values have been updated.
Warning: Status indeterminate** Excel cannot determine the status of the link. The source may contain no worksheets, or be saved in an unsupported file format. Click Update Values.
Notes
All users with access to the network share have full access to the shared workbook, unless you use the Protect Sheet command (Tools menu, Protection submenu) to restrict access.
The users who will edit the shared workbook need Microsoft Excel 97 or later (Microsoft Windows) or Excel 98 or later (Macintosh).
Apr 13 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

11
by: Jason | last post by:
Let's say I have an html form with 20 or 30 fields in it. The form submits the fields via POST to a php page which updates a table in a database with the $_POST vars. Which makes more sense? ...
6
by: Andreas Lauffer | last post by:
I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used...
1
by: aaj | last post by:
Hi all I have a main form looking at a main table, with a subform looking at a detail table, linked by a key. There are many entries in the sub form bound to the single entry on the main form....
1
by: Old Timer | last post by:
I wish to type in a number in my "Code" field, for instance 1060, I then wish the number 1060 to trigger an event that will fill in the next field (township field) For instance, 1060 brings up and...
4
by: Laura | last post by:
Here's the situation: I'm trying to use an update query to copy data from one row to another. Here is the situation: I have 5 companies that are linked to each other. I need to show all 5...
4
by: glenhong | last post by:
Hi I need some help here. I am running Access 2003. I have an Access DB linked (Front-end) to another Access DB (Back-end). I have a Form which has a third party grid on it. The grid is...
2
by: Jaaz | last post by:
Essentially I'm constructing a database to track a lot of data. Part of this included a running history table that is linked to data outside the table. On the main form I used, I've hit a snag. ...
0
by: Dan | last post by:
I have an access database that contains a linked dbf table that is based on a shapefile in ARC-Editor. I would like to auto-update a table based on the new records that have been entered into GIS....
2
by: danthrom | last post by:
I have this update query UPDATE LEFT JOIN ON .=. SET . = . WHERE .=.; Which updated the storage date for all linked data with the similar box number. Now I want to create a SQL that will...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.