(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Get info from Microsoft Access
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 [2]  Send Topic Send Topic Print Print
Hot Topic (More than 10 Replies) Get info from Microsoft Access (Read 3640 times)
NHUser
Full Member
***
Offline



Posts: 320
Location: Amherst, NH
Joined: Aug 2nd, 2010
Re: Get info from Microsoft Access
Reply #15 - Jul 25th, 2012 at 2:37pm
Print Post Print Post  
One more question....

I just tried to use the updated programming from a user computer and found that it didn't work.  I realized that the user doesn't have Microsoft Access on their computer.

Must Access reside on the user computers?
  
Back to top
 
IP Logged
 
NHUser
Full Member
***
Offline



Posts: 320
Location: Amherst, NH
Joined: Aug 2nd, 2010
Re: Get info from Microsoft Access
Reply #16 - Jul 25th, 2012 at 3:46pm
Print Post Print Post  
The file was working fine on my computer so I updated our working Sesame file. 

I then tried the programming from a user computer and it didn't work.  I realized that the user computer does not have Microsoft Access installed.

Must the user have Access installed on their computer for the programming to work?
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Get info from Microsoft Access
Reply #17 - Jul 25th, 2012 at 5:22pm
Print Post Print Post  
Hello Paul,

Yes the client system must have Access installed on it in order for the script file to work.

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Get info from Microsoft Access
Reply #18 - Jul 25th, 2012 at 7:33pm
Print Post Print Post  
Another option is to have the Microsoft Access Database Engine installed on the client. This can be downloaded from, http://www.microsoft.com/en-us/download/details.aspx?id=23734

Download and then install it and it should now work for you. I was able to use it on one of my systems to access a .accdb file with only having Access 2003 installed.

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
NHUser
Full Member
***
Offline



Posts: 320
Location: Amherst, NH
Joined: Aug 2nd, 2010
Re: Get info from Microsoft Access
Reply #19 - Jul 26th, 2012 at 2:20pm
Print Post Print Post  
OK, got it working. 

The problem was that I didn't have the .wsf file on the users c:drive.  Once I added that file, everything works fine. 

I've added it to other users computers and it works without the download.

Thanks for all your help!
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1 [2] 
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge