Add/edit database records VB-access

How do you add and edit records in a database in access using VBS?
mattewjonesAsked:
Who is Participating?
 
Arthur_WoodCommented:
is this for use in an ASP Page?

dim objConn
dim strSQL
dim rs

set objConn = Server.CreateObject("ADODB.Connection")
set rs = Server.GetObject("ADODB.Recordset")
objConn.ConnectionString = <connection string to your database>
objConn.Open

strSQL = "Select * from YourTable where 1=0"
rs.OPenRecordset(strSQL)

rs.AddNew
  rs.Fields("Column1") = Value1
rs.Update

OR, to edit a record:

strSQL = "Select * from YourTable where Field = " & SelectedValue

rs.OpenRecordset(strSQL)

rs.Fields("Field2") = NewValue
rs.Update


is that what you mean?

AW

0
 
Richie_SimonettiIT OperationsCommented:
did you mean VBScript or plain VB?
0
 
Richie_SimonettiIT OperationsCommented:
Related (VB, in vbscript is a little diferent)

http://www.vbcode.com/asp/showsn.asp?theID=250
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
mattewjonesAuthor Commented:
I just want the code for my question vbs - visual basics script so i want the script the code if u like u know wot i mean
0
 
Arthur_WoodCommented:
where are you going to use this VBScript?  in what application?

AW
0
 
gajendraCommented:
You could try the data control and the dbgrid combination for the simplest option.

Alternately, you could let the Wizards design your first data entry program and evaluate the same thereafter.

Gajendra
0
 
mattewjonesAuthor Commented:
RE: where are you going to use this VBScript?  in what application?

Arnt I asking the question? All i wanted was the code now go away be4 i bring out my AK
0
 
Arthur_WoodCommented:
knowing where you are using the VBScript makes a difference.  But if it is so hush hush, and you are goingto take thaat attitude,then good luck getting help from any one here.

I am just trying to get some clarification, so that the answer will be appropraite to the circumstances.

AW
0
 
mattewjonesAuthor Commented:
no i didnt ask that wot do u mean....?
VB im using VB so obtusily i will be entering VBS

Jus go home
0
 
Richie_SimonettiIT OperationsCommented:
I don't understand that attitude, what's the problem that Experts ask for more details?, do you want to find an accurate solution or not?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.