Error with Linked Tables

[khashid via AccessMonster.com]

Hi I have a main DB and Front End with forms that are linked to the main DB.
When i try to open the main DB from other computer using the front end file
it gives me error

The Microsoft Jet database engine cannot open the file
"file name with path". It is already opened exclusively by another
user, or you need permission to view its data.

But if i try to make my other computer as server it does not give me error
and everything works fine. I believe i need to make changes with windows
setting. Does anyone have idea?

 

[Douglas J. Steele]

Sounds as though you haven't set the permissions properly for the folder in
which the MDB file exists.

However, the preferred set up is for each user to have his/her own copy of
the front-end, preferably on their hard drive.

 

[khashid via AccessMonster.com]

Every User have their own copy on their hard drive. and I have compared the
setting with the other server for folder but still no go

Sounds as though you haven't set the permissions properly for the folder in
which the MDB file exists.

However, the preferred set up is for each user to have his/her own copy of
the front-end, preferably on their hard drive.

Hi I have a main DB and Front End with forms that are linked to the main
DB.

[quoted text clipped - 9 lines]

and everything works fine. I believe i need to make changes with windows
setting. Does anyone have idea?

 

[khashid via AccessMonster.com]

I found the issue, I had to create a new profile on server same as that is
available on Client.

Someone toild me I can create a string with User ID and password. Can someone
help me out?