Stored Procedure
Thu, 16 Mar 2006 23:04:59 -0500
I use stored procedure on an oracle server
When i use ADO, i must specified the provider. I use ORAOLEDB.ORACLE
look this
the stored procedure that i need to call have no parameters. Must i
absolutely need a parameter like adparaminputoutput
or i can call directly the storeproc???
This procedure ret ...
|
ODBC linking wizard
Thu, 16 Mar 2006 09:40:31 -0800
I am unable to get the wizard within Access 2003 to appear. I'm trying to
make a link a Sql Server table. All other linking wizards appear on the
other options. When I click on File, Get External Data, Link and choose ODBC
under Files of Type - it simply does nothing.
The correct ODBC connection is set ...
|
Order / Detail solution
Mon, 13 Mar 2006 21:30:07 -0800
I've created an algorithm for Order / Detail based on Chipman and Baron's
examples, but surely there is a more elegant way to accomplish this.
1. From the subform bound to a local detail table I gather its rows like
this:
Public Function DataString(ByRef rintMaxSize As Integer) As String
Dim rst As ...
|
ODBC No Longer Working
Mon, 13 Mar 2006 07:26:27 -0800
I am using Access 2003.
I have been using an ODBC Connection to Microsoft Visual Fox Pro tables
using a connection I created in the Windows Control Panel, Administrative
Tools, Data Sources (ODBC) for months.
I have been able to view and link other tables within the RWBS.DBC set
whenever I have wanted to. ...
|
Order / Detail again
Sun, 12 Mar 2006 15:37:44 -0800
In chapter 11 of "Microsoft Access Developer's Guide to SQL Server", Chipman
and Baron outline an mdb method for writing order/detail records with a
stored procedure where the detail records are passed as a delimited string.
This permits both order and detail records to be entered or edited as part
of the ...
|
Can not linke tables via odbc. Link mngr doesnt appear. BUG.
Fri, 10 Mar 2006 12:30:16 -0600
I've been using MS Access for years and years for connecting to sql server
databases for the purpose of various admin and data transformation
functions. its like a utility tool for me.
Problem: One day when I created a new mdb file and wanted to link tables
from a sql 2k database, I right clicked in the ...
|
MSymDB Error when opening DB
Fri, 10 Mar 2006 10:18:27 -0800
I have a client that cannot open thier mde file. The message received is that
"the Microsoft database Jet Engine could not find the object "MSysDB" file.
Make sure that it exists or that is not misspelled".
Is this DB completely currupted. I cannot open this file in any way I know
how & I have tried to re ...
|
|
|
What am I missing
Fri, 10 Mar 2006 10:37:26 -0500
I know that this should be possible, just seem to be missing something.
Have table with an 'ID number" that is used in a drop down list to add "ID number" to that table.
With a few hundred Numbers it would be nice to remove the "ID number" that have been Entried.
Table 1
"ID number", Data
...
|
MySQL ODBC and saved passwords
Fri, 10 Mar 2006 10:19:30 -0500
Howdy,
Does anybody know a way to create a linked Access table without saving
the username or password in the linked table's connect property? I am
using Access 2002, connecting to a MySQL 5 server with MySQL ODBC
3.51.09. I would like my users to be prompted for username/password
every time they try to ...
|
How to make linked tables to SQL Server views read only?
Thu, 9 Mar 2006 19:29:06 -0700
Hi,
I have a MS Access as the front end, and create several linked table to SQL
Server views through ODBC. I thought by using the views on SQL Server, the
Access front end will have read only rights (that's what I want). However,
the Access front end has all the rights (insert, update, delete, select)
t ...
|
