Recent content by TommieB

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

Hi, need a little help. I have an application that was written for Access 2000 and has tables linked to a SQL server 2000 DB. It uses both DSN's and DSN-less connections with no ill effects until recently. I have installed the application on a server and provided all the users with icons on...

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 = "ALTER TABLE [tablename] ALTER [columnname] newdatatype" as a SQL statement run from docmd.runsql (strSQL)? Just know that if you change the datatype of a field to...