|
 |
asp_databases thread: Best way to update an Access database record
Message #1 by "Lloyd Levine" <levinll@m...> on Thu, 21 Sep 2000 17:08:13 +0100
|
|
What's the best way to update a record in Access ? I know what record I
want to update. Do I use SQL ? A stored procedure ?
Message #2 by "Ken Schaefer" <ken@a...> on Fri, 22 Sep 2000 11:12:56 +1000
|
|
There are not stored procedures in Access, only queries.
I think you'll find that executing an SQL statement is probably easiest when
dealing with Access (since I can't see an easy way to create new queries
programmatically), and I don't think it's really any slower.
Cheers
Ken
----- Original Message -----
From: "Lloyd Levine" <levinll@m...>
To: "ASP Databases" <asp_databases@p...>
Sent: Friday, September 22, 2000 2:08 AM
Subject: [asp_databases] Best way to update an Access database record
> What's the best way to update a record in Access ? I know what record I
> want to update. Do I use SQL ? A stored procedure ?
Message #3 by "Jason A. Greenfeld" <jgreenfeld@r...> on Fri, 22 Sep 2000 09:31:23 -0400
|
|
In using access, I would definately use a SQL statement.
Jason Greenfeld
Rubicon Technologies, Inc.
http://www.rubicontechnologies.com
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Thursday, September 21, 2000 9:13 PM
To: ASP Databases
Subject: [asp_databases] Re: Best way to update an Access database
record
There are not stored procedures in Access, only queries.
I think you'll find that executing an SQL statement is probably easiest when
dealing with Access (since I can't see an easy way to create new queries
programmatically), and I don't think it's really any slower.
Cheers
Ken
----- Original Message -----
From: "Lloyd Levine" <levinll@m...>
To: "ASP Databases" <asp_databases@p...>
Sent: Friday, September 22, 2000 2:08 AM
Subject: [asp_databases] Best way to update an Access database record
> What's the best way to update a record in Access ? I know what record I
> want to update. Do I use SQL ? A stored procedure ?
|
|
|
View Cart
