p2p.wrox.com: Archives - asp

asp_databases thread: Access

Message #1 by "Ali M. Hijazi" <hijazia@c...> on Tue, 15 Jan 2002 21:17:12

Well I want to manipulate a Microsoft Access database

I just want to know how to write a stored procedure (like in SQL server)

that manipulates a table in an Access database?!

Message #2 by Mark Eckeard <meckeard2000@y...> on Tue, 15 Jan 2002 14:32:29 -0800 (PST)

Ali,



Access doesn't support stored procedures.



Mark

--- "Ali M. Hijazi" <hijazia@c...> wrote:

> Well I want to manipulate a Microsoft Access

> database

> I just want to know how to write a stored procedure

> (like in SQL server)

> that manipulates a table in an Access database?!





$subst('Email.Unsub').





__________________________________________________

Do You Yahoo!?

Send FREE video emails in Yahoo! Mail!

http://promo.yahoo.com/videomail/

Message #3 by "Kim Iwan Hansen" <kimiwan@k...> on Wed, 16 Jan 2002 09:27:03 +0100

Access uses "Queries" instead.



Open your database and go to "Queries" (under tables on the left), then

choose "Create query in Design View".



Note, it's not the same as stored procedures - it does have its

limitations - but it gets you a good part of the way.



-Kim





> -----Original Message-----

> From: Mark Eckeard [mailto:meckeard2000@y...]

> Sent: 15. januar 2002 23:32

> To: ASP Databases

> Subject: [asp_databases] Re: Access

>

>

> Ali,

>

> Access doesn't support stored procedures.

>

> Mark

> --- "Ali M. Hijazi" <hijazia@c...> wrote:

> > Well I want to manipulate a Microsoft Access

> > database

> > I just want to know how to write a stored procedure

> > (like in SQL server)

> > that manipulates a table in an Access database?!





> $subst('Email.Unsub').

>

>

> __________________________________________________

> Do You Yahoo!?

> Send FREE video emails in Yahoo! Mail!

> http://promo.yahoo.com/videomail/

>




> $subst('Email.Unsub').

>

Message #4 by "Drew, Ron" <RDrew@B...> on Wed, 16 Jan 2002 07:47:46 -0500

It does support macros, modules and queries (select,insert,delete),

however I have also just used straight sql in the asp.  Maybe the use of

a command would work.

-----Original Message-----

From: Mark Eckeard [mailto:meckeard2000@y...]

Sent: Tuesday, January 15, 2002 5:32 PM

To: ASP Databases

Subject: [asp_databases] Re: Access

Ali,

Access doesn't support stored procedures.

Mark

--- "Ali M. Hijazi" <hijazia@c...> wrote:

> Well I want to manipulate a Microsoft Access

> database

> I just want to know how to write a stored procedure

> (like in SQL server)

> that manipulates a table in an Access database?!

$subst('Email.Unsub').

__________________________________________________

Do You Yahoo!?

Send FREE video emails in Yahoo! Mail!

http://promo.yahoo.com/videomail/

$subst('Email.Unsub').

Message #5 by <hijazia@c...> on Wed, 16 Jan 2002 16:52:29 +0300


> Hi Ron

well can I write macros in structured query langauage (sql)

please help me with the syntax...

well I know how to write stored procedures for SQL-Server

> From: "Drew, Ron" <RDrew@B...>

> Date: 2002/01/16 Wed PM 03:47:46 GMT+03:00

> To: "ASP Databases" <asp_databases@p...>

> Subject: [asp_databases] Re: Access

> 

> It does support macros, modules and queries (select,insert,delete),

> however I have also just used straight sql in the asp.  Maybe the use of

> a command would work.

> 

> -----Original Message-----

> From: Mark Eckeard [mailto:meckeard2000@y...] 

> Sent: Tuesday, January 15, 2002 5:32 PM

> To: ASP Databases

> Subject: [asp_databases] Re: Access

> 

> 

> Ali,

> 

> Access doesn't support stored procedures.

> 

> Mark

> --- "Ali M. Hijazi" <hijazia@c...> wrote:

> > Well I want to manipulate a Microsoft Access

> > database

> > I just want to know how to write a stored procedure

> > (like in SQL server)

> > that manipulates a table in an Access database?!





> $subst('Email.Unsub').

> 

> 

> __________________________________________________

> Do You Yahoo!?

> Send FREE video emails in Yahoo! Mail!

> http://promo.yahoo.com/videomail/

> 




> $subst('Email.Unsub').

> 




> 



AliHijazi

Message #6 by <hijazia@c...> on Wed, 16 Jan 2002 16:58:08 +0300


> ok then

I'm using the command object to insert values of the form elements by appending parameters, well I know how to use parameters with
sql-server stored procedures, so please help with Access Queries are they written in sql or the syntax differs here? 

> From: "Kim Iwan Hansen" <kimiwan@k...>

> Date: 2002/01/16 Wed AM 11:27:03 GMT+03:00

> To: "ASP Databases" <asp_databases@p...>

> Subject: [asp_databases] Re: Access

> 

> Access uses "Queries" instead.

> 

> Open your database and go to "Queries" (under tables on the left), then

> choose "Create query in Design View".

> 

> Note, it's not the same as stored procedures - it does have its

> limitations - but it gets you a good part of the way.

> 

> -Kim

> 

> 

> > -----Original Message-----

> > From: Mark Eckeard [mailto:meckeard2000@y...]

> > Sent: 15. januar 2002 23:32

> > To: ASP Databases

> > Subject: [asp_databases] Re: Access

> >

> >

> > Ali,

> >

> > Access doesn't support stored procedures.

> >

> > Mark

> > --- "Ali M. Hijazi" <hijazia@c...> wrote:

> > > Well I want to manipulate a Microsoft Access

> > > database

> > > I just want to know how to write a stored procedure

> > > (like in SQL server)

> > > that manipulates a table in an Access database?!





> > $subst('Email.Unsub').

> >

> >

> > __________________________________________________

> > Do You Yahoo!?

> > Send FREE video emails in Yahoo! Mail!

> > http://promo.yahoo.com/videomail/

> >




> > $subst('Email.Unsub').

> >

> 

> 




> 



AliHijazi

Message #7 by "Drew, Ron" <RDrew@B...> on Wed, 16 Jan 2002 09:26:17 -0500

When you create the query, normally you use DESIGN which does not look

like sql.  By doing a VIEW SQL you see the code.  You can however do a

new, designmode then view sql (blank screen), then type the sql

statements and save the query.

Not sure how to link the query but I have created many buttons in access

to execute..here is an example..maybe someone out there can show how to

get to this via asp.



Private Sub Add_New_Member_Click()

On Error GoTo Err_Add_New_Member_Click



    Dim stDocName As String



    stDocName =3D "AddMember"

    DoCmd.OpenQuery stDocName

   

Exit_Add_New_Member_Click:

    Exit Sub



Err_Add_New_Member_Click:

    MsgBox Err.Description

    Resume Exit_Add_New_Member_Click

   

End Sub



-----Original Message-----

From: hijazia@c... [mailto:hijazia@c...]

Sent: Wednesday, January 16, 2002 8:58 AM

To: ASP Databases

Subject: [asp_databases] Re: Access







> ok then

I'm using the command object to insert values of the form elements by

appending parameters, well I know how to use parameters with sql-server

stored procedures, so please help with Access Queries are they written

in sql or the syntax differs here?

> From: "Kim Iwan Hansen" <kimiwan@k...>

> Date: 2002/01/16 Wed AM 11:27:03 GMT+03:00

> To: "ASP Databases" <asp_databases@p...>

> Subject: [asp_databases] Re: Access

>

> Access uses "Queries" instead.

>

> Open your database and go to "Queries" (under tables on the left),

> then choose "Create query in Design View".

>

> Note, it's not the same as stored procedures - it does have its

> limitations - but it gets you a good part of the way.

>

> -Kim

>

>

> > -----Original Message-----

> > From: Mark Eckeard [mailto:meckeard2000@y...]

> > Sent: 15. januar 2002 23:32

> > To: ASP Databases

> > Subject: [asp_databases] Re: Access

> >

> >

> > Ali,

> >

> > Access doesn't support stored procedures.

> >

> > Mark

> > --- "Ali M. Hijazi" <hijazia@c...> wrote:

> > > Well I want to manipulate a Microsoft Access

> > > database

> > > I just want to know how to write a stored procedure

> > > (like in SQL server)

> > > that manipulates a table in an Access database?!




> > $subst('Email.Unsub').

> >

> >

> > __________________________________________________

> > Do You Yahoo!?

> > Send FREE video emails in Yahoo! Mail!

> > http://promo.yahoo.com/videomail/

> >

> > ---

> > Change your mail options at http://p2p.wrox.com/manager.asp or to

> > unsubscribe send a blank email to

> > $subst('Email.Unsub').

> >

>

>




$subst('Email.Unsub').

>



AliHijazi








$subst('Email.Unsub').

Return to Index

P2P Archives