×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

VB 6, DAO, & FoxPro tables

VB 6, DAO, & FoxPro tables

VB 6, DAO, & FoxPro tables

(OP)
I am trying to use DAO to access Foxpro tables in VB6. Everything is going well, except, I cannot get write access to the fox tables. The code I am using follows. If anyone has any suggestions, please let me know:


Sub Test()

Dim dbs As Database, rstPlayers As Recordset
Dim strName As String

Set dbs = OpenDatabase("c:\develop\DAOtest", True, False, "FoxPro 2.6")

Rem this is Read/Write
If dbs.Updatable Then
MsgBox ("DB Read/Write")
Else
MsgBox ("DB Read-Only")
End If

Set rstPlayers = dbs.OpenRecordset("players")

Rem this, no matter what I try, is always Read-Only
If rstPlayers.Updatable Then
MsgBox ("Table Read/Write")
Else
MsgBox ("Table Read-Only")
End If

rstPlayers.MoveFirst
While Not rstPlayers.EOF
strName = rstPlayers!Name
MsgBox (strName)
rstPlayers.MoveNext
Wend

rstPlayers.Close
dbs.Close

End Sub

RE: VB 6, DAO, & FoxPro tables

GMan,

Not certain if this applies here, but when using ODBC and DAO, you _must_ define the cursor type in order to accomplish certain ends - such as writing to the table. You might check the parameters list for OpenRecordset() to see if it's necessary to do such for ISAM databases. Also, check to see if you need an entry in either the registry or .ini file.

RE: VB 6, DAO, & FoxPro tables

(OP)
I have tried the following in the type...

dbOpenTable
dbOpenDynaset

Which I believe are the only 2 to allow write access... neither worked :( I didn't know that there is an INI file and registry settings that control the behavior of DAO... do you happen to know where I can locate them?

Thank you

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close