Rechck linked table automatically

[Krays23]

HI

I have a excel file that's is linked to my table in access what id like the access table to do is auto recheck the data in that excel sheet automatically when you start the data base up.

Is that possible?

Dan

 

[Isskint]

Hi Dan,

Can you confirm please, is Access the data source for the Excel file OR are you using the Excel file as a data source for the Access table?

What do you need to happen when it "auto recheck the data"? Are you checking to ensure it is uptodate?

 

[Krays23]

The excel file drives the access table

To be honest im thinking to get rid of this linked table would that be better and auto update therefore?

 

[Isskint]

The link should refresh automatically each time the database is opened. You can use the TableDef.RefreshLink Method to update via VBA.

HOWEVER, if all the users have MS access on their PC's, it makes more sense (to me) to just use MS Access. If the data is manually keyed in Excel, then create a new data entry form and get the data keyed directly. If the data is copied/imported into Excel, you can just as easily paste it into MS Access.