Hai Radhika
You can use Ms-Access or SQL Sever ...
If you can use Access , you can store database in Diff location and connection
to be done with VB using ini file.
first store database path in ini file
get database path from ini file using API
So you can change database location in diff. path.
This is code for ini file retreving.
Dim strLocation As Long
Dim strTemp1 As String
strTemp1 = space(200)
strLocation = GetPrivateProfileString("Database", "Location", strTemp2,
strTemp1, 200, App.Path & \inifilename")
strTemp1 = Trim(Mid(strTemp1, 1, strLocation))
strDBLocationRnr = strTemp1
With adcnDb
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security
Info = False;Data Source = " & strDBLocationRnr '& "\Runner\ipr.mdb"
.CursorLocation = adUseClient
.Open
End With
strLocation = GetPrivateProfileString("Report", "Location", strTemp2,
If any dobut please mail to me.
R.Balamurugan
radhika_vbin <[EMAIL PROTECTED]> wrote:
Hai Friends,
Iam a learner of VB. Iam designing a project in VB6.0 and MS Access..
Now, i've two questions..
1. How should the databae be added..If i create an EXE fiel,then i
need to add the database in the same folder.This is not safe as the
database can be opened and can be edited..Is there any way to avoid
this and i want to use only msAccess for this..
2. If i want to keep the project in my server and access the databse
in all other client systems,what will be the basic code for this..
Hope to get ur help soon..
With thanx in advance,
Radhika.S.
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [email protected]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
SPONSORED LINKS
Programming languages C programming language Computer programming languages
Java programming language C programming language History of computer
programming language
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "vbhelp" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
---------------------------------
Too much spam in your inbox? Yahoo! Mail gives you the best spam protection
for FREE!
http://in.mail.yahoo.com
[Non-text portions of this message have been removed]
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [email protected]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
