Community
Showing results for 
Search instead for 
Do you mean 
Reply

Cannot find Database

New Member
Posts: 4
Country: United States

Cannot find Database

Hello,

I hope somebody can help.  Act 10 on Vista.

Act opens to cannot find database last opened. I go to file....my dbase pad file is shown click on that and it says database has been deleted or moved or network problems.

 

Went to msc.config... Act7 SQL  working fine.

 

Any help would be greatly appreciated 

 

Janus Associates 

Phil Whitney

Bronze Super Contributor
Posts: 1,170
Country: USA

Re: Cannot find Database

When you browse to the location where the pad file is using the 'Open Database' dialog, change the file type to 'adf'...  Do you see your ADF file there?  If so, rename to pad file to something like <MyDatabase.pad.old> and then attempt to open the database directly from the ADF.

 

Also, try turning off your firewall temporarily to see if that is getting in the way...

New Member
Posts: 4
Country: United States

Re: Cannot find Database

When I browse to the database file my db file is not there, only the Demo database is showing.

 

Phil Whitney

Janus Associates

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Cannot find Database

Do you know where the database is?

Find it and copy the PAD file from the database to the folder that opened when you go file | open

New Member
Posts: 4
Country: United States

Re: Cannot find Database

Mike,

You know that would do it, but it is nowhere in my computer it seemingly vanished 

Did a complete search including hidden files nowhere to be found.  I'm completely 

dumbfounded.  The only thing I did in the day or so between the time it was there and it wasn't

was run Registry Mechanic, but I restored that. 

 

Phil Whitney

Janus Associates

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Cannot find Database

What did you search for?

ADF is the best

 

The usual default locations on Vista could be:

C:\Users\Public\Documents\ACT\ACT for Windows 12\Databases

C:\Users\[User]\Documents\ACT\ACT for Windows 12\Databases

* Replace the "12" with the version of ACT!

 

You could open the PAD file in Notepad and see the location it was looking for there

 

Try: Start | run | ACTDIAG

On the left, click Databases, then Database List

Is you database listed? If so, slide the hoizontal scroll bar to see the column: Database File Location

 

As a last thought... any chance you might have changed the machine name?
The SQL database is referenced with the machine name.

If so, you should follow this ACT! Knowledge Base article -

http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=1679...

Copper Super Contributor
Posts: 74
Country: Canada

Re: Cannot find Database

Have a look at your antivirus quarantine area - maybe your antivirus snagged it for some reason?
New Member
Posts: 4
Country: United States

Re: Cannot find Database

Hello All,

 

I found my missing database, it was in the recycle bin (egg on my face) no idea how it got there.

 

You know, this is a great board, thanks for all your help, Thanks Mike for the in depth reply,

 

Phil Whitney

Janus Associates

Boise, ID