Search results

Hi, I am trying to connect via a table but it was suggested to use a query so I tried that. My access setup is an mdb file with the backend tables and an accb with the fe forms, etc. so the mdb tables are linked to the accdb. nothing works, to connect to BI, as mentioned above. I've googled. One...

i did have a where clause in the SQL for city. i removed it and it still isn't working. thank you for your reply.

ok, i will try that. thank you.

When I try to use the Access connector it only provides tables, it does not provide the query I created. That is true for both the mdb and accdb dbs.

I'm working in BI desktop which is installed on my PC. We have a license for O365 but it does not include BI. The access file is located on a server.

I created a query in my accdb for one table. I tried connecting to the accdb table using OLE DB, the query was not available or the back-end tables. If I try ODBC, I get this error:

BI is telling me the table is empty and if I try to load it, I get:

I'll try that but what I also read when I googled is that BI is 64-bit so that's why the 32-bit isn't working.

Hello, I have been trying unsuccessfully to make a connection from Power BI to Access. My Access database is an mdb backend that is linked to a accdb. I tried using the Access connector in BI and have selected both file types. It makes a connection using accdb and mdb but when I click on a...

Hello, Thank you all for your responses. Just to clear up about posting twice. I received an email per my Intro email and it was suggested I post the questions in the appropriate forum. I apologize for the inconvenience. Thank you Pat Hartman for your detailed information in the intro section...

Hello, I am interested in understanding about linked tables. I have inherited an Access database that was created approximately in 2002. When the format changed the database mdb tables were linked to the new Access version. Is this common practice? Would it be beneficial to update these tables...

Hi, My name is Carol. I am not new to database technologies but new to Access. I have inherited an Access database in my position and need help understanding how to determine what is going on. I am using O365 version but do not know when the DB was originally created. I found a query for...