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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS Access - Can't see queries with subqueries or custom functions

Status
Not open for further replies.
pmbtech

pmbtech

Programmer
Nov 24, 2003
47
US
When I connect to my MS Access DB to select a query for a report, none of the queries that have sub queries or custom functions show up. Is this just the way it is? How do I get around this?
 
Sort by date Sort by votes
Try File->Options->Dtaabase and turn on Stored Procedures.

Should show some of them anyway.

The natue of real SQL and queries is not the same as Access, hence your difficulty.

-k
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
Cannot connect to any ODBC datasource with MS SQL Server data in crystal
Replies
8
Views
583
LyleU
LyleU
ChrisLC
  • Locked
  • Question
How to pause or stop refresh using Crystal Reports version 10
Replies
2
Views
141
lbass
lbass
sal21
  • Locked
  • Question
create report without database in vb 6.0 and recordset
Replies
0
Views
347
sal21
sal21
cjbrown815
  • Locked
  • Question
Crystal does not see datasource 1
Replies
2
Views
106
cjbrown815
cjbrown815
Charliy
  • Locked
  • Question
Access 2010/Crystal XI 2
Replies
6
Views
105
Charliy
Charliy

Part and Inventory Search

Sponsor

Back
Top