CurrentDb.QueryDefs

[sarnata]

I have a quick question... I am modifying an Access Database used in a multi-user environment. In the code, the original programmer modifies CurrentDb.QueryDefs("somequery") to add a where condition to filter the recordset. The updated query then supplies records to a form.



My question is this. If the CurrentDb.QueryDef is modified for one user does the change affect all users? Is the scope of change for the one user or all users?

If the change affects all users, you can see how this would be a problem if one user filtered on a value, the filter would then be applied to all users.

Any thoughts?

Thanks,
Eric

[ajetrumpet]

if the db is split, which it should be, all users should not see the filters. The only thing that should be in the BE are the tables....the rest of objects in the BE. queries are not source data.

it depends how you set it up though. another thing to note is that currentdb() can randomly cause weird errors when used in code if it's not SET to a database variable. I've had it happen when using currentdb.execute.

[sarnata]

Thanks... And to clarify your last statement... I should do something like this

set db = CurrentDb()
db.QueryDefs("somequery")...

correct? Thanks.

[ajetrumpet]

Thanks... And to clarify your last statement... I should do something like this

set db = CurrentDb()
db.QueryDefs("somequery")...

correct? Thanks.

yes. always make sure too, to indicate which library that database (and recordsets) comming from (e.g. - ADO or DAO)

dim db as DAO.database
set db=current()