Search results

I thought I did, sorry. Each user has a batch file and loads a fresh local copy on to their pc on startup. It copies over from a network drive.

No, there are no criteria/filters. Im just now weighing up what is going to be less headache, having ethernet cable wired everywhere or moving the backend to sql....

in the table some of the records that are skipped are present, some are missing completely. I do have some "default" values that add on load, such as date, user who is opening the form etc. However, I still dont understand why I cant view these records via the record navigation. Also I found...

Yes, for some reason if we use different versions of an FE, the autonumber gets out of sync and then it all goes to hell. Haha, i think your modal message when the database loses connection may create me more agro than the corruption potentially does.

I have partly identified the issue. Sometimes the network drives would not reconnect automatically, this would mean the FE would not be updated on some users computers. I have found that different age FE do not seem to work together. When I removed all FE, and put same fe on all, they were...

CJ, I have no idea why it skips these records. When I look at the data in the backend, it's there. 1. Query 2. No filters 3. Always skips the same records. I have found this database is corrupted, it's not syncing with the other front ends. Eg if one user makes a new record, it's saved on the...

Hello, I think I have another database corruption problem. When I use the navigation buttons at the bottom to skip forward or backwards through the records on my form, it skips certain ones. I can see them in the backend and the information all appears there and intact, however it refuses to...

Hi Everyone, I have a simple report, one of the columns is a date. The report works fine, but if I right click the date and try to filter for example for today, it behaves in a weird way. It either comes up with a data miss match error in criteria expression, or just shows me some of the...

Pat, I pretty much did what you have suggested ( in a round about way) and now recovered the database to a functional state with most of the data intact. Thanks, Pat, I am trying to understand the first issue you raised about autonumbers. I do have forms with subforms that have the same...

There are also duplicate primary IDs. eg there maybe two patient id of 4. I dont know how this could have happened.

I relinked several times, firstly when I tried to restore the data from a back up, and now on my home pc, I have the fe and be next to each other on my desktop. I relinked tables, they work. I was unaware of dsn-less connections, and I am googling now. Is this a potential way to restore...

Yes I did that, and the autonumbers are all reset and the data is not organised. So for example, if i have a form with patient details, and i cycle with the navigator to the next patient, and the next patient etc, it will start on patient 4, then go to 2456, then patient 67 etc. It should be 1...

Yes, i decomplied the front end, it created a copy which was more corrupted. It just left me with the mysycompact error table with 200+ entries, some are of the form You tried to assign the Null value to a variable that is not a Variant data type. Some are about permissions. I have a...

Yes, so the batch file runs on start up, pulls a copy of the FE from a network folder, then places it on their desktop and runs it. On most computers this works fine. Some seem to not copy properly. Then there is the backend issues...A computer crashed whilst making a new entry, this seemed...

Yes, I did that, the front end now opens, I can see the repair bar at the bottom, and then it says "the last time you opened it it caused a serious error" etc. It also says "id is not an index in this table". I appreciate it maybe my code, however, I dont understand how the front fail, and why...

Hi all, I have been building an access database for our healthcare company for the past few months. I have learnt so much. However, we have had several corrupt database issues, and Im starting to think that access just isnt up to it. I am using a split database, with a batch file to load...

Ok, I have implemented a further fix for this, which I am happier with. It involves storing some information as variables. then re querying the form, this ensures that the previous record is saved and completed, then loading the report from the variable that we saved earlier. Theres probably...

I have fixed it. Its a bit of a bodge, but I called added some vba to save the record several times and for some reason this works. Saving Once doesnt, but a minimum of twice seems to make it work. Thanks.

Yes, I tried that. No joy. I have tried removing everything from the report, just an ID. Its still not working. I noticed that in the filter field of the report it just has "0". Not sure where this is coming from. This is definitely blocking the load of the report. In the where condition of...

I am using variables that are being calculated from other values on the report. I am using VBA. Im really stuck. I have a database with lots of reports, all work fine, except this one. Very strange. I just dont understand that no matter how I initially display the report, it doesnt work, and...