zathrus777
Programmer
I am moving a dataset from access to MySQL currently but have an issue with running a query from within access that does the bulk of the query on a remote server but takes a where value from within access.
The where value is exported from an application and can only send it in access 97 format (yes it is rubbish), it then uses an internal link which opens crystal reports and looks at the dataset through an acces query.
In access there are two tables and one query:
Data:
32,000 rows of text + id's
export from application table:
one row - an id corresponding to a row in table above
one query selecting the appropriate row from the table by id. This is the query crystal reports looks at.
This process works fine until it crashes - reason for the rewrite. How do I write a pass-through query that examines the data on the remote server and takes the value from the export table with it. Note that access is never opened as such but accessed from within crystal so macros and vba are out.
help appreciated
The where value is exported from an application and can only send it in access 97 format (yes it is rubbish), it then uses an internal link which opens crystal reports and looks at the dataset through an acces query.
In access there are two tables and one query:
Data:
32,000 rows of text + id's
export from application table:
one row - an id corresponding to a row in table above
one query selecting the appropriate row from the table by id. This is the query crystal reports looks at.
This process works fine until it crashes - reason for the rewrite. How do I write a pass-through query that examines the data on the remote server and takes the value from the export table with it. Note that access is never opened as such but accessed from within crystal so macros and vba are out.
help appreciated
