Run macro's on startup with other users logged in (1 Viewer)

bruceblack

Registered User.
Local time
Today, 13:46
Joined
Jun 30, 2017
Messages
119
Hi folks! I'm a little stuck here and cant wrap my head around what to do.
All help is greatly appriciated!

- So, i have 3 excel files that are being posted daily (files are replaced with updated ones).

- The data in these excel files is imported into tables with a macro.
First the macro deletes the old 3 tables, then imports the new on startup!

The problem is:
When someone is already logged on, and someone else start the program, it gives an "exclusive" error. Logically because it cant delete the tables because they are being used.

What is the best approach here? I wish it would just ignore the whole thing and just import. When i dont used the "delete tables" macro's, it will build up a whole bunch of duplicates.

How can i import excel files into tables on startup (like i have) without duplicates? And will i still have the same exclusive error??

I would like to hear what you lads n lassies think :) Thanks!
 

NauticalGent

Ignore List Poster Boy
Local time
Today, 09:46
Joined
Apr 27, 2015
Messages
6,280
I may be be misunderstanding, but when you say you are getting exclusive messages, it leads me to beleive you are usnimg a single, in-split DB in a multi-user environment.

Is this the case?
 

bruceblack

Registered User.
Local time
Today, 13:46
Joined
Jun 30, 2017
Messages
119
Hi man! Thanks for the swift reply.

To be frank, im not really sure about that.
For sure it's supposed to be a multi-user environment.
How can i check on this?

Im sorry. Not that familiar with Access running on networks.
In this case, a big ass company :)
 

Mark_

Longboard on the internet
Local time
Today, 06:46
Joined
Sep 12, 2017
Messages
2,111
Important distinction, are you deleting the tables or are you deleting all records in the tables? I would not recommend getting in the habit of deleting the tables you are using.
 

Users who are viewing this thread

Top Bottom