Can't create an ade/VB author



I update the forms in an adp periodically and republish ades from it when I
do, and sometimes Access prevents me from creating the ade. Experience has
shown me the cause is usually a specific form, and the reason the form is
'hanging' the creation is that I might have inadvertently authored code in it
with a different connection (for example, logged in via network security,
when I had initially authored the adp logged in via SQL Server security). I
now remedy the problem by copying the adp and deleting forms one by one and
trying to create an ade each time, until I hit the form that's causing the
trouble. Once I recreate it, Access can make the ade. Is there some way I can
find the troublemaking form more easily, such as by issuing some sort of
query against the adp to tell me who's authored what forms or controls?


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

Similar Threads

Unable to create an ADE database 0
Very Strange ade 1
works in adp but not in ade 0
authorization 1
Searching on author for books with multiple authors 1
Author Help 0
Chg 2002 ADP to 2003 ADE Breaks! 0
VB 3