Shared User Issue When Opening Database

I have an issue this afternoon which, I feel probably isn't directly related 
to Access, but would be grateful for guidance if anyone has experienced this 
before.  

I have a database (default open mode - shared) which, this afternoon, won't 
allow a second user to open it.  If a second user tries to open the database 
a message box is displayed quoting the path of the database file  plus "The 
parameter is incorrect"

The database is located on a shared folder on our network.

Thanks for any assistance.

Dave
0
Utf
3/17/2010 4:21:01 PM
access 16762 articles. 3 followers. Follow

2 Replies
828 Views

Similar Articles

[PageSpeed] 42

ONLY the data should be on a shared folder, not the front-end application 
which should be split and on each workstation, linked to the data on a 
server. You have probably corrupted the database. Here are some possible 
resolutions:

First, always work on a copy of the database. Working on the original may 
make it impossible for a repair service to fix it.

Decompile your database:
http://www.trigeminal.com/usenet/usenet004.asp

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText 
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you 
may need to create a new database, import what can be salvaged, and recreate 
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving 
corrupt databases. Try this URL:

http://www.pksolutions.com
-- 
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Dave C" <DaveC@discussions.microsoft.com> wrote in message 
news:1C6FF0F1-3DD7-420F-B6AB-EF3D024A6B61@microsoft.com...
>I have an issue this afternoon which, I feel probably isn't directly 
>related
> to Access, but would be grateful for guidance if anyone has experienced 
> this
> before.
>
> I have a database (default open mode - shared) which, this afternoon, 
> won't
> allow a second user to open it.  If a second user tries to open the 
> database
> a message box is displayed quoting the path of the database file  plus 
> "The
> parameter is incorrect"
>
> The database is located on a shared folder on our network.
>
> Thanks for any assistance.
>
> Dave 


0
Arvin
3/17/2010 5:15:27 PM
Thanks for all the information Arvin.  I'll have a good look at what you've 
provided and see what we can do.

Dave


"Arvin Meyer [MVP]" wrote:

> ONLY the data should be on a shared folder, not the front-end application 
> which should be split and on each workstation, linked to the data on a 
> server. You have probably corrupted the database. Here are some possible 
> resolutions:
> 
> First, always work on a copy of the database. Working on the original may 
> make it impossible for a repair service to fix it.
> 
> Decompile your database:
> http://www.trigeminal.com/usenet/usenet004.asp
> 
> Download a copy of JetComp.exe:
> 
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956
> 
> Try backing up your forms as text with the undocumented SaveAsText 
> LoadFromText functions:
> 
> http://www.datastrat.com/Code/DocDatabase.txt
> 
> Also have a look at the Microsoft KB article:
> 
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137
> 
> Then have a look at Tony Toews' Access Corruption FAQ at:
> 
> http://www.granite.ab.ca/access/corruptmdbs.htm
> 
> for some suggestions. Unfortunately, some corruption cannot be fixed - you 
> may need to create a new database, import what can be salvaged, and recreate 
> the rest.
> 
> Although it's a paid service, Peter Miller does an outstanding job of saving 
> corrupt databases. Try this URL:
> 
> http://www.pksolutions.com
> -- 
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.mvps.org/access
> http://www.accessmvp.com
> 
> 
> "Dave C" <DaveC@discussions.microsoft.com> wrote in message 
> news:1C6FF0F1-3DD7-420F-B6AB-EF3D024A6B61@microsoft.com...
> >I have an issue this afternoon which, I feel probably isn't directly 
> >related
> > to Access, but would be grateful for guidance if anyone has experienced 
> > this
> > before.
> >
> > I have a database (default open mode - shared) which, this afternoon, 
> > won't
> > allow a second user to open it.  If a second user tries to open the 
> > database
> > a message box is displayed quoting the path of the database file  plus 
> > "The
> > parameter is incorrect"
> >
> > The database is located on a shared folder on our network.
> >
> > Thanks for any assistance.
> >
> > Dave 
> 
> 
> .
> 
0
Utf
3/17/2010 10:10:01 PM
Reply:

Similar Artilces:

Money 2002 Synchronization Issue
I'm having trouble finding any information on how to get around the synchronization issue that I'm having with Money 2002. When I try to sync it up with moneycentral, I get a message that I need to find the solution at MSN moneycentral, and that it needs a file in order to be able to sync up with moneycentral. I have looked and have not found any answers on moneycentral or anywhere else. Does anybody have any ideas? I am havingt the same problem. "adamjensendo" wrote: > I'm having trouble finding any information on how to get around the > synchronization ...

Check Printing
We are having problems in printing our checks to the printer. All the information is printed correctly, it does not use page breaks correctly. All the other reports works correctly without any problems. The page breaks works correctly if the printer is attached to Windows 2000 print server. It stopped working after we switch to Windows 2003 print server. We tried every possible print driver from HP web site without having much luck. We tried HP 4100 and HP 4250 and I do see these are listed as supported printers. Version 5.0 listed as Supported Printer driver on Great Plains Web Sit...

programmatically add control for user interaction/feedback
Hi there I am using Excel 2003 and VBA to programmatically create an Outlook 2003 e-mail message. All is working perfectly on this score ... I want to ramp up the sophistication a bit and let a user who receives an e-mail enter some text in a textbox and return the data to me by reply e-mail. Is it possible to programmatically add a control (say, a textbox) to an HTML e-mail message using the Outlook object model from within Excel 2003 using VBA? Best regards Loane Not on the recipient side, which is where it sounds like you'd want it. = Any self-respecting email program will ...

Is there way to give project ownership to another user in bulk?
All I know right now is to go into PWA, edit the properties of each project and pick a new owner. Is there a programmatic way to do that for lots of projects at the same time? Thanks, Andy Novak UNT Hi Andy, I think you'd need to code this somehow. -- Regards, Ben. http://www.applepark.co.uk http://appleparkltd.spaces.live.com/ "anovak@unt.edu" wrote: > All I know right now is to go into PWA, edit the properties of each > project and pick a new owner. Is there a programmatic way to do that > for lots of projects at the same time? > >...

When I open up excel a worksheet that has been inputed opens up w.
How do I start excel with a blank worksheet Hi There is either some excel file in the starup folder or files are opened through Tools, Options, General Tab, "At startup open every file from folder:" (please note this option may vary since I am using a french version) HTH Cordially Pascal "EL GUAPO" <ELGUAPO@discussions.microsoft.com> a �crit dans le message de news: C033BB21-8298-46A6-8697-34B5F9BB56F0@microsoft.com... > How do I start excel with a blank worksheet No, that's not it. That does just what it says, it opens every file in that folder. H...

Open File
I created a shortcut to a executable on a mapped network drive. And I get the open file security message. I Googled this and found the page below. Tried both settings in IE; Include all network paths (UNCs) And add the server to trusted local sites. Neither works. Still get the error message. Is there anything else that I can try? http://windowsxp.mvps.org/networkfile.htm Thanks ...

Your standard email folder can not be opened
Good day, we have a new customer with an SBS2003 and XP clients. The people who have set up the system two years ago are not available any more. We created two new accounts using the SBS assitant, like we always do. All is well, but if we log in with the new account on any client and open Outlook it does not work. First we enter the exchange server name and account name and OL recognizes them. Then the message "Outlook accounts are configured and welcome message is generated" appears. Next we get the following error message: (I've translated it from German so it may be...

shared environment
I've created an excel workbook with forms, reporting (lots of coding in VB). If it's opened only on a one machine it's working well. But, if somebody opens it read-only and does some reporting (that should be Ok for the read-only mode), there is always a problem and odd data (empty reports, etc.) Could I fix it somehow? Thanks I think you'll have to much more specific to get any useful response. But I've used many workbooks that were marked readonly (to stop updates) and the macros worked fine. So I don't think just having the workbook open in readonly mode is...

Problems when opening in Publisher 2003 vs 2007
I have a file someone sent me that when opening it in Publisher 2003, it appears as a long narrow strip with 8% zoom. However, when I open the same file in Publisher 2007, it appears as it should. They only have Publisher 2003. Is there something that needs to be changed in 2003 so that the file appears correctly? -- shel What happens if you re-save the document? Publisher 2003 will open 2007 publications. -- Mary Sauer http://msauer.mvps.org/ "shel" <shel@discussions.microsoft.com> wrote in message news:8444042F-56E8-4390-A00D-FBFB155903F5@microsof...

Outlook 2003: 2 Users share 1 inbox, 1 POP/SMTP acct w/o Exchange Server?
My wife and I need to share a common Inbox in OL 2003. ( One logon at a time) We have seperate "contact Lists / Address Books" however we can share common In-Box sub-folders for saved email. We're not a business and I don't see a need for an "exchange server." How can this be done in Outlook 2003? It came with our new system. http://www.slipstick.com/outlook/share.htm -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Outlook Tips: http://www.outlook-tips.net/ Outlook &am...

Presenting data from database
I have an idea to allow users to enter data through web interface but I wish to have output in Excell file, normal table with sum values or just data from database. What is the easiest way to make something like this ? regards Peter ...

schedule backup database
There is a backup database under file menu which is very nice. I just wonder that can I schedule to do backup in the background just in case I forgot to do so. Is it schedule a batch file to copy mdb file to destination directory best solutions for this or Access can let us schedule backup database on daily basis? Your information is great appreciated, I previously setup up a scheduled task to run at 2:00am that ran a simple vbscript which copied the db to a backup destination. It all depends on your scenario, but the above mentioned worked great for me! -- Hope this helps, Daniel...

Create users on GP V9 on SQL2005
After you create users and give company access on the Client/Server installation you go to the physical client to logon, you cannot logon using any of the users that you have just created, the only way that you can then logon is by logging in as SA on the client, go to Setup, Users, call up the user that you want to use to logon to that particular client machine, save the record and come out, only now can you successfully log into GP with this user. On the server, was the DSN used to access the app setup to as '(local)' or '.' as the Servername rather than the full ser...

custom function that reads user information
Hi, I am looking for a custom function that reads some kind of use information (either author name, or even excel registration number that is somehow unique (so best choice might be registration number and that is stored somewhere on a persons computer. I want to incorporate an If statement, so that the function onl returns a proper value if the information read from the person' machine is identical to that specified in the function. Any help is greatly appreciated! a -- Message posted from http://www.ExcelForum.com Check this previous posting http://tinyurl.com/32nuj -- HTH ...

Converting User IDs to User Name
Hello I have a macro which I've been using for quite some time. This macro allows the user to identify the User IDs of people listed in the spreadsheet. However, I now need a macro to do the reverse. That is, it needs to find the names of people whose User IDs are listed in the spreadsheet. If possible, it would be great to list the given anme and surname in separate columns. Is it possible to modify the macro below to achieve what I want (i.e. so that it does the reverse of what it currently does)? Any help would be greatly appreciated! Joe. -- If you can measure...

Registered User Name
WinXP.SP3. I have installed Windows XP in my computer from an OEM copy that came with my system. I have always kept my system updated but never registered the copy of Windows with Microsoft. Recently I noticed that whenever I try to install a new program, the user name and the company name that appears on the initial install screen defaults to somebody else's name. When I look at the General Tab of the System properties, it appears that the software is registered to that stranger's name and company. Is there any way that I can change the user and company name to my...

Issue with Powershell while using P4.net libraries
Hi, I am started recently to write scripts in powershell for perforce. I found P4.net dlls and trying to use that, but finding difficulty in starting itself while connecting to P4. I have loaded the dlls and using $P4.connect() but its throwing some error, Please let me know have I missed anything PS V:\> $p4dn=[Reflection.Assembly]::LoadFile("C:\Users\harshas\Desktop \ICAAutomation\PowerScripts\p4dn.dll") PS V:\> $p4net=[Reflection.Assembly]::LoadFile("C:\Users\harshas \Desktop\ICAAutomation\PowerScripts\p4api.dll") PS V:\> $p4 = $p4net.CreateIns...

Insert data from a Dataset into a SQL Database
Hi guys my name is Ralph, i am kinda new to this so please bear with me. I have written a .net web service which accepts a stream of data see relevent source code). Public Function PutBondInfo(ByVal data As String) As DataSet Try Dim zh As New ZipHelper Dim sz As String Dim cn As SqlConnection Dim da As SqlDataAdapter Dim ds As New DataSet Dim xSet As New DataSet Dim sSql As String Dim mySerializer As XmlSerializer = New XmlSerializer(ds.GetType()) cn = New SqlConnection(&quo...

Excel:I set the font color to be "Red". Next time file is open, f.
Say I sent the font color to Red in the cell. The next time I open the file, the font color in the cell changes? Why Maybe you didn't save the file? >-----Original Message----- >Say I sent the font color to Red in the cell. The next time I open the file, >the font color in the cell changes? Why >. > ...

Sharing Excel files
I'm sharing a file on our network (approx 1mb in size). occasionally, the print areas are completely cleared. aside from user intervention, is there anything that can cause this? Not sure about Excel 2000, but in Exel 2002 there is a sharing functio you have to turn on. From you discription, you do not have it turne on. Tools > Share Workbook... Most of the options that come up are self-explainitory, but you ma want to review the help files are keeping tracking of a change histor if you want to do that ----------------------------------------------- ~~ Message posted from http...

have to add user to local admin group
Hi all I am running Exchange 2003 sp2 on windows 2003 sp1. Everything is isntalled on one server, AD and Exchange are on a single server. I am faced with a troubling problem. I need to give rights to a user so they can add email enabled contacts into an OU. I have given the use the delegated perms to do this, and they can add user to this OU no problem. I have also installed the Exchange admin tools and 2003 admins tools on the users machine. In order for the user to create contacts with an email address in the OU, I have to add this user to the local administrator group on the Exchang...

Memory Leak issue
Hi I am having the product which is implemented in the following Microsoft technologies MFC, COM dll, COM ocx , COM server, Windows static lib and windows dynamic library Product functionality The application is the real-time interface for monitoring and managing alerts from server. The product is a Windows-based system management console for managing event information. The presentation layer displays the alerts coming from the Server. The incoming alert rate is 3-4 alerts/sec. So continually some alerts are coming in and also going out from the application. I need help in two aspe...

Can't Compact my Database
Every time I go to compact my database, Access shows, "Unrecognized Data Format 'P:\...\...\...\file name.accdb'". I can't compact this. Previously, I had set it to automatically compact, but that actually corrupted the file beyond repair so I couldn't even open it. Please tell me how I can compact this file. It sounds like it's corrupt again. First, always work on a copy of the database. Working on the original may make it impossible for a repair service to fix it. Try importing all the objects into a new empty database. Download a copy of JetComp.exe:...

Country codes
I'm trying to allow our CSRs to add country codes when they are setting up new customers, but they are getting a security error message. I can't figure out what they need access to as part of their security role. You can enable the Security Task ID "CARD_0201*" for the Role ID "CUSTOMER SERVICE REP*". (I guess I got the Role ID right which is setup for your CSRs). Once you enable this, you can open the Security Task ID "CARD_0201*" on Security Task Setup form. Select the Product "Microsoft Dynamics GP", select the Type "Windows"...

Category Issue
Hi Folks! I have a loan that I set up in Money 2004. I set up a budget that takes in account what amount I spend to service the loan each month. The category that the budget function in Money uses is called "Loan: xyz." Okay, after doing that I thought everything was fine and dandy. However, here is the problem: I pay my loan using my checking account. When an entry is made to pay my loan the category that I'm using is "Transfer: Loan: xyz." The problem is, how does the budget know that I have paid the loan when my checking entry is using the "Trans...