vba - Connecting Access with SAS -


i have decent amount of experience sas , access, , know how call access vba, having problem table locks need with.

essentially doing running proc freq in sas, passing table in access can read in subform.

i have form combo boxes user can select info variable want frequency of. click button , vba passes parameters on sas, , subform populates frequency data sas.

everything works except final part.

i have taken parameters access, passed them sas, , run correct frequency. during sas's proc export access, error stating: "exectute: database engine not lock table "freq" because in use person or process."

the issue table sas exporting used in access form opens sas.

since not using form while sas processing, there way have form unlock or disconnect table sas can access it, , reconnect table form after sas finishes processing?

i tried splitting database, got same problem.


Comments

Popular posts from this blog

android - Gradle sync Error:Configuration with name 'default' not found -

java - Andrioid studio start fail: Fatal error initializing 'null' -

html - jQuery UI Sortable - Remove placeholder after item is dropped -