Basic question about links to Access database
-
Greetings,
First ever SQL question, so be gentle with me! We have a SQL database that somehow looks at a series of MS Access tables on another server and prepares the data for yet another application to upload to a web-site. As the query I run to update the database doesn't seem to be doing its job any more (I'm not one to fiddle about with things I don't understand!), I'd like to find out why, and the first question I asked myself was this: how can I find out how the SQL database links to these Access files? I suspect that the query or SQL database is not looking in the right place for these Access tables, but I can't prove it one way or the other. How can this be done?
many thanks in advance.
-
Try this: go to the query that is failing. Look at it in Design View. You will see in the upper left hand corner, (I am doing this from memory, so I may be off a bit) an arrow with a drop down. Look for the SQL portrayal. Copy that text and post it here...
Someone more competant in using Access with SQL Server may be able to offer you a better methodology or see a problem within the code...
I wasn't born stupid - I had to study.
-
Ok, first thanks for your prompt attention. Second, at the risk of exposing my ignorance further, I'm not sure I understand what you mean. I've selected the appropriate database, and loaded the query (in Query Analyzer) and can see the text of the query itself, but I don't see how to look at it in design view. Am I using the wrong application here? Sorry if these questions sound silly.
many thanks.
-
Nope - not a bit. It was a poor assumption on my part that this application had an Access front end.
If you can post the query, hopefully we should be able to track down possible problems...
I wasn't born stupid - I had to study.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply