MS Access error with Tableau

We use Tableau (19.3 at present) to analyse Access and other databases.

We have one access database which produces an error when we try to create an extract in Tableau. I attach a screen shot.

The database works fine in our application, and we can connect to it Live in Tableau. Its just when we connect with Tableau.

We suspect there is a deleted record or something that Tableau doesnt like when it tries to create an extract.

The task is to fix the access database so that Tableau can read it. This assumes it is a relatively simple task such as running some maintenance or re-creating the tables into a new database If it is a more serious error we can discuss how to proceed.

Note the database is in constant use. We can supply one copy for your investigation of the issue but for final implementation we would need to make sure you are working on the very latest version, and we would have to stop processing whilst you perform the repair on the live copy.

Skills: Microsoft Access, Database Programming, Database Administration, SQL

See more: microsoft access database 2007, microsoft access odbc driver, tableau athena driver, microsoft access database, tableau jdbc driver, microsoft access 2010 database, what is microsoft access database engine, tableau microsoft access driver, phpauction database access error please contact site administrator, restricted access error, restricted access error joomla site, can fix restricted access error joomla, access error servercreateobject fdf, project web access error 80004005, getting restricted access error joomla, joomla restricted access error admin, access error, restricted access error site, outlook web access error certificate, joomla login restricted access error

About the Employer:
( 81 reviews ) Harrogate, United Kingdom

Project ID: #23474539

Awarded to:


Hello, there. Nice to meet you. Yes, I also used Tableau for analyse Access DB. I checked your error screenshot. I think some foreign key issue with tables. Let me know if you can send me db dump file. Thanks David Luc More

$80 USD in 1 day
(0 Reviews)

8 freelancers are bidding on average $154 for this job


Hi I am interested in the project. I am an experienced MS Access application developer. I have developed many applications and have done many change requests here on freelancer. If interested in hiring me then please More

$65 USD in 7 days
(83 Reviews)

Hello? How are you? I am excited to work with you on this project. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom formula, etc... [login to view URL] More

$250 USD in 3 days
(17 Reviews)

Sir, I am well versed in these kind of jobs and can do your project as per your requirement. I am very much able to work on this. ***I am ready to start Message me for further discussion. Waiting to hear from you. More

$194 USD in 3 days
(9 Reviews)

Hi, Would you like to see a quick demo of your access database fixed so that Tableau can read it before you award the project? You can consider it professionally done in less than 24 hrs. I can continue telling you ab More

$150 USD in 5 days
(2 Reviews)

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the More

$250 USD in 6 days
(1 Review)

Hello I have experience Microsoft Access Database. If you hire me, I can finish it as you want. I am always ready to work for you and can I start immediately. Let's discuss details via chat. Regards

$140 USD in 7 days
(1 Review)

***** MS Access Expert ***** Hello . I have read your job description carefully. I have full experience in MSAccess and excel macro and vba. If you give me a chance, I will deliver good result. I hope to discuss more More

$100 USD in 1 day
(0 Reviews)