luketornado
New member
- Local time
- Today, 19:18
- Joined
- Feb 17, 2022
- Messages
- 6
Hi there everyone,
quick background to what i am talking about, I have a program I use which I use at work to keep track of all machines we have in our possession, we create individual forms for each machine and update it with various bits of information such as parts needed, etc.
This program links to an access form on the network which all computers are connected to called 'tables.mdb'
This file has all information stored which can be accessed from all computers, one day which a computer is editing information is disconnects from the network causing a disruption which atm, if you try and load the program which opens the file, you try to access the file by opening it through desktop or via microsoft access, copy and pasting it or adjusting it in anyway is causing your computer screen to freeze and crash.
I have logged into the network server to retrieve said file and downloaded it which i am now able to access however the program wont open it as it says the file size is too large, when i look into the different reports inside, one form which logs the machines has machines ID 1 and above and increases with every input, there is an error input which has an ID of -793859204 which i assume is causing the error however i cannot delete it from the form, it gives me an error, when i press help it says
This error occurs when an ISAM SEEK is being executed and there are no matching values in the index.
What should I do?
Many thanks
-Luke
quick background to what i am talking about, I have a program I use which I use at work to keep track of all machines we have in our possession, we create individual forms for each machine and update it with various bits of information such as parts needed, etc.
This program links to an access form on the network which all computers are connected to called 'tables.mdb'
This file has all information stored which can be accessed from all computers, one day which a computer is editing information is disconnects from the network causing a disruption which atm, if you try and load the program which opens the file, you try to access the file by opening it through desktop or via microsoft access, copy and pasting it or adjusting it in anyway is causing your computer screen to freeze and crash.
I have logged into the network server to retrieve said file and downloaded it which i am now able to access however the program wont open it as it says the file size is too large, when i look into the different reports inside, one form which logs the machines has machines ID 1 and above and increases with every input, there is an error input which has an ID of -793859204 which i assume is causing the error however i cannot delete it from the form, it gives me an error, when i press help it says
The search key was not found in any record. (Error 3709) |
What should I do?
Many thanks
-Luke