Open database output

[Kamil]

Hello Everybody,
I have an mdb file and I want to use it by creating some reports from it. I
am using crystal reports to do that. My report part is almost ready but I
have a problem in my codes.

When I run the program I want the program to open a blank database and to
add the values I will enter from a form.

But I dont know how to open database for this case.
In the following codes, I can connect my database, I can add my entries but
each time the database is growing. I want to open the database blank in each
run.

Regards...
Akdogan

Set conn = New ADODB.Connection
conn.CursorLocation = adUseClient
conn.Provider = "Microsoft.JET.OLEDB.4.0"
conn.Open "D:\deneme.mdb"
Set rst = New ADODB.Recordset
rst.ActiveConnection = conn
rst.Open "SELECT * FROM kayit1 WHERE aNO = '" & aNO.Text & "' ", conn,
adOpenStatic, adLockOptimistic

 

[Mike Glen]

Hi Akdogan,

Try posting on the developer newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP