Hi Imar!

I am referring to chapter 12 - Creating a connection in Dreamweaver - step 5 - page 430.

I copied the database TheSoccerSite.mdb from the source code to C:\TheSoccerSite. But when I try to 'put' it - the following error message is displayed:
------------------------------------------------------------------
An Error occured - cannot put TheSoccerSite.mdb.
The operation completed successfully.
------------------------------------------------------------------

When I check the login.asp page in the browser all goes well with the data already present in the database. However when I test the page with the two new records which I have added to it, I am diverted back to the login page, as these records are not recognized.

For your reference -

1. The database shows in C:\Inetpub\wwwroot. (I don't know how. May be for the first time the database was 'put' properly but the subsequent 'put' operations failed.)

2. While inserting the records I have double-clicked the database in the C:\Inetpub\wwwroot\database and added two records to it - as suggested in the book.

3. I tried to delete the database from the remote server but the same error comes again and the database cannot be deleted.

Can you please help?

Shubhada.

Do you still have the database open when you try to Put the database?
Maybe there are some issues on ME where Dreamweaver keeps a lock on the database.

Here's what I would do if I were you:

1. Close Access and Dreamweaver
2. Extract the database from the code download to c:\TheSoccerSite.mdb
3. Double-click the database, and add two users
4. Close Access. Make sure it's really closed; not just the database
5. Copy the database from c:\ to c:\Inetpub\wwwroot\TheSoccerSite\Database and to the Database folder of your local site (probably, C:\TheSoccerSite\Databases)

I know this is not as good as Putting using Dreamweaver, but I am sure it will work.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Flower by Eels

Hi Imar!

It worked! Perfect!!! Thanks! That was great!

(Now I am looking forward to the next problem..:))

Shubhada.

Hi Shubhada,

I am not so surprised it works; all you did was a simple file copy.

However, the way it is supposed to work is like this:

1. Extract the database to your local folder C:\TheSoccerSite\Database
2. Use Access to add the two users, and the close Access. Again, make sure it's really closed.
3. Go back to Dreamweaver and open the site in Local View. The Database folder should have updated itself to show the (new) database
4. Right-click the database in the files panel (still in Local View) and choose Put

If all works as planned, the database should be sent to C:\Inetpub\wwwroot\TheSoccerSite\Database, so you can log in with the two new users.

Does that work for you as well?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Manifest by Sepultura (Track 10 from the album: Chaos A.D.)

No, it does not work that way for me. The database in local view did show the 2 additional records. But when I tried to 'put' it, the error occured. (Access was closed at that time).

The weird part is that the database in Remote View also showed these two new records. But The login page failed to recognize these records.

However, when I copied the database the way you suggested, everything worked fine.

Shubhada.

Well, in that case I guess we have to file this under "Windows ME" oddities.... ;)

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Bring Em Back Alive by Audioslave (Track 11 from the album: Audioslave)