How to access vba in excel 20166/21/2023 ![]() "are Deny Write Extended Properties="""" Jet OLEDB:System database="""" Jet OLEDB:Registry Path="""" Jet OLEDB:Database Password="""" Jet" _ "OLEDB Provider=.4.0 Data Source=X:\Database\Path\DB.mdb Password= User ID=Admin Mode=Sh" _ Here's the script, any help is greatly appreciated. ![]() I've figured out how to open the database in Excel 2016, but when I update the macro to match the settings the scripts hangs because the Data Link Properties opens up to choose the settings instead of using the settings set in the script. We are running some old software that uses Access 97 and do daily exports of certain tables. My company recently upgraded Office 2010 to 2016 which broke some of the automation made by a previous employee.
0 Comments
Leave a Reply. |