Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Can I filter a stored procedure ?
Hi, I am new to SQL but have been using MS Access for years. I currently have a problem where a stored procedure that I have created, needs to be filtered further. I know that you can refer to tables and views in a stored procedure, I was wondering if you can access existing stored procedures...- ccraw
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
MsSysObject Permissions
If I use a query within access to append the required info, I have no problems. Once I try to access this table outside of access (Using VB), I then strike my problem. I have even tried creating queries and tables from an external VB program (Using tabledef and Querydef), and I still have had...- ccraw
- Post #3
- Forum: Microsoft: Access Other topics
-
MsSysObject Permissions
I am currently using a VB program that is trying to access the system table MsSysObjects, for linked table information. Using DAO internally in the mdb file, I can retrieve this info without any problems. Trying to read information from this table, with my VB App using DAO, I get an error like...- ccraw
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
-
Loosing cursor focus in datasheet view.
Thanking any replies in advance. Problem: I have a subform which is requeried on a user defined timer event (This is a must as the form has to show new, deleted and edited records ASAP). The form is usually requeried every 10 sec. When the datasheet is requeried the cursor location is sent...- ccraw
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
