[RESOLVED] adodc database path

[macmatira]

when i transfering my file.mdb in other folder or location there is always a bug..

what is the best code for these problem..
(ADODC)

pls help me...

[GaryMazzone]

The best code for ADODC is not to use it.

[macmatira]

i used this code.

conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\All Users\Documents\mac try\try.mdb;Persist Security Info=False"

what is the best alternative code, even i transfer the folder (containing the project, file.mdb and other files)?

i can do this last year, but i forgot because i've stopped making program for a year.
but i remember that i used the word "path" and other simbles like ' " * / and others..
i don't know the exact codes
but an example is a great help for me.

pls help me...

thank you.

[GaryMazzone]

I have no idea. I avoid ADODC like a plague

[GaryMazzone]

look at this page:
http://connectionstrings.com/access

This has all you should need to creating a connection string for ADODB connection objects

[macmatira]

the link does not answer my question.




i got the answer for my question..

i make a trial and error. trying different words then adding "." (period or dot).

i found that using "app.path" which locates the path of the folder.

i used this codes...

conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\try.mdb;Persist Security Info=False"

...
thanks for your kindness...