Search results for query: *

don't know if this will work, but its worth a try, can you install the latest MDAC onto the 2000 computers. ? This will give you uptodate odbc drivers.

go into your odbc, click configure then client configuration

are these computers connecting via odbcs ( dsns ) go intothe odbc, configure, then click client configuration

If you can use SP's for everything then this is the best way to do things. but sometimes this isn't always possible. for example, we have users that connect to our data to run their own queries and create their reports, these people don't know how to use stored procedures, so it is easier for a...

I was going to say maybe the computer is not in the lmhosts file for those users. but not sure now if thats the case. are the odbcs connecting via tcpip or namedpipes ?

Stored Procs -- use for applications accessing DB's, such as VB or web pages. Create a layer between the DB structure and the applications, force all data access for these applications to use stored procedures. Views -- use for people who write reports or need to access the data in an ad-hoc...

can you ping the sql server from the computers ?

maybe do a count of the records ticked first, if there is only one then, message asking user are they sure then : delete from activities where id = act if the counts is > 1 then messge first asking the user are they sure : then delete from actviities where id in (act) sound like user error to me.

one reasaon : If users need to access the data via some other application. eg, you can link to a view from ms access or excel. I also use views for creating reports.

glad to here it. hope you can sort out the date field. theres no invalid date in there ?

by doing AS P_Name ( or AS anything really) you are setting the name field to have the name P_Name this way you are not using the reserved word name in your query.

not sure then mate. can you create a similar query with only say 5 fields, does that bring back any data.

can you post your sql ?

try using union all instead of union

is name reserved ? try: TSTFND_tbl_Participants.name AS P_Name,

select distinct issueid from table where issueid in (select distinct issueid from table) try that.

make sure the fields have the same name, also replace nulls.

hi guys, has anybody used this tool : http://www.greymatter.co.uk/Developers/GmHome/sr3_prdidx.asp?id=11756 its called Total Access Analyser. just want your opinions on it, is it worth purchasing ? thanks

gurus, if I click on my form, properties, data tab, I can allow additions here. I don't want to allow additions all the time, only when one button is pressed, can I set this to Yes then add the record, then set it back to NO via VBA ? regards, John

how about: IIf([YesNoField]=1,"Text1","Text2")