Re: Exporting Report to Snapshot - ODBC Error

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Well, that helped, but not with the issue with the ODBC error, the report
runs much faster, I also changed the Recordset Snapshot to Snapshot, and
still get the error after the report has been run and once I try to export.

Is there any way of bypassing the report coming up in access to directly
come up in Snapshot Viewer?

Thank you for your assistance, its greatly appreciated.

"jl5000" wrote:

> Try changing the timeout to 0, that prevents from checking, also if you are
> filtering the information for big amounts of data it could help to have an
> index on the fields you are using to filter the information.
>
> "ragahmj" wrote:
>
> > Unfortunately I had already tried that, moving the timeout to 120 and still
> > getting the same error. I'm told nothing has changed in the programming to
> > change anything affecting this query.
> >
> > I'm hoping there is something else I am missing on this. Any suggestions are
> > appreciated.
> >
> > Thank you Steve
> >
> >
> > "SA" wrote:
> >
> > > You may be running into a time out issue with the query underlying the
> > > report (i.e. the data set combed probably has increased.) Take a look at
> > > increasing the ODBC time out value for the report's underlying query in the
> > > query properties.
> > > --
> > > Steve Arbaugh
> > > ACG Soft
> > > http://ourworld.compuserve.com/homepages/attac-cg
> > >
> > > "ragahmj" <ragahmj@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > > news:7DA41FDC-FC4A-4D95-8992-55076C7A1A26@xxxxxxxxxxxxxxxx
> > > > When I am exporting a report from Access 2003 to Snapshot Viewer, I am
> > > > getting an ODBC Error when it is almost finished, and if I click on ok,
> > > > the
> > > > message goes away and if AutoStart is selected, the report comes up in
> > > > Snapshot Viewer no problem. This issue just started today and has been
> > > > running fine for months.
> > > > Any thoughts?
> > >
> > >
> > >
.

Relevant Pages

  • Re: Creating Single Snapshot Files for Multiple Records
    ... This query selects the records based on the ticks in the checkbox, and it sounds like you already have that part sorted. ... And we also assume that there is an ID field or some such in the query, and hence the report, so let's suppose this field is called MyPK. ... Dim rst As DAO.Recordset ... Each snapshot is given a specific name for identification purposes. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Sending a form in Access 2003
    ... Save your form as a report ... Specify as criteria in the query the current record, ... the snapshot of the report and attach it to an email. ...
    (microsoft.public.access.forms)
  • Re: Access2000: How to create snapshots with filtering
    ... One approach to this is to base the report on a query, ... > limit snapshot to data from one year. ... Select Case varRepOutput ...
    (microsoft.public.access.reports)
  • Re: Sending a form in Access 2003
    ... Reed33OKC wrote: ... This comes through email in the format I wanted after creating a new report as a template of course. ... is to have just one new record come through the snapshot instead of all records. ... Then you can use criteria to limit the results of the query to just the single record you want. ...
    (microsoft.public.access.forms)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)