Thank you.
Its not exclusively Access. One db was built by a contractor in sequel and I link to through ODBC. I use the ODBC to transfer the data into SPSS (Statistical Software for the Social Sciences) and into Access.
Once I score data, i move it from SPSS into Access.
Not my calling in life, but these are the cards dealt...
I wonder if the fact that i'm keeping Access 2003 to finish the db work however having Office...
stuchdk
Last Activity: Jun 12 '08, 12:08 AM
Joined: Feb 8 '08
Location: portland, OR
-
I am transferring data from SPSS to msAccess, so other than using an ODBC i'm not sure how I would move the data. I'm confused by your suggestion connecting files of type. can you explain further?
thank you!...Leave a comment:
-
Record-locking information file (ldb.)
Preface: I am using Access 2003 but have Office 2007 on my machine with Access 2007 disabled.
In the database I am working in/building, I transfer data in from SPSS (statistical software) and other access db through ODBC so that I can put into reports in this db.
However, everytime I transfer in data, I get the ldb. that will not go away. Sometimes I can open my mdb., close it and then the ldb. will leave; or open the mdb. close it,... -
thank you! so because i used the wizard (yes i do not write in vb, not that savvy; i am statistical person) rather than writing the code, i do not receive the error when the form closes without the primary key because of a bug? sounds like microsoft...
i will use your recommendation.
thank you for the help and the welcome! (i am she)
-stuch...Leave a comment:
-
Primary Key in in Data enry Form
background:
I have created a series of data entry forms for use of data collection. Each has a table as a record source with the same primary key "survey_id" , which is a text field. this is selected as the primary key so that the data from the tables when queried can be linked on this unique identifier; it cannot be duplicated; and must be entered whenever a new record is entered.
Question:
in the access Form, when...
No activity results to display
Leave a comment: