Search results

absolutely not sure at all. The table I changed to indexed is the same table I mentioned earlier that has an auto number field that used to be the PK, that then wasn't the PK as the table didn't have one assigned. So i reset it as the PK. To be honest that is the first table that was put in to...

Thanks for the replies - I at home now but still have RA. So, looking at the backup and the current BE files on the backup one relationship is listed as one to many whereas on the current DB it's listed as indeterminate but I don't see a way to change this. I have tried to recreate the...

Gotcha, So I created a new DB, imported the tables did a C&R and created the query with the same net result, not updatable. I can manually add the information to the second table and everything seems correct on the produced reports. So each table is independently updatable, but when I pull the...

Thanks Pat, although there are over 150 tables and and the relationship view looks like a team of spiders with ink on their feet and slid across the screen :ROFLMAO: I just can't get my head around why this query is non updateable. I've had a look at the article The_doc_Man suggested and...

Indeed, I had come to the same conclusion that the server setup is most likely the reason we are having so many issues and do plan on moving the BE on to a NAS to confirm. I guess I'll need to do this sooner rather than later. I can't see how this is going to resolve my current issue though?

Well, we've changed quite a bit over the last few weeks. -New debian server with SMB share (moved away from an old NAS that was serving this) -Added new users which use Office 2021 The instabilities do not seem to have any theme to them. We now reasonably regularly have a unknown database...

Thanks for the quick reply. We are having a number of instability issues as the moment which I'm slowly trying to resolve. Our main table for example for some reason no longer had a PK even though we have a PKfield which was an autonumber. This also had a duplicate number for some reason which...

Good afternoon, I have a form with a nested sub form to create delivery notes The parent form links to a single table and creates a delivery note number, logs the customer and the date. The sub form is based on a query that contains 2 tables, both tables have the same data in a field in each...

No problem, appreciate you reading the thread and contributing.

Agreed putting it on the NAS would eliminate any possibility of the debian server causing the issue. I will try this. The NAS was taken out of commission when we opened a new site up. Local machines to the server are all on GB Lan. VPN trunk to site 2 but the DB is only ever run remotely via...

All users have the same version of the front end locally stored on their own desktops. This version is controlled so each time a user opens their FE the database checks the FE filename against a table in the BE and if different, runs a .bat file to copy down the latest edition. A user cannot...

Good morning everyone. We have a large split database, where the backend resides on a nas and 3 - 4 users have the front end on the desktop. The front end is version controlled so everyone is running the same front end. We recently moved the file systems from a NAS to a Debian server with...

Thanks, that'll work. And yeah it's just for formatting as I have labels above the text box.

Good morning all, Appreciate the help! I have had a quick search but couldn't find this one. I'm sure it'll have been answered before though. Issue: Unbound text box does not display data when form loads and does not update when switching between records on the form. Form Name...