Question Data Link Connection

[stretch66]

OK,

Hvae tried to connect to my db from an Excel speadsheet and understand that I need to change the properties of the Data Link to include the pathway of the .mdw file however I cannot find the right property.

Have attached a screenshot of the two forms and would be greatful if someone could advise me:

A. If I am using the correct method and

B. What property is the one that takes the pathway to the .mdw file.

Thanks

 

[ByteMyzer]

A. Yes

B. Jet OLEDB:System Database

 

[stretch66]

Brilliant Thanks!!!!!!!

How do I connect from another access database?