I have a file in the default folder for hosting databases in Server 8. I can connect to the server and see the file and it is marked "closed". When I select the option to open it the status changes from "closed" to "checking" then back to "closed" with no explanation. I just want to host the file. Help.
a bit late for the answer, but maybe it can help others...
This usually means the file has not been closed properly following a hard shutdown of the server (power outage?). It could be that the file needs to be recovered, or simply checked by Filemaker.
In both cases, you need to open the file with the client version of Filemaker Pro 8, then close it again, and the Server should happily open it thereafter. Here, we keep a copy of Filemaker client on the server for these rare occasions.
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones). click here to download the app (for users in the US for now) and get all the help you need. Good luck!
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Click Start, click Run, type %systemroot% \system32\drivers\etc, and then click OK.
Rename the hosts file to hosts.bak.
Create the new default hosts file. To do this, follow these steps:
Right-click an open space in the %WinDir%\system32\drivers\etc folder, point to New, click Text Document, type hosts, and then press ENTER.
Click Yes to confirm that the file name extension will not be txt.
Open the new created hosts file in a text editor, for example, in the Notepad.
Copy the following text to the file:
For Windows XP or Windows Server 2003
# Copyright (c) 1993-1999 Microsoft Corp.
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
# For example:
# 126.96.36.199 rhino.acme.com # source server
# 188.8.131.52 x.acme.com # x client host
Choose File > Close Company to close the company file.
On all other computers that will use the company file, stop hosting multi-user access :
Press and hold Ctrl while you open the QuickBooks program and continue pressing Ctrl until QuickBooks opens completely. This opens QuickBooks without opening a company file.
Choose File > Utilities >Stop Hosting Multi-User Access. If that option doesn't appear, the computer is not hosting and no further action is necessary.
Repeat steps 4.a and 4.b for each computer other than the host computer.
Configure the QuickBooks server for multi-user access:
Click the Windows Start button and choose All Programs > QuickBooks > QuickBooks Database Server Manager.
Click the Scan Folders tab.
Click the Add Folder button, select the folder that contains your QuickBooks company file, and click OK. Repeat this step if necessary to add additional company file folders.
Click the Scan button to begin scanning. After the scan is finished, the company files in the scanned folders are configured for multi-user access.
Open the company file in QuickBooks. If you receive the same error message, refer to Settings required for firewalls to make sure your firewall is properly configured to allow QuickBooks access to your company file.
Open the company file in QuickBooks. If you receive the same error message, open a different company file or a sample company file located in one of the folders you scanned with the Database Server Manager.
If no company file will open, reboot the host computer and try again.
"The Microsoft Jet Database Engine cannot open the file '(unknown)'"There are several causes for this error message:
The account that Microsoft Internet Information Server (IIS) is
using (which is usually IUSR) does not have the correct Windows NT
permissions for a file-based database or for the folder that contains
The file and the data source name are marked as Exclusive.
Another process or user has the Access database open.
error may be caused by a delegation issue. Check the authentication
method (Basic versus NTLM), if any. If the connection string uses the
Universal Naming Convention (UNC), try to use Basic authentication or
an absolute path such as C:\Mydata\Data.mdb. This problem can occur
even if the UNC points to a resource that is local to the IIS computer.
error may also occur when you access a local Microsoft Access database
that is linked to a table where the table is in an Access database on a
Check the permissions on the file and the folder. Make sure
that you have the ability to create and/or destroy any temporary files.
Temporary files are usually created in the same folder as the database,
but the file may also be created in other folders such as the WINNT
folder. For additional information about how to identify which folder
does not have the correct permissions and how to configure temporary
files, click the following article number to view the article in the
Microsoft Knowledge Base:
Microsoft Access 97 database connectivity fails in Active Server Pages
If you use a network path to the database (UNC or mapped drive), check the permissions on the share, the file, and the folder.
Verify that the file and the data source name (DSN) are not marked as Exclusive.
"other user" may be Microsoft Visual InterDev. Close any Visual
InterDev projects that contain a data connection to the database.
Simplify. Use a System DSN that uses a local drive letter. If necessary, move the database to the local drive to test.
Follow the instructions in the following article to work around this problem:
FIX: ASP fails to access network files under IIS 4.0 and IIS 5.0