Recent content by john_c

Me. I don't know what I'm at with it. And I don't think my work laptop with network permissions has the necessary tools to set up OBDC connections. I've imported the data from the linked tables in to a local table on the back end for now and will update them manually for the time being. Not...

I'm having an awful time trying to figure out the connection to the SQL server and am afraid to mess with it too much in case I break it. I tried linking to a csv file but that seems to suffer the same issue of not allowing multiple users. Is there any other way I can make this work??

Thanks Isaac I will have a look when I'm back in the office tomorrow

I managed to blag the username and password for the database. Problem is I don't even know where it is!

Isaac, when you say flat file do you mean a CSV? I'm pretty sure the finance system can export a CSV file if that would make any difference? From speaking to the suppliers of the finance system I have been told that the data is stored in an SQL database. I know nothing about SQL. What would I...

Hi Isaac. Thanks for the suggestion. I tried that and still no joy unfortunately.

From googling it it seems it is a common problem when linking to excel tables do to multi user limitations. I will have a go at what you suggested but long term the database really needs to be linked to the excel file in real time as the file could be updated 10 times a day. Nothings ever easy!!

The excel file updates every day so it wouldn't be practical to copy data into everyone's FE file. Very annoying, everything works great with just one user. Would it be possible to have the back end update a local table at the same time every day from the excel file rather than using a linked table?

Yes, back end on the server and everyone has their own front end on their desktop. I think it would work fine if it weren't for the link excel tables.

Right so this project kind of faded away with the lockdown but its back going again now. I have run in to another problem related to the linked excel table. I have split the database and have the back end on the server. It all works fine when only one person is using it. However when someone...

SELECT tblComplaints.ComplaintType, tblComplaints.Product, Count(tblComplaints.AccessComplaintID) AS CountOfAccessComplaintID, Sum(Abs([ComplaintValid])) AS Expr1, tblComplaints.DateReported FROM tblComplaints GROUP BY tblComplaints.ComplaintType, tblComplaints.Product...

Thanks Minty. Yes it doesn't appear on the chart. Can you think of any way to add it to the chart?

Hi everyone, I have a query which counts the number of complaints my company receives about each of the products it produces and the number of these complaints which the qc department deemed valid. I have a bar chart in a report which displays this data by product. After some fiddling it works...

An yet again I found the solution after asking the question: Its gas, I was googling for 2 hrs this morning trying to find a solution and only found once I started asking here! Thanks for your time anyway!

@theDBguy Any idea why it would behave like this? I know the "Can Shrink" method wasn't your solution but I would hazard a guess that you know approx. 1,000,000 times what I do about Access! The report displays perfectly in Report view but this is not replicated in the print or pdf