Writing values in mdb databases.

Results 1 to 2 of 2

Thread: Writing values in mdb databases.

  1. #1
    Felipe Raniero Mahalem Guest

    Default Writing values in mdb databases.

    I need to know, how to write 3 new values in a database.<BR>This database called recordes, has a table called recordes too, and It need 3 informations :<BR>Name , Points, Targets (points and targets are numeric)<BR>and there is an Autonumeration on the first colun.<BR>So, how do I write in a new row , new values ?<BR><BR>tnks!

  2. #2
    Join Date
    Dec 1969

    Default RE: Writing values in mdb databases.

    Do you have a DSN set up pointing to the d on the web server? If so, try this...<BR><BR>strSQL = "INSERT INTO recordes (name, points, targets) VALUES (&#039Jerry&#039, 1000, 1)<BR><BR>Set rst=CreateObject("ADODB.Recordset")<BR>rst.Open strSQL, "DSN=YourDSNName"<BR><BR>rst.Close<BR>Set rst = Nothing<BR><BR>HTH<BR><BR>Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts