Code modification - VBA connection with Access DB

[VBABEGINER]

Hi All,
The below connection code line using to send data in access DB.

cs = "Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=\\inmum-i-fs4\group$\WNA Skyline\H&B\Timesheet_Data.accdb"

I want to modify this code for older version of access DB.
Can anyone please provide me code..

 

[RoryA]

If you are using an older version of Excel as well, then use the Microsoft.Jet.4.0 provider. If not, all you need to is alter the file name of the database.

 

[VBABEGINER]

Can you please provide in code...so i can test..and will revert you whether its working for me or not..

 

[RoryA]

What version of Excel are you using?

 

[VBABEGINER]

Excel 2010..and dont know how to see version of Access

 

[RoryA]

In that case all you need to change is the database file name.

 

[VBABEGINER]

Hi RoryA,
I really thankfull that you are kindly guiding things to me. But I really not get, need to change database file name OR alter the file name of database..

Can you pls tell me what exactly action need here

 

[RoryA]

If you are using an "older version of the Access DB" as you say, I assume the file is in mdb format, so the name will end in .mdb and not .accdb. If the file name is the same, you don't need to change anything.

 

[VBABEGINER]

Thanks for revert...just hold on..i will check and revert..