Search results

I have a FE BE database on a network the problem is if the network drops someones connection I get a corrupt BE, is it possible to monitor a network connection and close if one is lost? Jeff

ghudson Thanks for the reply, what your saying makes. I am wondering if what I did is the cause of the problems or if it is just a coincidences

Simple Question: Should both the backend tables and the FE use the same MDW file? I have currently have a database with about 35 users, max of 10 concurrent, I am creating a new front end with added security, so I have created a new workgroup information file. I tested the new FE, with a...

Here is a method of adding attachments: If anyone knows how to add an attachment without first outputing it I would be intrested. Function sendtest() ' Send by connecting to port 25 of the SMTP server. Dim Msg Dim Conf Dim Flds Dim strHTML Dim Attach Dim FSO Const cdoSendUsingPort = 2 Set...

Thanks to you both for the Help. I am very new to this Code thing and but I keep getting myself furhter into by constantly complicating things. Basically what I have is three databases that make up an "Application" 1. FE for Users (as .MDE file 35 users, 8-10 concurrent) 2. BE tables on...

Not sure if this even makes sense: I would like to use a form to hold the values of some variables, so that if thing change (ie name of the mail server), they could just be updated on the form. I can't figure out how to get a text box to hold the value, once I close it's gone. Most likely I...

OK I am stumped, I still dont understand the hyperlink thing, but I have tried everything I can think of to add attachments to this but I keep getting object not supported or something to that effect. Is it possible with this method???

Thanks, this corrects the potential problem Jeff

Thank you both for your advice! I found this when I was testing out one of my forms, I have on my main form a command button which upon being double clicked runs an append query then opens a form which is based upon that table. Well if you over click the code starts twice leading to the append...

I have several forms which have command buttons with event procedures for the Double Click event. What I have found is if I click to many times I can cause errors. After a double click is it possible to deactivate the button so you couldn't acciendtly cause it to run the event again?

Autoeng Thanks for you suggestion, I have checked it out and it works perfectly. Jeff

I have done some searching on this topic without much success, maybe I am missing something. I would like to check the version of the FE against a copy of the FE on the server, and if needed make an update. I dont really understand how to go about doing this. Does anyone have a sample? Thanks...

You might also try adding a hidden field with a link to a table on your BE. I once read part of the reason forms take so long to load intially has to do with the creation of the ldb file, so if on you main form you have a "permanent" link to your backend tables once the form is open the ldb...

Where is the database stored? Are you running out of disk space?? Have you done a compact and repair? If you havent make a backup and try to run a compact and repair.

If you prefer to stick with Macros you cound break this up into separate macros, So when user hits the button the 'main' macro runs this macro then calls the other 2 macro's where 2 is the number of reports your working with, that way if one macro stops the 'main' macro could still go to the...

Thanks Again llkhoutx Once again thanks for you input, I can't say I am sure what I will do. I am wondering if I am even going in the right direction, maybe I should be looking into streamlining the number of steps I have, I am not sure that running so many queries is the right approach...

I Understand but? llkhoutx First thanks for responding to my question, I understand what your saying. But my problem is more along the lines of if say the procces half way through and something fails (append query can't append records due to key violation etc) Somehow I would need to...

I currently have a macro which is run nightly via a windows scheduled task, the macro imports a couple of text files and makes various updates based upon the new text files. Currently the macro contains about 53 steps, most of which are running action queries. I would like to convert the macro...

I currently have a macro which is run nightly via a windows scheduled task, the macro imports a couple of text files and makes various updates based upon the new text files. Currently the macro contains about 53 steps, most of which are running action queries. I would like to convert the macro...