By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,573 Members | 1,208 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,573 IT Pros & Developers. It's quick & easy.

Uploading Access Databases

P: n/a
Can anyone tell me how to overcome my 'permissions problems' every
time I upload a new database to my ISP's server.

I have a folder, specially created for me by the ISP, where I can
upload new databases, read and write to those databases and create
text files etc, which works fine with all my existing files and DB's.

Whenever I create a new database on my 'home PC' (Windows 2000, Access
97), finish the associated ASP pages and get eveything debugged and
working perfectly - it all falls apart with permissions problems when
I upload any try to run things on the ISP's server.

Is there ANY way I can create my database in Access97,
'permissions-free' in such a way that the uploaded file gets accepted
by the current permissions of the folder on the server?

I hate having to contact my ISP everytime I make a minor change to my
site - is there a way round this.

Many thanks in advance.

Kenny
Jul 19 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
What error are you getting? And by chance is this a Unix server with
Chilisoft on it, and if so, do you have to "chmod" your .mdb file then?

Ray at home

"Kenny Ashton" <as***********@ctv.es> wrote in message
news:8c********************************@4ax.com...
Can anyone tell me how to overcome my 'permissions problems' every
time I upload a new database to my ISP's server.

I have a folder, specially created for me by the ISP, where I can
upload new databases, read and write to those databases and create
text files etc, which works fine with all my existing files and DB's.

Whenever I create a new database on my 'home PC' (Windows 2000, Access
97), finish the associated ASP pages and get eveything debugged and
working perfectly - it all falls apart with permissions problems when
I upload any try to run things on the ISP's server.

Is there ANY way I can create my database in Access97,
'permissions-free' in such a way that the uploaded file gets accepted
by the current permissions of the folder on the server?

I hate having to contact my ISP everytime I make a minor change to my
site - is there a way round this.

Many thanks in advance.

Kenny

Jul 19 '05 #2

P: n/a
It sounds like a problem for your Web host's tech support to deal with.

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #3

P: n/a
Hi Ray

Thank you for your reply -

1. Error - "In user by another user or no permissions to view" - have
2. ISP's OS Windows NT
3. No Chilkat stuff on ISP's server to my knowledge, but I do use the
freebie Chilkat Mailman under VB on home PC (Not running at time of
probs)

As an experiment, I wrote a short ADOX script on the ASP page to
create an access2000 DB (I want Access 97 but ADOX bit crappy for 97),
uploaded the ASP page and let it create the database.

Guess what!
The Access 2000 DB gets created, presumably inherits the ISP's folder
permissions and it works. So I download the 'new server side created
Access 2000DB' to my home PC - use VB to convert it to an Access 97 DB
and then use Access 97 to add and configure all the tables I want.

I upload this DB back to the server, and it works perfectly.
The database 'creation' process seems to have applied an indelible
attribute related to the ISP's folder permissions, which stays with
the database, ie; I can upload it, download it, modify it, do
anything, send it back to the server - no permissions problems!!!!

So, although I am trying to work around the problem, its always there
- what is the solution? The above experiment would seem to imply that
I need to create a 'blank Access97 database' on the server, and always
download it as a template for any new Access97 DB, make the required
modifications and upload to the server - and it will then always work
with the current server folder permissions.

Have repeated it twice, seems to be a 'work-around' Ok, but does not
solve the basic problem, hence my question -
Is there ANY way I can create my database in Access97,
'permissions-free' in such a way that the uploaded file gets accepted
by the current permissions of the folder on the server?


Personally, I just think MS have now totally lost the plot, and the
whole security issue has become un-manageable for most mortals.

Many thank Ray

Kenny
Jul 19 '05 #4

P: n/a
Why not use Access 2000 format? My suspicion is that the 97 format is the
root of your problem.

Ray at work

"Kenny Ashton" <as***********@ctv.es> wrote in message
news:pj********************************@4ax.com...
Hi Ray

Thank you for your reply -

1. Error - "In user by another user or no permissions to view" - have
2. ISP's OS Windows NT
3. No Chilkat stuff on ISP's server to my knowledge, but I do use the
freebie Chilkat Mailman under VB on home PC (Not running at time of
probs)

As an experiment, I wrote a short ADOX script on the ASP page to
create an access2000 DB (I want Access 97 but ADOX bit crappy for 97),
uploaded the ASP page and let it create the database.

Guess what!
The Access 2000 DB gets created, presumably inherits the ISP's folder
permissions and it works. So I download the 'new server side created
Access 2000DB' to my home PC - use VB to convert it to an Access 97 DB
and then use Access 97 to add and configure all the tables I want.

I upload this DB back to the server, and it works perfectly.
The database 'creation' process seems to have applied an indelible
attribute related to the ISP's folder permissions, which stays with
the database, ie; I can upload it, download it, modify it, do
anything, send it back to the server - no permissions problems!!!!

So, although I am trying to work around the problem, its always there
- what is the solution? The above experiment would seem to imply that
I need to create a 'blank Access97 database' on the server, and always
download it as a template for any new Access97 DB, make the required
modifications and upload to the server - and it will then always work
with the current server folder permissions.

Have repeated it twice, seems to be a 'work-around' Ok, but does not
solve the basic problem, hence my question -
Is there ANY way I can create my database in Access97,
'permissions-free' in such a way that the uploaded file gets accepted
by the current permissions of the folder on the server?


Personally, I just think MS have now totally lost the plot, and the
whole security issue has become un-manageable for most mortals.

Many thank Ray

Kenny

Jul 19 '05 #5

P: n/a

Thank you Ray & JPS
Why not use Access 2000 format? My suspicion is that the 97 format is the
root of your problem.


Sigh! I suspect you are probably right Ray. I have been trying to
avoid upgrading to Office 2000, mainly because each 'enhanced
anything' from MS turns into an ever-growing problem..

Its just very irksome that my 1.3Gz Pentium Toshiba's with Win2000
(which I purchased with expectations of a quantum leap in performance)
actually only run my Access databases only marginally faster than my
oldest IBM 38OD running Win98 on 64K of RAM.

I suppose I'm gradually accepting that Linux, or almost any operating
system, must be an improvement over the feature ridden,
performance-less, resource consuming dll graveyard nightmare that
Windows has evolved into - it can't even stay alive without daily
update transfusions... rant.

Mm sorry about that.

Thanks again guys

Jul 19 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.