Linking to Access Database

[Aidan]

Hello

I am trying to create a Infopath form kinked to an access database and am
having trouble. The access database is split into a back end and a front end
and I am trying to link to the backend but when I link to it I get an SQL
error 'The SQL statement cannot be represented as a tree view. To remove the
SQL statement, click Edit SQL, and then delete the statement.' the SQL
statment reads 'select * from [tblEmployees]' and when you test the SQL
Statement you get the following message ' The ADO Adapter failed to get the
schema.
[0x80040E09][Microsoft JET Database Engine] Record(s) cannot be read; no
read permission on 'tblEmployees'.

I have read permissions on the database and all folders. And when I export
the tables out of the main database into a test database the link works fine.

Any help would be greatly appreciated.

Aidan

 

[S.Y.M. Wong-A-Ton]

Where is the database located? Locally or on a network share? If it's on a
network share, do you also have share permissions?

 

[Aidan]

Hello

Thank you for your response, but I have fixed this now.

The problem was with the access database, I am the owner of the database and
in the Admin group but I wasn't allowed to 'Administer' the database, hence
no read permissions.

I imported all my tables into a new database, re-named the old one, them
renamed my new database to the same name and could give myself Administer
rights on the database.

After this I could connect to the right table with Infopath.

Thanks again
Aidan

Where is the database located? Locally or on a network share? If it's on a
network share, do you also have share permissions?
---
S.Y.M. Wong-A-Ton

Hello

I am trying to create a Infopath form kinked to an access database and am
having trouble. The access database is split into a back end and a front end
and I am trying to link to the backend but when I link to it I get an SQL
error 'The SQL statement cannot be represented as a tree view. To remove the
SQL statement, click Edit SQL, and then delete the statement.' the SQL
statment reads 'select * from [tblEmployees]' and when you test the SQL
Statement you get the following message ' The ADO Adapter failed to get the
schema.
[0x80040E09][Microsoft JET Database Engine] Record(s) cannot be read; no
read permission on 'tblEmployees'.

I have read permissions on the database and all folders. And when I export
the tables out of the main database into a test database the link works fine.

Any help would be greatly appreciated.

Aidan

 

[S.Y.M. Wong-A-Ton]

You're welcome. Glad you got it to work and thanks for sharing your solution
with us - I'm sure it will be useful to others.
---
S.Y.M. Wong-A-Ton

Hello

Thank you for your response, but I have fixed this now.

The problem was with the access database, I am the owner of the database and
in the Admin group but I wasn't allowed to 'Administer' the database, hence
no read permissions.

I imported all my tables into a new database, re-named the old one, them
renamed my new database to the same name and could give myself Administer
rights on the database.

After this I could connect to the right table with Infopath.

Thanks again
Aidan

Where is the database located? Locally or on a network share? If it's on a
network share, do you also have share permissions?
---
S.Y.M. Wong-A-Ton

Hello

I am trying to create a Infopath form kinked to an access database and am
having trouble. The access database is split into a back end and a front end
and I am trying to link to the backend but when I link to it I get an SQL
error 'The SQL statement cannot be represented as a tree view. To remove the
SQL statement, click Edit SQL, and then delete the statement.' the SQL
statment reads 'select * from [tblEmployees]' and when you test the SQL
Statement you get the following message ' The ADO Adapter failed to get the
schema.
[0x80040E09][Microsoft JET Database Engine] Record(s) cannot be read; no
read permission on 'tblEmployees'.

I have read permissions on the database and all folders. And when I export
the tables out of the main database into a test database the link works fine.

Any help would be greatly appreciated.

Aidan