Visual Basic Arrays and Access Database
Posted on 2003-11-11
I have a column in my access database table called "Lines", and I need it to be an array type somehow so that for each record in the table I can have multiple "Lines" and for each "Line" I can store an X1, Y1, X2, Y2. Also, how would I use a select statement and update statement from visual basic to access and update that field? I know I could just create a whole new table to do this for me, but would perfer not too. I don't know a lot about access, use it rarely, so I'm sure is something beyond the basics I know to accomplish this.