'breaking' a DB Connection

	Home Register Search Help Login

Sponsors
Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax
Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.
Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Recent Posts
Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

'breaking' a DB Connection

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP, PHP, and Database >> 'breaking' a DB Connection

Page: [1]


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


Spooky Posts: 26723 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: 'breaking' a DB Connection - 9/11/2007 18:30:11 Pretty much wrong there - when you open the file remotely via frontpage, it doesnt open it on the server. It does actually copy to your PC and you are editing a local copy. When you are finished, it uploads the DB again to the server (overwriting any changes that have occurred) With the overwrites - welcome to access..... _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem Spky Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s (in reply to laura161)


ou812 Posts: 1742 Joined: 1/5/2002 From: San Diego Status: offline	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 Black Holes suck. EnterpriseDB: Enterprise-class relational database management system PostgreSQL: The world's most advanced open source database (in reply to Spooky)


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... (in reply to ou812)

Page: [1]

All Forums >> Web Development >> ASP, PHP, and Database >> 'breaking' a DB Connection

Page: [1]

Jump to: 1

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