Search results

Hi, I have read that it is important to close any objects and de-reference them in order to prevent corruption. Here is some code that may have caused problems in my database (I've only just added the last line). Could someone check it to see if I've closed and defererenced everything I should...

Hi, Thank you for your replies - I was working on another project elsewhere so I couldn't try your suggestions at the time. However I've had to revisit this problem again as there does seem to be corruption - have another thread about it...

Hi Pat, Thanks for that. I imported everything into a new DB again and resecured it. I ran the JET utility on it to compact it also. This worked and didn't give me any errors - does that mean its ok? It seems to be working all right so far.. To answer your questions: 1. Is the corruption...

Thanks for that Pat and RG, Yes I'm pretty certain I am experiencing corruption - I can't see any other reason for it. Both my users have an their own copy of the FE on their hard drive. These are linked to the BE on the server. Their is one form where they enter new drawings - a drawing can...

I think they have made all the new reports they need for now - or I can do as Pat suggested and have a separate database for their extra reports and let them link to the backend. BUT will giving them the MDE lessen the likelyhood of corruption??

Hi Pat, My users do have their own local copy of the FE. I accept your point about making it easier to maintain/ give them new versions of the FE if I have a separate DB for their reports. What I'd really like to know though is - will giving them a MDE rather than the MDB lessen the chances of...

Hi, With my database I have actually distributed the mdb file to 2 of my users so that they can make their own reports. I have secured it so that these users cannot delete/modify anything they shouldn't. However every so often it seems to get corrupt. I did decompile it and I tried importing...

Hi Kieth, I've just been looking into that myself. What I did was create a utility database that compacted my main database and backed it up. I am using Windows task scheduler to open my utility database each night and then this code is run. The database shuts itself down when its finished. Mine...

Thanks for that Pat but the code is run from a module before the form is opened so I don't know if I could use RecordSetClone in that case??

Thanks for that workmad3 :) I just needed to know I was doing it the best way possible.

Hi, Thanks for the reply. I did put these lines in the form load event of the form but it didn't seem to do the trick: Me.Requery Me.Refresh I've just forund some code to get it to pause for 5 seconds before opening the form and that works fine. Is there any other way I could do this to avoid...

Hi, I'm sorry I haven't replied to this before now - I was working on a different project. The issue is that records added through code do not show up when the form is opened. Just to recap/confirm: - the records are added propperly through the code - I can see the records that have been added...

Compact and backup a database automatically - working I finally got it to work! The code now compacts the database and saves a copy of the compacted file in another folder. I created a database with a form and the following is the code in the form load event. Then I've set scheduled task using...

Sorry that should be DAO OK, I've just discovered that the code I have will work with an mde file. The mde file I was using to test it was secure so.. my question now is how do I compact a secure mde file through DAO?

Compact an MDE file through DAO Hi everyone, I've figured out the best way for me to compact my database from the posts here but I have a small problem with it. My backend end is an MDE file (have no idea why I did that now) and the code I have doesn't seem to work with MDE files. Dim RS As...

Thanks for that RG. I had come to that conclusion myself but am glad that you posted back so I can rule it out for definite. What I've done now is changed it so that only information from tables with one to one relationships are shown on the search form - e.g. comments table and CV table. Then...

Thanks for your reply RG. I did try using list boxes but it didn't work because they weren't bound. How would I get around that problem if I used comboboxes?

Hi everyone, I've tried several different things to get around this problem and have found out a lot about what won't work! Basically I am building a HR database. The main table is M_CandidateDetails and the primary key is CandidateID. This is a foreign key in all of the other tables...

Hi Pat, Thanks again for your reply. The form is not filtered and there is no where query in the recordsource query. I have tried the openForm method without the where clause also: DoCmd.OpenForm "frmOutTransmittals", acNormal and it does not show the 2 new records just added. I have...

Thanks for your reply Pat. However, this code is running from a module and also it is run before the form has been opened. So how do I use recordsetClone? My understanding was that recordsetclone created a copy of the underlying query? (I don't understand why the new records don't just appear...