|
| |
|
|
laura161
Posts: 11
Joined: 9/10/2007
Status: offline
 |
'breaking' a DB Connection - 9/11/2007 16:49:25
My IT guys have told me to NEVER open the Access database I have in my fpdb directory in FrontPage. They say that will 'change ownership' of the DB and 'break' the DB connection. They say if I want to modify my db, I must copy it to my PC, change it there, and then copy it back to the fpdb directory. This is a problem because we're live, and while I'm messing around copying things back and forth, I may write over someone's updates.
I've noticed that the MS instructions say to open the DB from the fpdb directory all the time. Are my IT guys right about this??
Thanks
Laura
|
|
|
|
ou812
Posts: 1603
Joined: 1/5/2002
From: San Diego
Status: online
|
RE: 'breaking' a DB Connection - 9/11/2007 19:26:26
If you only need to update/delete/insert data on a row by row basis, I've had this product installed on many of my Access sites for years. http://sourceforge.net/projects/ute-asp/ It allows updating/inserting/deleting records from any table. Pretty easy to install too. It has a config file and you set up a few parameters, like where the db is located etc. But, if you need to modify tables you'll have to download the db and modify as needed.
<edit> you may want to put some security around it too so that not just anyone can use it</edit>
_____________________________
-brian
EnterpriseDB: Enterprise-class relational database management system
PostgreSQL: The world's most advanced open source database
| |
|
|
|
laura161
Posts: 11
Joined: 9/10/2007
Status: offline
|
RE: 'breaking' a DB Connection - 9/12/2007 8:52:50
Thanks for the info. I've built update screens for my data, so when I need edit my .mdb file it's to add new tables to my application.
So what kinds of things 'break' a database connection? The possibility of that happening scares me a lot since my application is getting REALLY large! I want to make sure that doesn't happen...
| |
|
 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 
k¥ 