The Stoat
The Grim Squeaker
- Local time
- Today, 23:14
- Joined
- May 26, 2004
- Messages
- 239
Hi all,
I'm thinking about writing my latest DB with an MSDE backend and have a few questions.
I'm aware of the client server relationship and this has made me unsure about the following.
If i link the tables to the access front end am i defeating the point of using a database server such as MSDE. I.e. will all the data be pulled to the front end when it is opened.
Will access attempt to pull all the data to itself when running queries that are in the access environment rather than queries stored on the server regardless of parameters set in the access queries?
How would you use VBA or Access functions in queries or refer to fields in forms and still retain the client server relationship?
Any help greatfully recieved.
TS
I'm thinking about writing my latest DB with an MSDE backend and have a few questions.
I'm aware of the client server relationship and this has made me unsure about the following.
If i link the tables to the access front end am i defeating the point of using a database server such as MSDE. I.e. will all the data be pulled to the front end when it is opened.
Will access attempt to pull all the data to itself when running queries that are in the access environment rather than queries stored on the server regardless of parameters set in the access queries?
How would you use VBA or Access functions in queries or refer to fields in forms and still retain the client server relationship?
Any help greatfully recieved.
TS
Last edited:
