ODBC link to SQL server

  • Thread starter Thread starter Gabe
  • Start date Start date
G

Gabe

I am trying to establish and ODBC link to SQL server so
that I may use my Access Database as the "Front Door".
I've established the external data link via ODBC data
source, chose machine data source and selected my table
and unique identifier. So far so good I thought, but all
I get is the empty table structure (empty fields no
data). The SQL server is run by another group and I'm not
familiar with it. They aren't expert with Access and are
puzzled also. My hunch is that the problem is on the
server side and not the client, what can I suggest they
try? What can I try?
 
Next, try using the ODBC link from Excel. Don't expect
it to be any different, but most (non-access) people
are more comfortable with Excel than with Access, so
this will be easier to demonstrate to your other group.

Also, try linking ALL the tables you can get permission
for: if you can find one that works, it may give you a
clue about the problem,

Also, get your 'other' group to attempt the link (using
Excel or even Word if they feel more comfortable with
that, to see if it works any different for them.

Finally, you will probably find that you don't have
read-permission on the table.

(david)
 
I'm not an Excel person! One way to get external data
into Excel is
Data | Get External Data
I think that uses MS Query... I'm sure there are other
ways :)

(david)
 
Back
Top