SLQ to Access - - LOST

[Bill]

It's me thats lost not the data...

Ok so I'm a novice when it comes to Access and I've learned a lot through
this group. Now I have a challenge to learn more, if my hopes are possible.

I have a Access DB that linked to a BE file. Now that file has been
upgraded to a SQL format. Thing is, I still want to view the data in Access.
All I did before was link to the existing backend DB and make it look nice
via the frontend.

Now can I still do this?

Example:
BE data would be in the access DB table called jobs
FE data would link to this table and display it nicely for the user to review.

If this is still possible to accomplish since the DB is now SQL?

Thanks for all your help.

 

[Douglas J. Steele]

Yes, it's still possible.

You'll need to create a DSN, then link to SQL Server the same way you'd link
to a Jet backend: through File | Get External Data | Link Tables. Scroll
down the Files Of Type until you find ODBC Databases, pick your DSN and
navigate to the table.

 

[Bill]

LOL. You lost me at create a DSN...

Yes, it's still possible.

You'll need to create a DSN, then link to SQL Server the same way you'd link
to a Jet backend: through File | Get External Data | Link Tables. Scroll
down the Files Of Type until you find ODBC Databases, pick your DSN and
navigate to the table.

 

[Douglas J. Steele]

When you select ODBC Databases under Files Of Type, there should be a button
that will allow you to create a new DSN.

Or perhaps you can get your SQL Server DBA to help you create one.

 

[Bill]

Thank you Douglas. I was able to create the DSN and get most to function.
One table does not want to work / link. Anytime I try to access the main
table (of course the one I really need) I get the error "ODBC - Call Failed".
Any idea why the other tables load no problem but I get this error on the
one?

Thanks

 

[Douglas J. Steele]

What's different about it? What are the types of the fields in it? (Perhaps
it's a field type that Access can't handle)

See whether your DBA can create a view on it that Access will be able to
handle.

 

[Bill]

The data structure looks fine. In each field on a dataview mode I get
"#Name?". I can view the design mode no problems and I dont see anything
strange in there. Just when I try to view the data its only showing
#Name?......

Strange. Thx for the help