Run this on your SQL Server installation (not production! Make sure you have permission to do this from your DBA first.
CREATE DATABASE msst_test GO USE msst_test GO CREATE TABLE dbo.
Two tables will be displayed, Person and lookup_Animals, both in the dbo schema.
Select 'Person' and make sure the Connect to a Specific Table checkbox is filled: Now in the resulting box, you can save the connection as a data connection file.
Anyone run into a situation where you have about 30 customer service people pounding in information in an Access form and the form doesn't display the entered data?
However, the entered data DOES appear in the table(s).
What might be causing the forms to not display that data?
Most requests sent to the DBA are for Database Administration issues.
You'll see the connection listed there - click Modify... In this window, click the 'Enable submit for this connection' checkbox to fill it, then Finish and Close. We now have a basic working connection to SQL Server and a blank form to play with. In the same manner as you would in Word, create a title by typing near the top of the page.
Check with your DBA first before saving this file as unauthorized access to these files can mean the breach of your login credentials.
Give the connection a friendly name - mine is called 'Test Connection'.
This article will also guide you through creating an interactive form connected to SQL Server, a template that could be used to produce more sophisticated solutions.
In the course of my work for clients, I often get called upon to diagnose SQL Server issues; a poorly-performing query, unusual error message, an alert from the monitoring tools or some other database administration problem.
When you create the form, the Data Connections Wizard will be displayed automatically.