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!

Pass-through or Link ...

Status
Not open for further replies.

KUZZ

Technical User
Aug 13, 2002
254
GB
I have converted a 800MB Access BE into a MySQL back end.
I am accessing it with an Access FE. I have a lot of forms that feed off of the back end. How is it better to access them. Should I link the tables to my FE, or should I use pass-through querries. If the latter is better, where do I build my pass through querries. Do I build them on my front end or my back end?

Good luck,
Kuzz

"Time spent debating the impossible subtracts from the time during which you
can try to accomplish it."
 
now how do passthrough querries work better?

1.build passthroush querries to mirror my BE tables and then build forms based on them.

or

2.link tables to my front end and then go into each form and make querries like passthrough querries?

or.... is there another and better way?

Good luck,
Kuzz

"Time spent debating the impossible subtracts from the time during which you
can try to accomplish it."
 
In terms of performance, you want to get as much of the ODBC subsystem out of the way as possible. In order to promote flexibility, ODBC slows down queries a lot.

I personally would just issue passthrough queries without linking the tables at all.

Want the best answers? Ask the best questions: TANSTAAFL!
 
i have a table in a MSACCESS DB with the following fields:

PTNR = PART NUMBER (varchar, 20)
REV = REVISION (int, 3)
PIC1 = PICTURE #1 (OLE OBJ = to longblob in mysql)
PIC2 = PICTURE #2 (OLE OBJ = to longblob in mysql)


I am trying to import this table using ODCB drives and SQLyog (GUI, for MySQL databases). I cannot make it work. I have tried pushing the data in from an Access DB using update queryes, i tried pulling the data in from SQLyog in both cases using ODCB drivers. I can't make it work.

some PIC1 and PIC2 fileds have pictures store in them
some have only pic1, some only pic2 and others have null in both fields.

The query that imports the data into mysql db craps out when it reaches the fields with data in them. Has anyone tried to import tables with graphix in them from access inty mysql and succeded? If so, HOW?!!!

Good luck,
Kuzz

"Time spent debating the impossible subtracts from the time during which you
can try to accomplish it."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top