|
| |
|
|
Spooky
Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline
 |
Online Access database administration - 2/23/2003 3:19:21
Heres a cool tool that I came across for administering Access databases.
Seems to be quite fully featured :)
http://www.stpworks.com/asp/dbadmin.asp
_____________________________
If you arent part of the solution, then there is good money to be made prolonging the problem
§þ k¥
|
|
|
|
mlatham
Posts: 5
Joined: 1/31/2002
From: Englewood CO USA
Status: offline
|
RE: Online Access database administration - 2/25/2003 17:12:57
Thanks for the tip. From the demo it looks like a very useful item. When I try to use it though I get hung up on:
set xmlDoc_ = Server.CreateObject(" Msxml2.DOMDocument" )
Is this supposed to be part of IIS? Is it only in v5.0?
Thanks again for your help.
| |
|
|
|
mlatham
Posts: 5
Joined: 1/31/2002
From: Englewood CO USA
Status: offline
|
RE: Online Access database administration - 2/26/2003 11:12:59
Thanks for the IIS5 " testimonial." I am curious about what is working for people in regard to managing DB data. I read posts from a lot of people who just open the database from FP, make their changes, and save it. This has worked well for me in the past.
However... What are people doing who have their database (Access) stored behind the root directory? Also, I have some data that is frequently written to the DB from the web (each time a new visitor arrives, or requests a catalog, etc). Some data is better suited to editing in an Access form (like inventory items). If I open Access and edit inventory, the DB will overwrite any visitors that come to the site :(
Has anyone experimented with separating the tables into different .mdb' s and using Access' Get External Data > Link Tables to combine the tables or is there a locking scheme that will provide the results I need? Other than creating a web interface for the whole thing (which has some disadvantages to Access forms when doing data entry) Has anyone found something that works well?
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
) and then when I make changes it saves them back... 
