Re: sql odbc links

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

From: Ron Hinds (__NoSpam_at___NoSpamramac.com)
Date: 05/21/04 

Date: Fri, 21 May 2004 09:26:03 -0700

Sounds like a permissions problem on the network share where the Excel file
is going. You need to make sure you have write permissions to the network
share.

"micke" <anonymous@discussions.microsoft.com> wrote in message
news:e67401c43c82$0237e890$a301280a@phx.gbl...
> This one has been driving me up a wall for about two weeks.
>
>
> I am new to the SQL enviornment.
>
>
> My boss comes from a programming background and loves to
> create odbc links to our sql db to generate reports and
> anaylize data.
>
>
> We created a MS Access 2000 db with odbc links to SQL on a
> network share. We created the ODBC links on the boss mans
> pc, which he created basically snapshots of specfic tables.
> He is using queires and a macro that he created that pulls
> the data from sql and updates the tables on his machine,
> this prevents him from playing around with the live data on
> the sql server. He also created another access db with
> tables, queries and a macro that exports data from table
> into an excel spreadsheet on a network share for analysis.
> All this works great on his machine.
>
>
> However, I can seem to get it going on other workstations.
> I created the ODBC links locally on my workstation,
> imported the tables, queries and macros he created. The
> macros run without generating any error messages, however,
> I cannot seem to export the updated data to the excel file
> which is resident on a network share. The file is executed
> but without the updated data. If I go back to the bossman's
> machine and run the update, I can run the macro
> (prodreport) on my machine which executes the excel runapp
> and displays the udpated data. Only the update macro seems
> to be failing. I don't know what I am missing here. I'm
> thinking that my tables are not linked correctly, but don't
> know where to go from there.
>
>
> Any advice or recommendatins would be greatly appreciated.
>
>
>
>
> Regards,
>
>
> Steve
>

Relevant Pages

  • Re: Best Way to Synch 2 Tables?
    ... is it "better" for me to write one macro that calls the Update ... to change the password in the scheduler as well whenever they change ... A better solution, if you can get the Network Administrator to agree, ... database and the SQL database. ...
    (comp.databases.ms-access)
  • RE: Network Connection Issue?
    ... Intermittent network problems can be very difficult to diagnose. ... Dim procCurrent as String ... Dim FileName as String ... 'time to open an Excel file; ...
    (microsoft.public.access.externaldata)
  • RE: Network Connection Issue?
    ... Intermittent network problems can be very difficult to diagnose. ... Dim procCurrent as String ... Dim FileName as String ... 'time to open an Excel file; ...
    (microsoft.public.access.externaldata)
  • Re: Very strange behavior of SQLServer with connection from CGI
    ... this is not a default SQL instance. ... SQL clients use a UDP ... connection to port 1434 to resolve port numbers for named instances. ... You can use the SQL Server Network utility to lock ...
    (microsoft.public.sqlserver.connect)
  • Re: Very strange behavior of SQLServer with connection from CGI
    ... this is not a default SQL instance. ... SQL clients use a UDP ... connection to port 1434 to resolve port numbers for named instances. ... You can use the SQL Server Network utility to lock ...
    (microsoft.public.sqlserver.clustering)