Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS Access
 Operation must use an updateable query - ANSWERS
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

lbeachmike
Starting Member

USA
26 Posts

Posted - 26 February 2001 :  17:45:27  Show Profile  Visit lbeachmike's Homepage  Send lbeachmike an AOL message
Hey guys - since I'm pretty new with NT and with Access Databases, I ran into this common problem.

After much searching around the board, I finally got on the right track, so I thought I'd share my resolution with a Subject line that would be easy for others to find.

While I'm certain that incorrect file or directory permissions could indeed be the case, it seems that a well-run server is setup with a directory designated for database files.

After poking around, I found that there was a /db/ directory alongside my /www/ directory. I utilized the "whereami.asp" mod which is offered on this forum under "Forum Setup Tools".

After placing this into my /www/ directory, where I'd know it's address, I then pointed my browser at www.mydomain.com/whereami.asp

It then provides the current path.

This path turned out to be:

d:\root\MYUSERNAME\MYDOMAIN.COM\www\whereami.asp

since my \db\ directory is also directly off of \MYDOMAIN.COM\, all I had to do was substitute the \www\ with \db\ and the "whereami.asp" with "snitz_forums_2000.mdb".

This gives me a path of:

d:\root\MYUSERNAME\MYDOMAIN.COM\db\snitz_forums_2000.mdb

I changed it and it worked like a charm.

I'm sure this may be different on different hosts, so you can always ask your host where you need to place your .mdb file if you can't otherwise locate the right directory by poking around.

BTW, I strongly recommend ActiveHost.com (also known as NTWEBHOSTING.com), since their support has been spectacular and there servers are fast. Combined with great pricing, great stats, and feature-rich, they are an excellent choice.

If you do happen to check them out, please use my e-mail address or giftmessenger.com as a referral so I get a free month. But, without the free month, my recommendation still stands.

Hope the above was helpful.

Please stop by and visit www.centralstation.com" target="_blank">http://www.centralstation.com

HuwR
Forum Admin

United Kingdom
20600 Posts

Posted - 26 February 2001 :  17:51:01  Show Profile  Visit HuwR's Homepage
This is very helpful, I am going to lock the topic, so no-one posts and confuses your simple explanation.


Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000 Version 3.4.07