Link to MS Access Database table

K

kfschaefer

how come when I use a ODBC connection to a MS Access Table it does not
reflect the up to date data. If I make a change in Access I want it to be
reflected in teh Project data. how do I refresh the link or data. I saved
the DSN/ODBC connection - so that is live - so goes to assume that the data
should be updated.

thanks
 
R

Rod Gill

Hi,

Can't be done. To se updates in Project you must re-open the file from
Access or use VBA in Access to Open the project or directly update the open
file using Automation.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com
 

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

Table Security in Access 2013 1
Adding data to MS Access from csv file 0
Linking data in MS Word into Excel 5
Connection files and pivot tables 0
Connecting MS Project 2003 Pro to a MySQL 5 database with MyODBC 6
ODBC Linked Tables 0
Access Query to import from Sharepoint 0
Access 2003 not linked to Oracle 11g 3

Top