> Is their anyway a query refernecing datasource A can affect datasource B?
No. Well, not unless you have "linked" A & B somehow, say using linked tables or replication or something like that. > I have a query that sets a group of classes offered by a client to inactive in > datasource A if the date is < today. The client is trying to tell me that this > query is causing the products in datasource B to deactivate. Has antone ever > heard of anything like this on an access database? Have you checked inside B to see if the value you think is changing is actually changed ? Have you tried the same thing as your client to see if it really does happen or if your client was doing something wierd ? ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
