Hi,
I have a split database that is used by several colleagues. They all have the same front end.
I have buttons which are linked to Macros that will automatically import data from an excel spreadsheet. The filepath to the spreadsheet consists of the full server name as we have some people who have this server on their G drive and other on their N drive.
I have come across a problem where I have one person who pushes the button and gets the Numeric Overflow Error, and someone else who then straight after does exactly the same thing and it uploads the data no problem.
The only difference that I can see between these people is that one of them is linked to G drive and the othe to the N drive, other than that everything else is the same.
Does anyone know why this would happen?
I have a split database that is used by several colleagues. They all have the same front end.
I have buttons which are linked to Macros that will automatically import data from an excel spreadsheet. The filepath to the spreadsheet consists of the full server name as we have some people who have this server on their G drive and other on their N drive.
I have come across a problem where I have one person who pushes the button and gets the Numeric Overflow Error, and someone else who then straight after does exactly the same thing and it uploads the data no problem.
The only difference that I can see between these people is that one of them is linked to G drive and the othe to the N drive, other than that everything else is the same.
Does anyone know why this would happen?