How do I use the connection string to connect to a table on the database that I am working on.

B

Bright

I have two related tables. and one form of which one of the tables is a
subform and i want to write the data on the subform to a textfile. I
used this code to connect to the table but because I have already
opened the MDB. I get the error that the file is already openned.

objConn.CursorLocation = adUseClient
objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Documents and
Settings\exds006\Desktop\Electronic LIV;" & "Persist Security
Info=False"

objConn.Open

Is there another way of accessing the data on the subform without using
the connection string.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Connection files and pivot tables 0
How to use SQL Server connection string 0
Connection string issues 9
ADO connection to Excel 2007 *.xlsx files? 8
Need code assistance to update pivot table from an ADO recordset 4
Connection String problem 1
Connection String to Secured Database 2
Application close the connection and leaves the MDB without passwo 0

Top