Re: Please Help Me in Visual Basic 6.0 SP6

d_harry45 wrote:
> Public Sub setdbpswd()
> Dim dbPath As String
> Dim dbConn As String
>
> dbPath = App.Path & "\database\jheks" & "\pswdjheks.mde"
> dbConn = "provider=Microsoft.Jet.OLEDB.4.0;data source=" & dbPath
> & ";Jet OLEDB:database password ="
> dbpswd.ConnectionString = dbConn
> dbpswd.CursorLocation = adUseClient
> dbpswd.CommandTimeout = 30
> dbpswd.Open
> End Sub
> --------------------------------------------------------------------------
----------
>
> Above is my programming where in this programming, we indicate that
> where the database location using App Path. But, using this same
> programming or others, how can i indicate myself which one i'm gonna
> insert to the database. It's seems like to have an input first before
> we can establish the connection to the particular database chosen.

Yes you will. Pop up a screen asking for which database, and then use that
selection to open the connection.


> The case is like this, I will have the path like "\database1\jheks",
> "\database\jheks", \database2\jheks" and so on. The case and the
> problem is, i want my user to indicate which database folder they
> refer to insert, and then my application will connect to it.

Ask the user. Stick up a screen and ask them. What is difficult about
this.

>But I
> don't know how to done that. For your infomation, this folder
> "\database" will refer to which batch of file will gonna insert to
> the database.
>
> I've information where to select the database is using
> listbox/combobox, or also can using Windows Common Dialog. But, how
> to hold the selection and where to put it? Any tutorial that can help
> me?

Put it in a string variable - that's what they are for. You can either use
a global variable, or pass it as a parameter to the database connection
procedure. This is pretty basic stuff. What specifically is the problem?

--
Regards,

Michael Cole


.

Relevant Pages

  • Re: A little Rolodex [revised]
    ... including alpha sort and searching for any embedded string, ... In this application, a database is a directory, ... you may optionally provide any alternate UCASE program, ... NN -> first store NN as key length ...
    (comp.sys.hp48)
  • Re: return multiple rows from sql statement
    ... strings from input values is almost certainly a safe path to SQL ... Also, being a MySQL function, it knows what MySQL needs or uses. ... All characters that are entered in the fields make their way into the database unaltered. ... The insert of what surprisinlgly was NOT a syntax error, but a string called "mysql_insert_id" into an integer field resulted in the value zero being put in. ...
    (comp.lang.php)
  • Re: Code to delete/unlink Linked tables
    ... Public intLinkODBCTables As Variant, intLinkDB2Tables As Variant ... Public strLinkBackendDB As String, strLinkDSNname As String, strLinkLibName ... ' MsgBox "This database is in MDE format...I will delete/recreate ODBC ... Public Sub fncLinkDB2Table() ...
    (microsoft.public.access.modulesdaovba)
  • Re: Establish connection with and transferring data to Access
    ... The specific problem with your code is that you need to quote string ... Dim vConnection As New ADODB.Connection ... Experiment with the object model or check the documentation for the ... Doug's code opens and writes to an existing database. ...
    (microsoft.public.word.vba.general)
  • Re: Invalid variant type conversion
    ... because within regular programming, there would be no agreement upon what ... applications built by standard Delphi controls, ... NULL is the same as "" in a database. ... >> The empty string tells it all. ...
    (comp.lang.pascal.delphi.misc)
Loading