To use Access Project with SQL Server - JMU
To use Access Project with SQL Server
First OPEN SQL Server (Enterprise Manager)
IMPORTANT HINT FOR AVOIDING PROBLEMS:
DON’T HAVE SPACES IN DATABASE OR TABLE NAMES OR PATHNAMES.
Open Access
click on File
click on New
click on Project using existing data
[pic]
Enter a filename
[pic]
Click create
Enter Server name
[pic]
click on Use Windows NT Integrated Security
select the database on the server
test connection
Click on any table that appear… Make sure that the * appears at the bottom[pic]
If it doesn’t, you will have trouble entering data in the table OR IN YOUR FORM. If it’s not there, the chances are that your SQL server table doesn’t have a primary key indicated. Go back and change it.
Click on FORMS
[pic]
Click on
[pic]
Choose fields you want from one or more tables.
[pic]
Choose next
[pic]
Choose any format and click finish
Example form
[pic]
Again, make sure that the * appears
If you get an error message about , note that in your SQL Server database you should either explicitly allow nulls or provide a default value for attributes not on your form.
Bells and Whistles
Click on Forms
Select a Form
Open in Design View
Right click on white part of box you want to make combo box
[pic]
Click on Change To
[pic]
Select what you want to have (i.e. combo box, list box, etc.)
[pic]
You want the data tab
on the Row Source Type
[pic]
select Value List
On Row Source type in the values you want separated by semi-colons
[pic]
Choose whether you want to limit the possible input values to the Value List or not (e.g. Limit To List – yes or no
Save your changes by clicking on the red X
If you want something to happen when you start up
go to Tools and click on Startup
when the screen below comes up – type in the FORM you want
[pic]
[pic]
Then click on ok to save.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- to use access project with sql server jmu
- introduction project management docs
- system administration manual
- baseline project plan report
- master project plan mpp california
- final project report template franklin university
- is 312 project one database
- roles and responsibilities template
- section 01310 project management and
Related searches
- when to use an apostrophe with names
- sql server datetime to date
- sql server number to date
- sql server convert datetime to utc
- sql server utc to local
- sql server convert date to string
- sql server convert numeric to string
- sql server varchar to date conversion
- sql server cast datetime to varchar
- sql server datetime to varchar
- sql server convert datetime to varchar
- sql server utc to est