VBA runs an Access Query help

[msquared99]

Hello and thanks for reading.

I have an Access DB, that is tied into another secure DB, that I use to summarize some data. Because I need the data from the Access DB query over in Excel, I have a macro in Excel that retrieves the data and puts it in a worksheet.

My issue is I want other people to be able to use the Excel macro, but since they do not have security clearence to the DB Access is pointing to, is there a way to allow other users to use this macro?

Thanks!

 

[Luke M]

To summarize, you have 3 tools, A, B, C. The order or feeding info is:
A->B->C
Where
A: Secure database
B: Regular Access database
C: Excel tool

Is the above correct? If so, assuming the XL macro doesn't need tool B to do any refreshing, it shouldn't be an issue. Have you tried pulling the info into XL already?

 

[msquared99]

Luke,

That is correct.

The Access DB is tied in "Live" to the secure database, so it does auto refresh.

The Excel tool runs fine on my PC but errors out on someone else's.

 

[SirJB7]

My issue is I want other people to be able to use the Excel macro, but since they do not have security clearence to the DB Access is pointing to, is there a way to allow other users to use this macro?

Hi, msquared99!
Fortunately there isn't, if not how much secure would be that secure DB? Almost as much as Excel is... :D
Regards!