Thanks for all this assistance.
To answer Glasgows comment - I'm using ADO so I wouldn't imagine the RDO register data source method would be of much use for this particular project but is v.handy thing to know! Thanks.
Uncle T - whats the story with that code VB6 doesn't seem to like it -...
Hi there UncleT,
It works perfectly, thanks a million.
I have a few queries in relation to it that you may be able to help with :
1. Is there a way of passing in a password?
2. Do you know where I can find code to delete a data source using the same method?
Thanks again for your assistance...
Hi there,
I have added this code to an existing project & it just doesn't work, I have modified the server name, database name, user name & password , & DSN name to relevant variables. I don't get any error, the code is executed but nothing at all happens - any ideas?
Thanks,
Rachel
No unfortunately this is not what is happening - I am specifying a data source in excel which connects through an sql server login with read only access to 1 table - however I am not prevented from extracting data from any sql table into excel which causes me a huge security problem as you can...
I am having a problem which has been discussed here already although the answers given do not solve the issue.
The problem relates to preventing external access to sql server 2000 data from other external applications, for eg. MS Excel, MS Access. When you take the 'Get External Data'/new...
I am having the same problem and alththough the security options work when accessing the SQL Server 2000 database from the software application (written in VB6) or from EM they do not work from external office applications.
For example I have created a user defined database role which only...
Yes, it is on my machine & it is not corrupt. The strange thing is if I open up a new vb project there is no problem adding this component. The thing is I am working on a large project & do not fancy having to start a new one up & add everything else in. I have had a similar problem before when...
Hi there,
I am having problems trying to use the datetimepicker control. I am attempting to add a reference to the active x file MSCOMCT2.OCX (MS Windows Common Controls 2 6.0 SP3) which should enable me to access the dateTimePicker control. Each time I try to apply this change I get a message...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.