vb.net - MSAccess not opening database when started using System.Diagnostics.Process.Start() -

-

i having trouble start access database (msaccess.mdb) programmatically using system.diagnostics.process.start().

this scenario:

  1. vb.net aspx page starts [installpath]\cmd\erpimport.exe
  2. erpimport.exe reads settings sql server db (pgmname, params, execdir) uses again process.start() start batch file [installpath]\cmd\import.cmd
  3. import.cmd contains these 3 lines:

g: cd \esvonix "c:\program files (x86)\microsoft office\office14\msaccess.exe" "g:\esvonix\esvonix.mdb" /runtime

the esvonix.mdb programmed start data manipulation in startforms onopen event. startform set in db settings.

now strange part:

  • if start import.cmd double click windows explorer fine
  • if start erpimport.exe (with connection string parameter expects) command line works fine

but: if start erpimport.exe within vb.net page, start import.cmd correctly , import.cmd start msaccess.exe (as can see in taskmgr). however, access not open database (no ldb file created) , not start processing. "hangs around" in taskmgr 0 cpu time used. after killing msaccess.exe taskmgr rest works fine again: import.cmd completes, erpimport completes, aspx page shows result.

i have tried large number of different settings in process.startinfo, result same, regardless of settings.

any ideas welcome. thanks

after changing full office installation access runtime problem persisted, without /runtime parameter in call access. however, problem disappeared , access called , processed correctly command line switch /save after database name in command line.

update - solved unfortunately /safe parameter (requesting access start in safe mode) did not fix problem. process did run once after adding parameter , went previous behaviour.

the solution change applicationpool settings "loaduserprofile = true". there number of questions on dealing parameter. exact reason in case not clear, if works ...

update july 11, 2017 same problem in different user environment. time windows 2012 server. setup worked combination of /safe parameter when calling msaccess.exe , setting application pool loaduserprofile=true (in advanced settings)


Comments

Post a Comment

Popular posts from this blog

google chrome - Developer tools - How to inspect the elements which are added momentarily (by JQuery)? -

-
i looking @ how website designed using inspector in chrome. can use firefox developer tools or firefox web developer add-on or chrome web developer extension. so website has slide-show , using jquery it. looking @ markup , css in inspector, i see 2 things constantly changing slides change: one opacity css property understandable, i'd see changing values, changes fast see read anything. second- a div added in div slides change momentarily , moment when appears short notice except div . so question is there way stop slideshow can temporarily rid of blinking sort of effect (by speedy adding , removal , changing of elements , values)? where can inspect div element gets added such short moment , , gets removed? , can see changes in value of opacity takes place? is there way stop slideshow can temporarily rid of blinking sort of effect (by speedy adding , removal , changing of elements , values)? if opacity animated css transition or animation,
Read more

angularjs - Showing an empty as first option in select tag -

-
my app showing empty select field first entry. have read other solution given , tried still not working. my controller code is: .controller('usercreatecontroller', function(user,profile,auth) { alert("hello"); var vm = this; vm.type = 'create'; profile.all() //this service fetch profiles shown in select field .success(function(data){ vm.profile = data; }); vm.userdata.profile = vm.profile[0]; //here have set default value select field and html page is: <label class="col-sm-2 control-label">profile</label> <div class="col-sm-8"> <select ng-model="user.userdata.profile" ng-options="person._id person.profilename person in user.profile"> </select> </div> hierarchy of vm.profile { "_id": 46, "profile": objectid("5516498e95b84548156db754"), "isactive": true, "password": "$2
Read more

php - Cloud9 cloud IDE and CakePHP -

-
i attempting cakephp running on cloud9, cloud based ide. unaware, cloud collaboration ide intermixes services such bitbucket. site gives sudo rights, , installed cakephp using these instructions: https://www.digitalocean.com/community/tutorials/how-to-install-cakephp-on-an-ubuntu-12-04-vps when attempt run database exported machine cakephp installed, error message "url rewriting not configured on server." attempted solve issue using official guide cakephp: http://book.cakephp.org/2.0/en/installation/url-rewriting.html but no cigar, same error message. has gotten cakephp working, or aware of cloud ide free/low cost cloud9 support cakephp? here's how got working now: sudo apt-get update sudo apt-get install php5-intl curl -ss https://getcomposer.org/installer | php -- --filename=composer ./composer create-project --prefer-dist cakephp/app this creates project in /app default. move workspace docroot: mv app/* ./ mv app/.* ./ rm -rf app then de
Read more