Why won't my Access Data Project work with linked child fields?

A

AaronStewart

I have an Access Data Project (.adp) that links to SQL Server tables. It is
converted from a standard Access database that worked correctly, but I am
having problems with the ADP version!

The problem is that the ADP won't let me link child/master fields in a
subform. It says "Syntax error or access violation" even with the simplest
child/master links.

When I try to set a filter using VBA code, it gives runtime error 2757,
"There was a problem accessing a property or method of the OLE object"

Has anyone succeeded using linked fields or filters on an Access Data
Project, or are these unsupported features?

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top