|
|
|
|
#1
03-02-2014, 05:28 PM
|
||||
|
||||
IMHO, you're going about this the wrong way. If the SQL is supposed to work with a particular database, the code should used a fully-qualified database name; not simply work with whatever 'production' database the user has open.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
#2
03-02-2014, 05:41 PM
|
|||
|
|||
|
I appreciate the concern but...
Is it possible to find the "open" databases and the server on which they reside with VBA? If so how?
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Formula to open external file with specific program (like open with)
|
pemartins | Excel | 16 | 02-24-2014 11:39 PM |
|
Save in SERVER instead.
|
zuzullo | Outlook | 3 | 09-08-2011 12:34 AM |
| unable to open .RTF files in server machine from client machine | Naresh_1210 | Word | 0 | 03-12-2010 03:26 AM |
| Exchange Server. Do I need it? | SRE | Outlook | 1 | 01-11-2010 06:36 PM |
| Can I use one VERY big server for everything ? | RickH | Project | 0 | 12-15-2005 08:22 AM |
Windows 7 32bit 
Office 2010 32bit
Hybrid Mode