Error 70: Permission denied

[PaulB]

Hi All,

One of my app's is used by many customers on a different Windows
versions and Access versions. Recently, one of the users bought a new
PC, with Vista. On his old machine, my application runs without any
problem (A2K3).
But the same application on the new machine (still A2K3) results in the
same error in several cases: 70 - Permission denied.
In all these cases, temporary data is written in an (internal) table. I
do have an FE and BE. But for temporary data, an internal table is used.
In fact, in this table, new rows are added.

Like I said, this same app worked fine on his old machine. We tried
switching off the virus checker, without any result. As far as I know,
his user account is administrator (allthough I'm not sure whether in
Vista this is OK/sufficient). Writing (adding) data in external tables
(BE) does not give any problem.

So my question is: can anybody give some comment on thsi error, and how
I can solve this?

Thank you very much,

Paul

 

[Aaron Kempf]

I'd reccomend moving to Access Data Projects; and keep your temp tables in a
secure location

 

[PaulB]

Hello Aaron,

Thank you for your answer, but since I'm totally new with ADP: can you
explain a liitle bit about this. Or is there a site where I can read
about it? Is this compatibel with the current set-up of a BE and FE
application (this is already used by many users)?

Kind regards,

Paul

 

[Aaron Kempf]

ADP is a much much simpler configuration than frontend backend


basically-- keep all your tables and queries in one place-- where they
belong-- on the database server

no maintenance
no headaches
no linking
no connection strings


resources? I'd point you to accessvba.com but it's gone now.. i'd reccomend
a couple of books.

MS Press has a 'Access Projects' book it's just a couple of years old
Dobson has 'Professional SQL Server Development using Access 2000'
and I've got one book from the 'black book' publisher. it's called Access
2000 Client / Server Solutions..

I prefer the blackbook over the rest; but I don't have it anymore.. I leave
books with all my clients when I'm done

-Aaron

 

[PaulB]

Hallo Aaron,

Thank you for your explanation. But as far as I understand this, this
means that I have to rearrange my app completely, and all the users have
to switch as well (none of them have a database server since they're all
private people and not business).
Maybe the set-up you're suggestiong is fine for a new application. I
will certainly take it into account for a new one. But if my current
application runs smoothly with many dozens of users, I was hoping for a
clue to solve my problem, rather than working around it. Aren't there
any other solutions to my problem?

Thank you,

Paul

 

[Aaron Kempf]

obviously

I mean OBVIOUSLY

it's not running fine

I'm so sorry that you made the wrong choice years ago.
Bite the bullet and fix it so that your end users don't have to wait 20
minutes for their reports.