Hi all can anybody tell me the VB coding if I put the MS-access database with password in MDB file on to the websapce something like www.xyz.com in db folder
what will be the VB coding to access that MDB File please repply me immediately at [EMAIL PROTECTED] Thanks in advance Arpan Jha --- [email protected] wrote: > There are 2 messages in this issue. > > Topics in this digest: > > 1. Re: About Database > From: Darrell Adams > <[EMAIL PROTECTED]> > 2. Re: About Database > From: "Matt" > <[EMAIL PROTECTED]> > > > ________________________________________________________________________ > ________________________________________________________________________ > > Message: 1 > Date: Wed, 8 Jun 2005 18:14:11 -0700 (PDT) > From: Darrell Adams <[EMAIL PROTECTED]> > Subject: Re: About Database > > > Use ADO and execute the statment just as if you are > Query Analyzer (I'm using MS SQL Server with ADO) > > I executed the following SQL statement through VB > and > added the field sTestCol. (ADOExecuteSQL is in a > module that has my connection code) > > In a command click event: > > Dim strSql As String > strSql = "alter table testprevention.dbo.tblhistory > Add sTestCol NVARCHAR(50) NULL" > ADOExecuteSql (strSql) > > > --- woo setlan <[EMAIL PROTECTED]> wrote: > > > if yes, how?? any hints?? thanks a lot > > > > Matt <[EMAIL PROTECTED]> wrote: > > ----- Original Message ----- > > From: "setlan83" <[EMAIL PROTECTED]> > > To: <[email protected]> > > Sent: Wednesday, June 08, 2005 3:29 PM > > Subject: [vbhelp] About Database > > > > > > > Is there any code in the vb so i can add a field > > to the database juz > > > from the vb program??? > > > > > Yes > > > > > > > > '// > > > ======================================================= > > 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 the > > Yahoo! Terms of Service. > > > > > > > > > > --------------------------------- > > Do you Yahoo!? > > Yahoo! Mail - You care about security. So do we. > > > > [Non-text portions of this message have been > > removed] > > > > > > > > > > > > > __________________________________ > Do you Yahoo!? > Make Yahoo! your home page > http://www.yahoo.com/r/hs > > > ________________________________________________________________________ > ________________________________________________________________________ > > Message: 2 > Date: Thu, 9 Jun 2005 10:48:14 +0930 > From: "Matt" <[EMAIL PROTECTED]> > Subject: Re: About Database > > That will depend on the database access you are > intending to use. > > For the most generic method, use SQL. I would > suggest you look up ALTER > TABLE in your SQL reference > Otherwise you will need to identify the access > method ADO/DAO/ODBC and the > underlying database type to get concrete answers > > > > Matt <[EMAIL PROTECTED]> wrote: > > ----- Original Message ----- > > From: "setlan83" <[EMAIL PROTECTED]> > > To: <[email protected]> > > Sent: Wednesday, June 08, 2005 3:29 PM > > Subject: [vbhelp] About Database > > > > > > > Is there any code in the vb so i can add a field > to the database juz > > > from the vb program??? > > > > > Yes > > > > > > > > '// > ======================================================= > > 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 the > Yahoo! Terms of Service. > > > > > > > > > > --------------------------------- > > Do you Yahoo!? > > Yahoo! Mail - You care about security. So do we. > > > > [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] > > '// > ======================================================= > === message truncated === __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com '// ======================================================= 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/
