linked excel files in access-cause probl.with opening excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I work in Microsoft Access and at this moment this satisfied me because I
work on local network.
I have successfully link excel files but I have a problem with working with
excel. My user at the same time work in excels and in access which link the
same
file.In access I creating the reports based on excel files. Everything goes
OK.
User open excel, then he opens access. He works in excel and changes he made
is correctly represent in access.He already get used to facts that there is a
problem which programs has to rune first or close first but bigger
problem is, when he close the access application he can not normally started
excel.
Excel is opened only with toolbar and the desktop window is instead
workbook. Excel does not functionally work.This is not only happened with
recently used files but with any files in excel.
How can I solve this problem? Is the problem in excel or in access.
I will be very happy if someone answer me.
thank You
 
Hi Dee,

1) Have you excluded the possibility that Excel is loading normally but
with the workbook window positioned off-screen? If you use the
Window|Arrange menu command to maximise or tile the window, does the
worksheet appear?

2) When the user closes Access but before he attempts to start Excel,
open the Windows Task Manager and look in the Processes tab for a
process with the image name EXCEL.EXE.

If you find it, it means that the instance of Excel that Access was
using is still in memory. This could conceivably cause a problem. You'll
need to revise your Access application to ensure that it closes Excel
properly.

3) The scenario you describe - editing an Excel workbook that is
simultaneously being used by linked tables in an Access application -
has never been trouble-free for me. Over the years I've concluded that
the safer approach is to edit the workbook first, save it, close it, and
only then do whatever I need to do in Access.
 
Dear Ms.Nurick, your advice was very helpful.
1. I already use tile in arrange window so it does’ not help

2. Really, excel.exe stays in processes even I close the access application

That is the problem
Can you shortly help me, how can I closed excel when I closed the access
application


Comment
I try to enforce user to import excel sheet and make changes in access but
he insist to
Use it simultaneously.
Again, thank you
I have another problem with access but it does not refer to import/link so I
will make another question in appropriate group
Greetings from Croatia


Korisnik "John Nurick" napisao je:
 
1) Does your database contain any VBA code that manipulates Excel (e.g.
via an Excel.Application object or Excel.Worksheet object)?

2) If so, you need to ensure that the Excel object(s) are closed and
released before Access quits. How much experience do you have of VBA
programming?
 
Sorry,
Obviously I don't have enough experience in using VBA code
I'm familiar with VBA method and I used them in my application, but not on
the linked excel sheet. These linked sheets must be used only because reports
based on each row in sheet.
Nothing complicated, just read the data and produce some reports based on
them.
Temporary, my user pay attention not to close access if they won't to use
excel.
I will try to find answer in some books, but it will take a time. I'm little
bit confused because it seems that this is not happening immediately after I
use first linked excel table, something is caused this reaction after some
period.



Korisnik "John Nurick" napisao je:
 
If the VBA code in your Access application is not manipulating Excel,
then I don't have anything to suggest - except to avoid the problem by
opening the sheets/tables in Excel or Access but not both
simultaneously.
 
Back
Top