Search results

Thanks for all the suggestions. The FE is on each individual PC I do as much as possible use local tables I always compact and repair the database after making modifications I have read all the info and done the suggestions in the persistant connection article. HOWEVER - I have now fixed...

Hi there I have 3 PC's on my Network accessing a back end which is sitting on the main PC. i.e. Main PC has Front End and Back End PC 2 has Front End and is linked to Main PC's Back End PC 3 has Front End and is linked to Main PC's Back End PC 2 and PC 3 take about 5 minutes to load the...

Thanks Rak - Am I being thick (don't answer that) but that shows you how to link to your outlook inbox ect, I need to be abkle to send an email without havign to have outlook open. Linking to my inbox won't help me achieve that will it?

Yes I did and spent half a day trying some of them out but couldn't find anything that worked. Maybe you could point me in the right direction.

I have been trying to find out how to do this for ages...! Does anyone know how to open Outlook from Access when Outlook is closed. The main reason I need this is because my staff keep shutting Outlook down and so I do not get my automatic reports at the end of each day due to it...!! Then...

I have just had the same error when I tried to compact the database. It make the database unuseable!! Luckly I have an older non corupted copy so I am having to export all the forms ect I have changed since that version over to that working database. Hope I don't miss anything...!!!

Surely that's more of a window file user level security problem. Access doesn't know whether your deleting the BE or not does it??

Yes, I did it this way before and it seems to be the only option :(

If I run the following code below on two PC's at the same time accessing the backend database, "zz_LockTest", one of them errors with the message Microsoft Jet Database engine stopped the process because you and another user are attempting to change the data at the same time. I thought that...

Anyone know how to search for a line of text and replace it with 2 lines? i.e. Search for: Set cnn = CurrentProject.Connection and replace it with: Set cnn = CurrentProject.Connection cnn.CursorLocation = adUseServer

I am doing some experimentation on locking and have noticed that when you open a record set and update to it lie this: cnn.CursorLocation = adUseClient rstTestLock.Open "zz_LockTest", cnn, adOpenStatic, adLockOptimistic, adCmdTable It processes a lot slower that if you do it like this...

There isn't anything on the server. I don't have a server. I am woking on a standalone PC The bit of code I showed above is in the FE which opens a connection to the BE so that fields can be added if required to the BE tables. It then closes the connection and the main form runs. It's just an...

Thanks for your reply. I compacted and repaired the BE and that seems ok now. I do set db and wrk to nothing but as you rightly said, if there is an error then this gets missed out so I have moved the line down to the error handler section. I would have thought that shutting access down and...

It's actually just got a lot worse today. It's saying that the backend database is in use now whatever I do and the backend database increased in size from 20meg to 200meg!!! I cannot even put a combo box on a form without an error occuring...!!

I am getting the message "You do not have exclusive access to the database at this time" whenever I try to make changes to my forms. This problem only happens after I run the following statements and I get the message "Cannot access C:\SALON-NET\Data\Salon-Net_be.mdb; file already in use" Dim...

Thanks for the reply, but that is already how I am doing it, but it requires you to hardcode the sub-routine name into each handler in order to log it.

Is there a set variable or property that can tell you which Sub you are in? I want to use this to log errors. i.e pass the module and sub routine name to the error handler log file. The only way I can do this at the moment is to physically hard code the sub routine name into each error handler.

Yes, have had a look at it. Tried the harddrive serial number thing but it just returned "0000-0000" on all harddrives I tried it on. Nevermind, if there is no easy way to do it, I can just produce my own unique ID for each current session Thanks for ytour replies.

I did. I spent about 20 minutes looking but found nothing of value. Will have another dig about....

Anyone know how to get the computer ID or name unique to your computer? I want to be able to use it in a database to keep logs for each computer on the network. Any ideas?