Have you ever seen the background tasks view in tableau server? As administrator you can go to Administration-> maintenance -> background tasks to see how the refresh operations went. From there you have hover over any operation to see its status and any error messages.
One thing that comes to mind. Have you installed the latest MS Access driver on your server? You can download it from here: http://www.tableausoftware.com/support/drivers
Thanks for your reply. I downloaded the driver and manually did the refresh on the server, still no luck.
I looked at the error messages, it gave me this:
com.tableausoftware.vizql.dll.DataSourceException: Database error 0x80004005: The Microsoft Access database engine cannot open or write to the file 'C:\Documents and Settings\x\My Documents\Trial.accdb'. It is already opened exclusively by another user, or you need permission to view and write its data.
Unable to connect to the Microsoft Access database "C:\Documents and Settings\x\My Documents\Trial.accdb". Check that the path is correct and that you have access privileges for the requested file.
My access file is closed, and I have no clue how to solve the permission issue.
You need to have the access file placed in a location that the server can access. Tableau does not published the actual access database to the server, just the extract.
Tableau Server is looking the location "C:\Documents and Settings\x\My Documents\Trial.accdb" on the server, not on your machine.
You should create a share drive on the server to a driver letter (like Z:\) and then map the same drive to your desktop (also to Z:\) then both your computer and the server will both be looking at the same file "Z:\Trial.accdb"
Makes sense but the only problem is, I am currently running the Server on my local machine. I am guessing Tableau Server should be able to identify the source?
One thing that came to my mind is that my OS is Windows XP, I read somewhere that the server doesn't support XP, so I don't know if that plays into anything.
Oh okay, you have tableau desktop and server installed on the same machine.
It might be an issue with XP. It probably has more to do with the fact that the Documents and Settings folder has more secure permissions on it. Try moving the access database to the root of the C:\ drive so that its located "C:\Trail.accdb"
It works!! Thanks Michael!
The reason things didn't work out was because Tableau couldn't access the Documents and Settings folder. All I did was moved the file to C:\ drive and things started updating.
I have another question, I have queries in my access file, and if I publish the workbook, will the workbook run its connection to the access file and run the queries within? I don't want to manually refresh the access file all the time then refresh the data source on the server.