Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-21-2017, 11:02 AM   #1
bruceblack
Newly Registered User
 
Join Date: Jun 2017
Posts: 82
Thanks: 2
Thanked 0 Times in 0 Posts
bruceblack is on a distinguished road
Run macro's on startup with other users logged in

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!

bruceblack is offline   Reply With Quote
Old 09-21-2017, 11:12 AM   #2
NauticalGent
Pristine Curmudgeon
Gold Supporter
 
NauticalGent's Avatar
 
Join Date: Apr 2015
Location: Naples, Italy (EXPAT from Virginia)
Posts: 1,385
Thanks: 302
Thanked 176 Times in 156 Posts
NauticalGent will become famous soon enough NauticalGent will become famous soon enough
Re: Run macro's on startup with other users logged in

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?
__________________
ďI had the RIGHT to remain silent...but I didnít have the ABILITY.Ē - Ron White
NauticalGent is offline   Reply With Quote
Old 09-21-2017, 11:26 AM   #3
bruceblack
Newly Registered User
 
Join Date: Jun 2017
Posts: 82
Thanks: 2
Thanked 0 Times in 0 Posts
bruceblack is on a distinguished road
Re: Run macro's on startup with other users logged in

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

bruceblack is offline   Reply With Quote
Old 09-21-2017, 11:57 AM   #4
NauticalGent
Pristine Curmudgeon
Gold Supporter
 
NauticalGent's Avatar
 
Join Date: Apr 2015
Location: Naples, Italy (EXPAT from Virginia)
Posts: 1,385
Thanks: 302
Thanked 176 Times in 156 Posts
NauticalGent will become famous soon enough NauticalGent will become famous soon enough
Re: Run macro's on startup with other users logged in

Read and heed, act swiftly. Once you have done this, we can address your question regarding excel imports.

http://www.fmsinc.com/microsoftaccess/databasesplitter/
__________________
ďI had the RIGHT to remain silent...but I didnít have the ABILITY.Ē - Ron White
NauticalGent is offline   Reply With Quote
Old 09-21-2017, 03:11 PM   #5
Mark_
Longboard on the internet
 
Join Date: Sep 2017
Posts: 1,264
Thanks: 13
Thanked 241 Times in 239 Posts
Mark_ will become famous soon enough
Re: Run macro's on startup with other users logged in

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.

Mark_ is offline   Reply With Quote
Reply

Tags
duplicates , excel , import , macro , tables

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Currently logged-in users stevekos07 General 9 02-27-2017 03:42 PM
Users Logged In XMan Modules & VBA 4 06-29-2009 06:11 AM
Display users logged into DB oxicottin Forms 1 02-24-2008 10:27 PM
Users Logged on... WhizzkidWallace Modules & VBA 2 02-10-2005 01:59 AM
How to tell if other users logged in to DB Ally Modules & VBA 7 05-20-2002 06:28 AM




All times are GMT -8. The time now is 03:53 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World