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

bruceblack

Registered User.
Local time
Today, 23:21
Joined
Jun 30, 2017
Messages
115
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

Executive Troll
Local time
Tomorrow, 00:21
Joined
Apr 27, 2015
Messages
2,629
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, 23:21
Joined
Jun 30, 2017
Messages
115
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, 15:21
Joined
Sep 12, 2017
Messages
2,112
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 (Users: 0, Guests: 1)

Top Bottom