Trouble Duplicating Application...

[drewangell]

I setup an easy application with a basic insert record behavior to add a
customer's info into the database. The form is a request form for samples of
our product. I then created a list where we can view all the current requests
and go into details, etc. Very basic applicaiton.

I'm simply trying to move the application into a different directory because I
wasn't thinking when I did my original directory structure. I've got my
hardwood request form under my KennysTile directory. I need it under
KennysHardwood. (2 different sites)

I've duplicated all of the files/directories under my KennysHardwood directory
and I've set it up accordinly in Dreamweaver. The pages are all exactly the
same, however, I'm getting the following error on my duplicated app:

Could not use ''; file already in use.
/kennyshardwood/woodSampleRequest/index.asp, line 113

Line 113 is: MM_editCmd.ActiveConnection = MM_editConnection

Again, both of these are exaclty the same. Line 113 is exactly the same on
both. Any informaiton on how I can fix this would be greatly appreciated.

Thanks!

[Drew]

Sounds like your Access DB may be locked or corrupted?

HTH,
Drew

"drewangell" <webforumsuser@macromedia.com> wrote in message
news:d43mjq$1ll$1@forums.macromedia.com...

>I setup an easy application with a basic insert record behavior to add a
> customer's info into the database. The form is a request form for samples
> of
> our product. I then created a list where we can view all the current
> requests
> and go into details, etc. Very basic applicaiton.
>
> I'm simply trying to move the application into a different directory
> because I
> wasn't thinking when I did my original directory structure. I've got my
> hardwood request form under my KennysTile directory. I need it under
> KennysHardwood. (2 different sites)
>
> I've duplicated all of the files/directories under my KennysHardwood
> directory
> and I've set it up accordinly in Dreamweaver. The pages are all exactly
> the
> same, however, I'm getting the following error on my duplicated app:
>
> Could not use ''; file already in use.
> /kennyshardwood/woodSampleRequest/index.asp, line 113
>
> Line 113 is: MM_editCmd.ActiveConnection = MM_editConnection
>
> Again, both of these are exaclty the same. Line 113 is exactly the same
> on
> both. Any informaiton on how I can fix this would be greatly appreciated.
>
> Thanks!
>

[drewangell]

Just so you know, I've already added the IUSR account to the database folder as well as the connections folder just like I always do to make it work.

[drewangell]

I just restarted my computer and the in use error went away now but now I'm
getting:

Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/kennyshardwood/woodSampleRequest/index.asp, line 115

Line 115 is: MM_editCmd.Execute

:( I had all this working. What gives???

[Drew]

Here is some reading material... hope it helps out...

[url]http://www.aspfaq.com/search.asp?q=Operation+must+use+an+updateable+quer y&x=17&y=7[/url]

Drew

"drewangell" <webforumsuser@macromedia.com> wrote in message
news:d43qbg$6rs$1@forums.macromedia.com...

>I just restarted my computer and the in use error went away now but now I'm
> getting:
>
> Microsoft JET Database Engine (0x80004005)
> Operation must use an updateable query.
> /kennyshardwood/woodSampleRequest/index.asp, line 115
>
> Line 115 is: MM_editCmd.Execute
>
> :( I had all this working. What gives???
>

[drewangell]

I was able to fix one of my applications by recreating the database with a
different name. now that one works like a charm again.

I tried the same with another application but I'm still getting the same
errors. I'm pretty sure I've done everything in all these guides I've
seen...but obviously something is still wrong. (sigh)

[Drew]

Try a Repair on the database... maybe that will help (be sure to make a
backup)

Drew

"drewangell" <webforumsuser@macromedia.com> wrote in message
news:d45qai$87l$1@forums.macromedia.com...

>I was able to fix one of my applications by recreating the database with a
> different name. now that one works like a charm again.
>
> I tried the same with another application but I'm still getting the same
> errors. I'm pretty sure I've done everything in all these guides I've
> seen...but obviously something is still wrong. (sigh)
>

[drewangell]

Repair didn't work. Tried recreating the database again to no availe. I've
got all permissions setup fine. I've got the "use record based locking"
unchecked in Access. My other app is working fine again. All my apps I've
done on my home computer for 2 years have worked perfectly (after I leanred
about IUSR)

I simply cannot figure this out. I even re-created the insert page with my
re-created database and I'm getting the same problem. argh!