Server Side Vs Client Side Queries

[wricoasolutions]

I have split my database, the data is in a DB on the server and the forms, reports, etc is on the client desktop. My question is "Is there an advantage to having all of my combo box queries (Lookups) on the server side (defined in the table as a combo lookup) or should I put the all on the form so that they reside in client side DB.

 

[KenHigg]

I would put them all on the client, simply for house keeping reasons like having to wonder/worry where one might be...

 

[wricoasolutions]

Thanks Ken, Kind of was leaning that way myself, but am new to Access and did not know how it handled the different coding methods.

Again, thanks for the reply.

Bill

 

[KenHigg]

Something tells me he's talking of a straight file server set up here... ?

 

[wricoasolutions]

Clarification!

I Have in the past worked in an Oracle environment and have had code that is left on the server for various reasons. I was/am not sure how or if Access can handle server side coding. From what I am reading and hearing it would appear that it does not. It also appears that Access is similar to FoxPro in that when a table is accessed for a query the entire file is passed to the application for handling. Knowing that I can develop my application with these limits in mind.

Pat: You mentioned a document that I should read on client/server processing, is this specific to Access or is it related to general functionality. Not knowing my way around the forum and/or where documents of this nature are located could you point me in the direction of the document in question. Much appricated........

Thanks for the information and all the help. Will give me the insite to finish the app I am working on.

Bill

 

[wricoasolutions]

It a Jet backend.

Sorry, it's a Jet backend. Have been searching the forum and have found that the Jet backend will not do what I thought it would, (process server side code). By the way there were some good responses from you Pat in my searches. Thanks for the info.. Problem I have is that I can only use Native Access, do not have the choice of MySequel or any of the other DB Server software. So I will have to make the best of what I have and make it run as fast and error free and is possible to do.

Again, Thanks for the info and help.

Bill