File sharing

[eacollie]

Not sure if this is the correct forum but...

I have two BE files that sit on a file server in two separate folders. I have two FE apps using these BE files. Each of these FE apps links to a table of customers in one BE file.
When user #1 opens a form using FE app #1 with record source set to this customer table and user #2 opens a form in FE app #2 which queries from this customer table and then tries to preview a report she gets a message: "could not use (file name); file already in use."

Both users have read/write/execute/modify permissions in both folders.

Can anyone shed some light on what is happening here???

thanks so much

 

[CJ_London]

Have you checked the open mode and default record settings for the BE?

This link explains more

http://office.microsoft.com/en-gb/a...a-shared-access-database-mdb-HP005188297.aspx

 

[eacollie]

Thanks CJ.

The BE has default settings...opens with sharing, etc.