Connection Strings in ODBC - lockable?

9tanstaafl9

9tanstaafl9

Well-known Member
Joined
Mar 23, 2008
Messages
535
Question 1: I would like to distribute a sample of my workbook, with the ODBC connection hardwired to go to a specific directory on their C drive. I don't want the user to be able to use the Script Editor to change the ODBC connection string. (Or any other program.) Is there a way to lock this?

Question 2 (but related so I'm listing it here): Right now we set the ODBC connection when we create the workbook. We click on the worksheet, choose Import External Data and choose the Visual FoxPro ODBC driver and connect to our sample company. When I get a new user, I use MS Query to go in and edit the connection string (9 times...) -- is therees a better way to do this? Can I do it in the VBA code directly? Assuming I could I'm guessing this would solve my Question 1.

Thank you. I did see some posts regarding connection strings, but they were a bit above my head. Please speak slowly...
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Sort by date Sort by votes
Real question: can you use VBA to set ODBC connection string

Ok, sorry, I was really tired and I realize that part 1 of my question wasn't really a VBA question at all and I didn't explain it well anyway. My real question is:

Can you use VBA to set the ODBC connection string for queries? If so, how? I have 9 queries, all with same string. Would like to have a msgbox pop up, let them enter the directory name, and have that change all the odbc conneciton strings automatically. Can anyone point me in the right direction?

Sorry about posting poorly. Is there a way I can delete this whole thread and redo it correctly? I don't want to cross post and tick people off even more.

Thanks!
 
Last edited:
Upvote 0
Re: Real question: can you use VBA to set ODBC connection string

Ok, I'm going to risk the cross post. I think since I screwed up my initial question that's the only thing left to do since I'm not getting a response. If there is some way to delete a bad question could someone please tell me?

Sorry in advance for anyone I tick off by doing this, but I'm not sure as to the ettiquite here, and I really need an answer.
 
Upvote 0
Re: Real question: can you use VBA to set ODBC connection string

9tanstaafl9 said:
Ok, I'm going to risk the cross post. I think since I screwed up my initial question that's the only thing left to do since I'm not getting a response. If there is some way to delete a bad question could someone please tell me?

Sorry in advance for anyone I tick off by doing this, but I'm not sure as to the ettiquite here, and I really need an answer.
Click to expand...


GOT SUCCESSFUL ANSWER TO SETTING THE CONNECTION STRING. Really nice people provided the code for me. See the following post:

http://www.mrexcel.com/forum/showthread.php?t=332627

(Not sure if I did that right. If not, sorry, my intentions were good. Someone please tell me what I was supposed to have done. Thx.)
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question Question
ODBC Connection to SQL Database - display the last refreshed date for a worksheet
Replies
5
Views
916
JEC
JEC
E
  • Question Question
VBA to update connection string based on value of a cell
Replies
1
Views
473
Kaper
Kaper
S
  • Question Question
Experimenting with ODBC DSN to import Excel Data from another Workbook
Replies
0
Views
480
sspatriots
S
F
  • Question Question
Making a UserForm behave as a Tool Window for another process
Replies
3
Views
297
fitzmorrispr
F
C
  • Question Question
ole db CopyFromRecordset skipping cell values
Replies
0
Views
652
Clif McIrvin
C

Forum statistics

Threads
1,223,911
Messages
6,175,337
Members
452,637
Latest member
Ezio2866

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top