Go Back   Access World Forums > Apps and Windows > Excel

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-02-2018, 07:21 AM   #1
lekkala
Newly Registered User
 
Join Date: Jan 2018
Posts: 11
Thanks: 9
Thanked 0 Times in 0 Posts
lekkala is on a distinguished road
The query did not run or the database table could not be opened

I have this Excel spreadsheet to display live SQL data. It was working fine and then suddenly a few users cant refresh data it gives the following message "The query did not run, or the database table could not be opened" and other users can.

lekkala is offline   Reply With Quote
Old 05-02-2018, 11:34 AM   #2
Ranman256
Newly Registered User
 
Join Date: Apr 2015
Location: KY,USA
Posts: 2,864
Thanks: 0
Thanked 623 Times in 608 Posts
Ranman256 will become famous soon enough
Re: The query did not run or the database table could not be opened

Validate the connections.
Are these users on other versions than the rest?
Ranman256 is offline   Reply With Quote
Old 05-02-2018, 11:36 AM   #3
lekkala
Newly Registered User
 
Join Date: Jan 2018
Posts: 11
Thanks: 9
Thanked 0 Times in 0 Posts
lekkala is on a distinguished road
Re: The query did not run or the database table could not be opened

How to validate the connections? Can you please explain

Yes some users have a different version of excel

lekkala is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Cannot be opened error santhosh23 General 9 10-26-2015 06:34 AM
This database has been opened read-only supmktg General 7 08-29-2011 11:23 AM
Backing up an opened database rodneyb Modules & VBA 4 08-14-2003 01:14 PM
quote a day when database is opened Mike Hughes General 10 07-10-2003 09:36 AM
How can one tell if a database has been opened or not? llyal Modules & VBA 1 05-30-2000 09:58 AM




All times are GMT -8. The time now is 01: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