Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old January 19th, 2005, 12:05 PM
Friend of Wrox
Points: 1,035, Level: 12
Points: 1,035, Level: 12 Points: 1,035, Level: 12 Points: 1,035, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: , , USA.
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to jmss66
Default TransferDatabase Macro

Hi Guys,

I am trying to use this macro and everytime I click on the run button an error message "Could not find installable ISAM".

What I am trying to do is transfer a table from Oracle using ODBC connection string below:

Provider=MSDAORA.1;User ID=id_name;Data Source=my_prd;Persist Security Info=False

After doing a little bit more researching, I ended up in Microsoft's site about repairing the dll files or making sure their path is correct in the registry. After carefully checking, the dlls are where they are supposed to. So that didn't solve the problem.

I thought this error message will not appear if you're using ODBC connection. Can somebody please shed me some light on how to tackle this error message.

Cheers,
Judy
Reply With Quote
  #2 (permalink)  
Old January 19th, 2005, 12:15 PM
Friend of Wrox
 
Join Date: Nov 2003
Location: Lehigh Acres, FL, USA.
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

Maybe this will help

http://support.microsoft.com/default...b;EN-US;209805

Jaime E. Maccou
Reply With Quote
  #3 (permalink)  
Old January 19th, 2005, 12:52 PM
Friend of Wrox
 
Join Date: Oct 2004
Location: Clinton, UT, USA.
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

I don't know much about importing data from Oracle, but for what it's worth, I have imported tables successfully from Paradox and MySQL. If this is only going to be run a few times, you could try the 'Get External Data' option under the file menu. I have had nothing but good experiences with it.

Good Luck

Mike
EchoVue.com
Reply With Quote
  #4 (permalink)  
Old January 19th, 2005, 01:11 PM
Friend of Wrox
Points: 1,035, Level: 12
Points: 1,035, Level: 12 Points: 1,035, Level: 12 Points: 1,035, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: , , USA.
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to jmss66
Default

Hi Echovue,

I can import the tables from Oracle no problem if I do it manually. What I am trying to do is to automate it so users can just click on the macro and it will import all the tables they need, which is about 10 of them. So you see I do not want to do it manually.

Thanks,

Hi Jemacc,

I forgot to write the version I was using. It's ACCESS 2002. Anyways, that was the Microsoft site I was talking about in my original e-mail with dlls regeistry which did not work.

Thanks for both your response.

Judy

Reply With Quote
  #5 (permalink)  
Old January 19th, 2005, 01:32 PM
Friend of Wrox
 
Join Date: Oct 2004
Location: Clinton, UT, USA.
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

Hi Judy,

I wouldn't want to do it manually either!! Have you considered looking at using VBA instead of Macros?

Mike
EchoVue.com
Reply With Quote
  #6 (permalink)  
Old January 19th, 2005, 01:49 PM
Friend of Wrox
Points: 1,035, Level: 12
Points: 1,035, Level: 12 Points: 1,035, Level: 12 Points: 1,035, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: , , USA.
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to jmss66
Default

Hi EchoVue.com,

I am not familiar with VBA but I kinda told myself that if I can't resolve this error message I will just write a VB program to just copy the tables.

Do you have to write the VBA codes inside ACCESS and if you do how does the syntax go? Is it faster to do this than write a VB program?

Thanks,
Judy

Reply With Quote
  #7 (permalink)  
Old January 19th, 2005, 02:06 PM
Friend of Wrox
 
Join Date: Oct 2004
Location: Clinton, UT, USA.
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

If you can write VB then VBA is a cakewalk. There are a few differences, but all in all it is much the same.

I am assuming that you have a form, and the user will push a button to import the tables. On the properties for the button, goto the Events and click the ... next the the onClick event. Access should give you three options, select 'Code Builder' and it should take you to the VBA module associated with that form. I haven't imported tables using VBA before, but I have seen it done. I think all that you would need to set up a connection to the Oracle Instance, and then if I am not mistaken, there is a TransferDatabase method or something similar that you could use to pull the tables in. I would be happy to try point you in the right direction if you need more help.

Mike
EchoVue.com
Reply With Quote
  #8 (permalink)  
Old January 19th, 2005, 02:59 PM
Friend of Wrox
Points: 1,035, Level: 12
Points: 1,035, Level: 12 Points: 1,035, Level: 12 Points: 1,035, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: , , USA.
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to jmss66
Default

Yes please guide me to where I should go. I will start looking into what you said and if I hit a road block I will post my questions if it's alright with you. I was hoping I can get the ISAM error message resolved so I don't have to write a code.

Thanks,
Judy

Reply With Quote
  #9 (permalink)  
Old January 19th, 2005, 03:36 PM
Friend of Wrox
 
Join Date: Oct 2004
Location: Clinton, UT, USA.
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

I was just wondering, is there any reason why you would not want to create a linked table to the specific tables in the Oracle database that you are using? If not, you could consider just linking the tables, or alternatively, linking the tables and then using a Make Table query to transfer the data to another table (If you are worried about them monkeying around directly with the Oracle instance)

Mike
EchoVue.com
Reply With Quote
  #10 (permalink)  
Old January 19th, 2005, 03:46 PM
Friend of Wrox
 
Join Date: Oct 2004
Location: Clinton, UT, USA.
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

I just had a look at the Microsoft Help File on the TransferDatabase Action. It is fairly well explained, and could well resolve your problem. Also while looking for that I found another article (different from the one reffered to earlier I think) http://support.microsoft.com/kb/90111/EN-US/ Basically it says that you might get the ISAM error if there is something wrong with your connection string as well.

Mike

Mike
EchoVue.com
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
calling to xlam macro from macro inside xlsb SteveB Excel VBA 0 June 30th, 2008 06:43 PM
using DoCmd.TransferDatabase in VB gsurjit VB How-To 2 May 18th, 2006 10:52 PM
Error when using TransferDatabase DrewMills Access VBA 2 November 14th, 2005 05:09 PM
transferdatabase help clowns119 Access VBA 0 February 19th, 2005 10:57 AM
DoCmd.TransferDatabase poonjabba Access VBA 1 August 19th, 2003 07:57 PM



All times are GMT -4. The time now is 06:06 AM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.