Hi all, I'm currently using a pass-through query to access a stored
procedure in an Access database. The results of said stored procedure
is used as the recordsource of a subform displayed as a continuous
form. The problem is, when I open the form, it works exactly how it's
supposed to, but when I close the form and reopen it I get an error
stating that there is an ODBC error and that it cannot find the stored
procedure. The pass-through will not work until I update the
connection string (which is still correct) in the query, close the
database, and reopen the database. Can anyone point me in the right
direction? Thanks
BTW, I'm using SQL Server 2000 and Access 2002.
Re: Record to Large ... In more recent versions, it can be up to 4k characters, though MS says this depends on factors such as your language and Unicode Compression. ... Since this depends on the actual data in each record, it's possible to have a database that works for a while until you actually get a record that's too wide. ... Tips for Access users - http://allenbrowne.com/tips.html ... a pass-through query, which works. ... (microsoft.public.access.queries)
Re: undefined name in pass-through query ... As I understand it, the pass-through query is processed entirely by the server database, without any intervention by the JET database engine, so your pass-through query can refer only to objects that are visible to the server. ... (microsoft.public.access.queries)
Re: Admin Tables ...Sweet.... The app is Access, its a 100% Access application with links to SQL ... This access database is a front end, ... Click in the "Log Messages" property of a pass-through query and press F1 ... (comp.databases.ms-access)
Re: Odd Oracle ODBC error ... In a pass-through query the server side database does all the processing and ... sense of all the field datatypes and it can't always do that. ... (microsoft.public.access.externaldata)
RE: problem :Operation must use an updateable query? ... There are several things that may cause this ODBC error.... The permissions that are set on the directory the database is in. ... Select the ASPNET user and click OK ... (microsoft.public.sqlserver.programming)
