Errors with DoCmd.CopyObject?

L

Larry Kahm

Lately I've been using VBA to copy the most recent updates from my
development database to the client's test machine.

I have a table of that has the component names and types, that the VBA
module reads and loops through each transferring the components via
DoCmd.CopyObject.

I just ran a compare of the two databases to ensure that I had all of the
changes [shameless plug for FMS Total Access Detective] and discovered that
all of the recently copied forms had the following three properties
activated (set to Yes) in the test version, whereas they are deactivated
(set to No) in the development version:

AllowPivotTableView
AllowPivotClientView
AllowDataSheetView

Of note, the development mdb is in A20003, while the test mdb is A2000.

Does anyone know if this is an existing/reported problem? I couldn't find
anything despite several searches.

Thanks!

Larry
 

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