unable to work in an excel file and an access file at the same tim

R

RoHscx

While using Access/Excel 2007 I am not able to work in an excel file and an
access file at the same time, if the excel file links into the access
database. When updating queries into the database, I get a message saying
the data is unavailable. While using MS Office 2003, this was not a problem.
I need a Database Guru!
 
T

TedMi

The ability to update linked Excel tables from within Access has been
removed, due to legal complications over the methods involved. This was once
possible in Office 2002 & 2003, but subsequent updates removed this
capability. It was never possible in '07.
-TedMi
 
R

RoHscx

TedMi,

Thank you for the very helpful response.

TedMi said:
The ability to update linked Excel tables from within Access has been
removed, due to legal complications over the methods involved. This was once
possible in Office 2002 & 2003, but subsequent updates removed this
capability. It was never possible in '07.
-TedMi
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 import Excel 2007 file 1
Creating an accde file 1
Access 2003 file opens to a blank page when opened in Access 2007 1
Changing Links to access databases 1
Read Data from Excel 2007 1
Trouble with “… attempting to change the same data at the same tim 1
Import data from Access to Excel containing VB code 3
MS Query 4

Top