Weird Access open issue

[mahmed1]

Hi guys

I am running some code from Excel that opens up access Runs 2 macros in the Access Database and then paste into my excel sheet using the open
Recordeset (dont have the code to had at present) but my main issue is that
When some users run it it comes up with a msg that the database is open even though i can assure you that it aint open but if i or some users run it, it runs fine...

so for some users it runs and others that the access DB is open and i just dont why

i have closed all access down and even ended task for access for the users affected and myself and same thing happens

it doesnt like it when they or certain users run it

my code just opens Access Dn
Calls the AccessUpdateMacro

 

[mahmed1]

Thank you

iwill make those changes - yh looks like security trust centre resolved it but i dont know why it worked for some and not others

it now means i need to make sure everyones is set up right

 

[xenou]

So this might be a stupid question but why are 10 people running it? Are they all trying to run the same thing, or is it doing something different each time a different person runs it?

 

[mahmed1]

So this might be a stupid question but why are 10 people running it? Are they all trying to run the same thing, or is it doing something different each time a different person runs it?

there are different packs where they connect to same database so if a change has been made to the database - they need to run the macro that imports in the text file and sends back as recordset..

i might make a change to my area and you might make a change to your area...bot changes will vet updated to the same database hence why different people might be updating and getting data

just linkingto db to get data would have been fine but they to call the macro that does the import and delete etc..

 

[xenou]

Hmm. Not sure what a pack is, but maybe it doesn't matter. This code doesn't look particular robust for multiple users all calling the same macro (potentially at the same time), but hopefully such collisions are relatively rare and the guards you have in place for that are sufficient.