Microsoft Office 14.0 access database engine ole db provider in visual studio 2015 -

-

this first attempt @ writing visual basic app using visual studio. using access 2013 database source , going fine until decided add calculated fields 1 of tables. vs telling me need "microsoft office 14.0 access database engine ole db provider" read tables.

i've been searching , searching can't find version 14.0 of engine. missing simple, or can not access calculated fields in db , have pull data , calculations in app?

i working on machine win7 64bit, office 2013 pro, , visual studio 2015 community.

thanks!

edit: calculated fields this:

"http://travellermap.com/api/jumpmap?sector="+left([sector],4)+"&hex="+[hex]+"&style=print&jump=3"

where [sector] , [hex] fields in same database. added fields database vs2015 throw error. if tired use dataset wizard tell me there fields in database missing or not read without v14 of engine.

then after removed calculated fields still not read data. have revert backup copy of database never had calculated fields in things working.

my exact steps follows:

  • create database multiple tables
  • create view pulls data tables needed.
  • create dataset in vs uses view called systemmaster
  • build app around using xaml designer
  • decide quicker use calculated field int db write vb code put url needed display image in app.
  • close out vs2015 , laucnh access 2013
  • create calculated field in primary table , edit sql code view include fields
  • save , close access, go vs2015
  • view dataset see if new fields there, see not , launch wizard find out wizard says can't access in view anymore because fields either missing or can't read current version of access engine (12.0) , need version 14.0.
  • search answer, don't find one. remove fields tables , try working application.
  • realize after removing fields, vs2015 won't read tables ro views had them.
  • revert version of database did not have calculated views, , works again.

while know proper way construct urls in vb code, easier , quicker (in theory) @ point proof-of-concept/prototype.


Comments

Post a Comment

Popular posts from this blog

dns - How To Use Custom Nameserver On Free Cloudflare? -

-
i have problem. i own small hosting company. trying add cloudflare site free cdn. problem when sign have change nameservers nameservers. have nameserver dns set through godaddy, how add them cloudflare? main site uses company's nameservers whenever add them site goes offline. when go cloudflare's dns records click on dropdown, click ns, , there's 2 boxes 'name' , 'nameserver'. mean input 'ns1' 'name' , 'ns1.domain.com' 'nameserver'? input server's ip addresses? is there way of accomplishing free version of cloudflare? that impossible. option have custom name servers available on business , enterprise. see https://www.cloudflare.com/plans . also, might mistaken. must change name servers in domain register settings, not on cloudflare.
Read more

python - Pygame screen.blit not working -

-
in program creating in python/pygame, screen.blit not working. in other programs have made, screen.blit works. error: traceback (most recent call last): file "c:...\main.py", line 46, in <module> screen.blit(sight.image, sight.rect) attributeerror: 'int' object has no attribute 'blit' the error in question caused screen variable being allocated integer instead of pygame.surface() object.perhaps accidentally rewrote variable somewhere? from can make of doing, seems stating position of blit full rect instead of coordinate. when do: screen.blit(sight.image,sight.rect) what program seeing is: screen.blit(sight.image,(sight.rect.x,sight.rect.y,sight.rect.width,sight.rect.height)) i assuming don't intend this. remember rect object consists of position, width , height. to correct code, put (sight.rect.x,sight.rect.y) location goes instead this: screen.blit(sight.image,(sight.rect.x,sight.rect.y)) the .x , .y corres
Read more

c# - Web API response xml language -

-
i having simple post url clients send post request. http://mydomain.com/requests/request post data: <request> <orderid>1e008921</orderid> <ordername>mc1</ordername> </request> to respond sending them xml <srequest> <requestedby>client 1 </requestedby> <requestname>test name</requestname> <requeststatus>success</requeststatus> <srequest> now client wants above xml in different language (say french ) how handle ? how send response language preference in web api ? specially post scenario ? (append language string ? or best practices ?) i suggest either include in url: http://mydomain.com/fr/requests/request or use http header accept-language . read more in answer to: good way changing language resources dynamically request
Read more