ChristinaB
Last Activity: Jan 28 '08, 12:49 PM
Joined: Aug 27 '07
Location:
-
Ok. I think I've got a lot to chew on for a while. Thanks, Jim! -
Sample Stored Procedures (ADP)
Does anyone know of a good place to get a couple of sample stored procedures for a .adp project in Access? Or maybe someone can just help with this question....
I know how to pull data out for single table:
ALTER PROCEDURE ArchiveLog
AS SELECT PROD_NAME, ARCHIVE_TS
ORDER BY PROD_NAME
but I need to make a query where, to simplify the problem, I've got the tables
DM_LABEL
L_DATA
... -
Wow. That absolutely helped me. From what you describe, I think that ADP could actually be a better option for me. (I prefer to simply type in a SQL query rather than try to 'trick' access into getting the correct info for me.) And this thing will be used by many users, etc, etc.
Thanks for all the info/direction.
-cLeave a comment:
-
Is there any reason that I shouldn't be making this report tool as an .adp?
I've just never dealt with this before, but if it works.......... ..Leave a comment:
-
I'm using Access 2003, sp2. When I look in the registry, I get 2.81.1117.0.
I tried connecting using the ADP, and I can reconnect just fine. You're right though, I actually would like to keep to MDB if possible. However, its nice to see my data for once!Leave a comment:
-
Maintaining links in linked tables
I'm trying to create a simple reporting tool linked to a sql server.
I create a new database,
create a new link table, of type ODBC,
select my datasource DSN= quantum_db.dsn,
click ok,
enter the user name and password,
select the table I want,
and open it.
So far, everything is fine. All the data is there and looking good.
Now I close the table, and close...
No activity results to display
Leave a comment: