Database not open

[Leb i Sol]

Hello People!

I just today (after months of flawless serving) I am getting the message that "Datebase not open"

Unable to prcoess your request as the databse is not open?!

I have triple checked and DB is open and available when access with FM...but not on the web and is the only one out of 8 being server? What could have gone bad?

Any ideas or recollections about this issue?

Thank you!

FileMaker Version: 6

Platform: Windows 2000

[Garry Claridge]

Maybe, create an empty "Clone" of the database. Then export/import the records.

I think this was the solution for something similar a couple of years ago.

Good Luck.

Garry

[Leb i Sol]

thanx Garry!

I guess that was it...all I did is save a copy of it...deleted original & renamed it back to its inital name....

rather strange...

Thanx for the tip!

[Garry Claridge]

My guess is that an index may become corrupt! Only a guess.

All the best.

Garry

[Leb i Sol]

ok Garry now ur scaring me

"may become"...or "was" corrupt?

IOW cloning the DB and importing record will be much like 'manually re-indexing'? Is that the deal?

if this is truth then you have just Opened another can of candy & inspiration!

Many thanx!

[mike72]

Hi Garry (and all)

I am struggling with the same issue above - getting the "database not open" message. I moved the database files from a PC to a MAC (for data entry) then back to a PC. The databases open, I can add data, but cannot access the databases with the browser. I have tried copying then renaming, recovering the database, etc. I did export the data, but Im not sure how exactly to clone a blank layout as mentioned above. I could delete all records in a copy, but I wasn't sure that is what you suggested. BTW - I had old copies of the databases (with the same name and same layouts) working just fine. Any ideas?

Thanks,

Mike

[Garry Claridge]

Double Check the sharing for the file. It may have changed by being moved.

Good Luck.

Garry

[mike72]

Brilliant! Thank you! File>>Sharing>>check the web companion box. As I assumed, simple.

mike

[RoadrunnerRay]

Just experienced the same error when I incorrectly entered a DB name in the Web Security Database file. The database was open and accessible from the network and server but not from the web.............

[Anna Neal]

I'm having the same problem.

How do I clone a DB?

Anna

[Garry Claridge]

In the "File" menu go to "Save a Copy as...".

You can select the copy options. "Clone" is without records, hence you have to export records from the current database then import into the "Cloned" database.

Good Luck.

Garry

[Anna Neal]

Thank you so much.

The problem is fixed.