Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Run Access module from CF?

Status
Not open for further replies.

dorianr

Programmer
Mar 26, 2001
32
US
Typcially, I'm used to running stored procedures (SP)in Oracle from CF (MX 6.1). My current project is using an MS Access database. Can I run Access code modules from CF? If so, can I pass parameters? Does anyone have an example? Thanks!
 
Nope. Modules aren't accessible through JDBC/ODBC. You can only call tables or queries.

However.... you can use the ADO object model to do so, using CFOBJECT. Sorry I don't have an example since I've moved on to .NET Land.

Good luck!

Phil Hegedusich
Senior Programmer/Analyst
IIMAK
-----------
I'm not as think as you confused I am.
-----------
Flabbergasted (a.): Amazed at how much weight one has gained.
-----------
Oyster (n.): One who sprinkles their conversation with Yiddish expressions.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top