Page 1 of 1

Export to Access exports nothing?

Posted: Mon Mar 04, 2013 4:56 pm
by Pops
I am trying to export to Access. When I open the .MDB file that the export created, there are no tables or objects of any kind. It is an empty Access database. There is a security warning about disabled content. When I enable the content, still no luck. I have tried opening the .MDB file with a double click, starting Access then opening the .MDB from Access, and even importing from the PCPlus .MDB file into a new, empty Access database. Still, just an empty database.

Am I doing something wrong?

I am running PCPlus v11.1 with the latest maintenance release on a Windows 7 computer with MS Office 2007.

Re: Export to Access exports nothing?

Posted: Tue Mar 05, 2013 5:36 pm
by Pops
Anyone have any thoughts?

Re: Export to Access exports nothing?

Posted: Tue Mar 05, 2013 5:40 pm
by NeilZ
Pops wrote:Anyone have any thoughts?
What area were you trying to export ??

Re: Export to Access exports nothing?

Posted: Wed Mar 06, 2013 3:12 pm
by Pops
At first I tried just membership, then I tried everything. Still nothing.

Re: Export to Access exports nothing?

Posted: Wed Mar 06, 2013 3:35 pm
by NeilZ
Pops wrote:At first I tried just membership, then I tried everything. Still nothing.
OK .. this may seem a silly question, but .. you DO have full system admin access, right ??

Re: Export to Access exports nothing?

Posted: Wed Mar 06, 2013 4:20 pm
by Pops
We don't have any users, privileges, or passwords established in PCPlus. As I understand it, when we use the program we are using it as System Administrator. Is that correct? Also, my Windows user ID is an administrator on my computer.

So, I think the answer to your question is, yes, unless there's something I'm missing.

Re: Export to Access exports nothing?

Posted: Wed Mar 06, 2013 4:58 pm
by NeilZ
Pops wrote:We don't have any users, privileges, or passwords established in PCPlus. As I understand it, when we use the program we are using it as System Administrator. Is that correct? Also, my Windows user ID is an administrator on my computer.

So, I think the answer to your question is, yes, unless there's something I'm missing.
Ok .. so anyone can access, change or delete everything in PCPlus ... very trusting. ;)

That said, the only thing that I can think of is that the data is exported in Access 2002/2003 format. Now Access 2007 should open it fine, unless you still have MS Office 2007 security measures in place:

https://www.powerchurch.com/support/kb.php?id=79&type=1

If you have updated the registry to allow such access, then I think you should call Powerchurch support directly.

Re: Export to Access exports nothing?

Posted: Thu Mar 07, 2013 10:07 am
by Pops
With only two users who both need full access, and just getting started on PCPlus, we haven't implemented system security yet. We'll be adding a user for contributions entry soon, which is when we'll set up security.

I'll check out that link you posted. However, I suspect I'll wind up having to call support. Since I first posted, I tried this on the host data set with the same results. It is a Windows XP machine with Office 2003. The first one I tried it on was my laptop with a separate install that I use for testing, etc. Both installs of PCPlus are the same as far as maintenance releases.

Re: Export to Access exports nothing?

Posted: Thu Mar 07, 2013 11:40 am
by NeilZ
Pops wrote:With only two users who both need full access, and just getting started on PCPlus, we haven't implemented system security yet. We'll be adding a user for contributions entry soon, which is when we'll set up security.

I'll check out that link you posted. However, I suspect I'll wind up having to call support. Since I first posted, I tried this on the host data set with the same results. It is a Windows XP machine with Office 2003. The first one I tried it on was my laptop with a separate install that I use for testing, etc. Both installs of PCPlus are the same as far as maintenance releases.
That is definitely weird ... as I tested the export on my test machine, as well as our live network, and the export worked.

One last thing, this is on regluar PCPlus not Online, right ?

Re: Export to Access exports nothing?

Posted: Thu Mar 07, 2013 3:29 pm
by Pops
Yes, it's PCPlus. Not the online version.

You reminded me of something. The first time I tried the export, it was from a client networked to the host. Since then, I've been trying it direct, not over the network. Surely that wouldn't have locked it up or something weird like that.

Re: Export to Access exports nothing?

Posted: Thu Mar 07, 2013 4:13 pm
by NeilZ
Pops wrote:Yes, it's PCPlus. Not the online version.

You reminded me of something. The first time I tried the export, it was from a client networked to the host. Since then, I've been trying it direct, not over the network. Surely that wouldn't have locked it up or something weird like that.
No, as I was able to do the export using a client. It does sound like there is a problem with your installation or something.

Re: Export to Access exports nothing?

Posted: Mon Mar 11, 2013 11:37 am
by Pops
OK, thanks for your help. I'll contact Support when I get a bit of time I can work on it.

Re: Export to Access exports nothing?

Posted: Thu Mar 21, 2013 3:07 pm
by Pops
I just wanted to close this out with an update. Tech support helped solve the issue. I had to execute one of the programs in the install folder. It's now exporting to Access.