• 0

Looking for....


Question

Ive got a few questions with some asp programming that I'm having a really hard time solving. If anybody out there can give me a hand with my questions it would be greatly appreciated.

What I'm dealing with is several tables with 100,000 records in each. It all has to be searchable and display the appropriate information depending on the search queries. One of the fields needs to be totaled up and I'm running into an issue with memory use. 100,000 records does not total up very nicely.

The other thing that i'm working with is being able to access each table via a seach box on a previous page. My current problem is that I'm getting this error

Error Type:

Microsoft JET Database Engine (0x80040E14)

Syntax error in query. Incomplete query clause.

and the query clause looks as such:

SQL = "SELECT * From '" & strSearch & "'"

So if there is anybody that might have a few things for me to try, or even better solutions to these problems that would be great.

You can e-mail me, msn, icq or just a simple reply to this thread.

Many thanks,

Mstrmind

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Here is somthing google found:

You need to change the double quotes " " to brackets [ ]Example:

SELECT * FROM "MY TABLE NAME" needs to change to SELECT * FROM [MY TABLE NAME]

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.