Stored Procedures and Access 2003 Professional

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have Microsoft Office 2003 Professional installed on my computer and I have
two different books on Access 2003 "Programming Microsoft Office Access 2003"
by Rick Dobson and "USing Microsoft Office Access 2003" Special Edition by
Roger Jennings. Both books reference Design Stored Procedures, Create Text
Stored Procedures, Create Text Scalar Function and Create Text Table-Valued
Function from the Design Query form, but my version does not have them. Does
anyone know why? Supposedly a full install was performed on this machine.
Do the above features not come with 2003 Professional? I need to use Make
Table capabilities from SQL query, then set the primary index on this new
table, and unable to comprehend the proper syntax or VB code, so wished to
use the wizards to do this for me and now I can't find them.... Any
suggestions would be appreciated.

Thanks in advance
 
RNUSZ@OKDPS said:
I have Microsoft Office 2003 Professional installed on my computer and I have
two different books on Access 2003 "Programming Microsoft Office Access 2003"
by Rick Dobson and "USing Microsoft Office Access 2003" Special Edition by
Roger Jennings. Both books reference Design Stored Procedures, Create Text
Stored Procedures, Create Text Scalar Function and Create Text Table-Valued
Function from the Design Query form, but my version does not have them. Does
anyone know why? Supposedly a full install was performed on this machine.
Do the above features not come with 2003 Professional? I need to use Make
Table capabilities from SQL query, then set the primary index on this new
table, and unable to comprehend the proper syntax or VB code, so wished to
use the wizards to do this for me and now I can't find them.... Any
suggestions would be appreciated.
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

To use the stored procedures, etc. features you have to create an Access
Data Project (.adp) type file. This type of file uses SQL Server as a
data store (aka back end) instead of the JET data store (.mdb file).

To use the wizards to create a Make Table query you have to be using an
..mdb file type. Just start by double clicking the "Create query in
design view" option in the Queries tab. Under the Query menu option
select > Make-Table Query and carry on from there.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQnfWp4echKqOuFEgEQI0MgCeMJkdUGG+zkqh3iH87hShiDYetekAn3PV
zMBOcl6bb3rV6C6VYBy20tE7
=G6gZ
-----END PGP SIGNATURE-----
 
Back
Top