Getting a Word doc into Access

[moke123]

64 as well, I just checked. I am synced in the business of bitness! I hope that makes things easier.

Nope. I avoid 64bit office.

 

[jpl458]

Is it because its easier to convert 32 bit ACCESS to 64 bit, or that 32 bit runs on both?

 

[moke123]

Cant use older code on 64 bit access.

Does Pats code run on 64Bit access?

 

[jpl458]

Cant use older code on 64 bit access.

Does Pats code run on 64Bit access?

It opens (SampleWordAutomation.accdb) and it appears to work. When I clicked Preview Letter, the letter open behind ACCESS, but I got this error:

But it seemed to be working other wise. I don't know what that error means, but I found this:

this error is caused by some of the built-in protection in newer versions of office. to clear protected view from your report template, navigate to where you saved the template using windows explorer, and double-click to open it. then click on the enable editing button in the upper-right hand corner of the document.



also have a look at:

https://support.microsoft.com/en-us/kb/264743

Does all this mean I should get Office 32bit?

 

[moke123]

you've been cursed with the latest "security" update,

Right click on the file and select properties. At the bottom there is a checkbox to enable the file

 

[jpl458]

My code does not use API's so it should.

If you've been cursed with the latest "security" update, you have to figure out how to trust downloaded documents.

I am creating the app on a 64 bit machine, but there may be some users that have 32 bit rigs. I checked with Microsoft and I can convert my Office 365 to a 32 bit version, but I have to uninstall the 64 bit version first. Then, is there an easy way to convert what I have to 32 bit. Being the rocket scientist that I am, I didn't think about that part when I started. Will be looking it up.

 

[jpl458]

Thanks so much for that explanation. Now, before I put fingers to keyboard with what I have, on a 64 bit machine, when I covert to 32 bit Office, will I be able to convert what I have , or are we talking rewrite. I just checked the web and there are a lot of hits on how to convert 32 bit Office apps to 64 bit Office, but not the other way. However, I just watched a video by Richard Rost, who says that ACCESS will run on either 32 or 64 bit Office, if you don't have Active X controls or API calls, the app will run on both versions of Windows. The app I am creating uses neither, and is dirt simple. There is minimal data, and everything is self contained in the app, except for Word documents. Do you agree with that?

 

[jpl458]

As I said, unless you are using 64 bit API's - those are calls to the WINDOWS Application Programming Interface and have NOTHING to do with Office.

To see if you will have a problem, take your .accdb and open it on a PC that is running a 32 bit version of Office. If it works, you're fine. If it doesn't, you have stuff to fix before you can run the app on 32 bit versions of Office.

Thanks, Pat. I think I'm safe. In a lot of respects this is a dweeby little app. Not big, not fancy, but workable. You guys have helped me learn a lot.
BTW-I think the first Mainframe I wrote code for was an 8 bit machine. System 360 Model 30. It was the second one ever built, and put into the field by IBM.