Search results for query: *

Reid, Is that you? This is tommie. What are you up to? Writing Access code? Are you ready to commit hari-kari yet? Tommie

...' --------------------------------------------- strDSN = gstrDSNName Set db = CurrentDb Set rs = db.OpenRecordset(&quot;Select * From tblODBCDataSources Order By DSN&quot;) With rs While Not .EOF If strDSN <> CStr(rs(&quot;DSN&quot;)) Then...

A type mismatch, in this case, probably means that some of the data you are sending is not consistent with the fields that you are trying to place it in. You did not specify exactly where in the code the error was occuring.

I would suggest that you create a code module. Create a function that makes the connection. Pass your sql statement to the function, place the returned recordset into an array and pass this array back to the calling event. Create a sub that closes the connection when the data is returned...

Thank you.

Yes, the database is SQL. Tell me more about xp_sendmail. Can it send attachments? What does using it do to the system resources? SQL servers are notorious for sucking up as much resources as it can get its hands on. Is there a limit to the number of emails it can send out at any given...

I just need to send.

I have been task with sending emails from with a VB application. I figured, 'No Problem', just use CDONTS and I can send multiple attachments, have multiple addresses, everything. Boy, was I wrong! It would appear that none of the damned workstations have SMTP Services installed and the boss...

foolio12, that's okay. After all, we all make mistakes don't we? I should have prefaced my post with the fact that I was addressing grandsbpa's post asking for advice. I have long sinced fixed my problem which meant moving the app to the client's machines and leaving the be on the server...

That will definitely cause the database to have to be repaired. Seen it happen many times, but it also happens if the application gets into a situation where a error message is returned and on hitting OK it stops execution of the program. The program is waiting for something to happen and you...

Are the Win2K machines running access97 as well? If some of the clients are running access2000 and some are running access97, that might be part of your problem. You said it crashes, do you mean it truly goes down or are you getting error messages or corrupted data? you did not say whether...

bluecjh, yes I found that moving the fe to each client and leaving the be on the server solved my problem. The service pack that you mentioned did not seem to help in my case.

Sorry scking, I must have misunderstood what you were saying. I agree that experience makes for better applications, but after a year of doing some pretty complicated stuff in Access, I have to say that if I could have chosen any other development environment to work in, I would have. VB...

scking, I am not sure exactly what point you were making. I got the distinct impression that you were telling me that as an Access programmer, I must suck. If that was the case, thank you for your input, I am sure that you are right, and I will go now and flog myself 100 times for being a...

I don't know if this will help you or not because I do most of my work in SQL, but have you tried doing an strsql = &quot;ALTER TABLE [tablename] ALTER [columnname] newdatatype&quot; as a SQL statement run from docmd.runsql (strSQL)? Just know that if you change the datatype of a field to...

On what line of code are you getting the error?

You are absolutely right. I was trying not to imply anything about Access and it's problems. Didn't want to make anyone mad. Working with Access has been a painful experience at times. It makes some things really easy, but it makes a lot of things almost impossible. I get really tired of...

What you say makes sense. I am used to working in a different environment from what I am in now. I used to work for DOD/AAFES as a VB/SQL client/server programmer and most of the applications ran from an application server with the data on a data server. Maybe that is just the way they did...

I am not sure exactly what it is that you want to do, but if you are needing to link your front end to different databases that are structural duplicates of each other, you might be able to modify the relinking code that I use.

I have actually tested this on 2 machines and it appears that the first one to get there runs its compact, then the other one runs when the first one is finished. It also does not seem to mind that there is someone else in at the time. Maybe it just skips over whatever is in use at the time...