Forum Discussion
opening a database with Sharpoint Links via Excel
I have created this utility in Excel (and connect to a MS Access) - the database -in Microsoft Access, is completed. I am in the second Phase of the project; I have successfully published database to...
I just had a thought about a workaround until you get a better technical answer to the direct linking process.
I would try a two step process:
Create or update a temp table in Access from the complex queries just prior to when you need them. Instead of linking to the queries, link to those temp tables from Excel. They'll be local Access tables and should not raise this problem.
We often do that in Access for reports based on data from really complex queries.
If that'll get you going, maybe it'll buy time to find a way to pursue the permissions problem.
I would try a two step process:
Create or update a temp table in Access from the complex queries just prior to when you need them. Instead of linking to the queries, link to those temp tables from Excel. They'll be local Access tables and should not raise this problem.
We often do that in Access for reports based on data from really complex queries.
If that'll get you going, maybe it'll buy time to find a way to pursue the permissions problem.
I work at the government and they are allergic to Microsoft Access or something like that. As a consultant I have to use what they give me. I asked originally for SQL Server but no cigar, then I asked for MySQL which they agree but they are not willing to install the drivers to connect (Grrr.....). So my last resource is SharePoint just to prove them it can be done. I am hoping I can get a SQL box from all this. I have been working on Access since the beginning I think it was Access 2.0, v1.0 was a disaster. Good old days; hmmm.... guess I am old too.
- Well, it has been profitable. Young professionals have a hard time with VBA, so they find us and pay as a much as they pay the youngsters (and even more). But I also do Razor pages in C#, VB.Net, Javascripts, TSQL and whatnot. But, I am ready to retire as well; just being a bit stubborn. Thank you for your time and efforts...
- I started with 2.0 as well. It kept me employed for over 20 years. I'm retired now (but trying to stay current as much as I can.).
I guess, if this is a Proof of Concept, the interim workaround of converting your SQL to make-table queries in order to generate temp tables that Excel CAN link to might fill the bill.
