Sharing access db

[karthikcoep]

I created an access database (.accdb).
I used the database splitter to split the database into front and backend.
I kept the backend in a shared folder in my computer which is a part of the company's windows network.
I linked the frontend with the backend tables.

The dasebase works fine on my comp.

I gave copies to another network user and gave him full rights to the network folder.

But he is not able to add records.
In my form I have used the command button which is a part of the wizard for adding new records.

i am getting the following error message.

"You cant go to the specified record"

What is the solution?????

 

[HiTechCoach]

is the folder for the back end added as a trusted location?

 

[karthikcoep]

i did that. Still no luck. Same message.

 

[HiTechCoach]

on the pc with issued, try opening a table and adding a record to see if it works.

 

[karthikcoep]

Nope I cant add any record.
The row where we add the next record is frozen.

 

[HiTechCoach]

To verify that the you have write permissions on the folder set properly, try this:

From the PC with issue, try creating a file in the folder with the back end. If it does not work, then you definitely have permission issues.

 

[karthikcoep]

i did.
I was able to create a file in the shared folder from my collegue's computer.

 

[HiTechCoach]

The folder permission sound correct.

I think it has to do with Access's security.

The next thing to try is to set the Macro security to "enable All"

In the Trust center, click on t he Advanced setting button. Click ont he Macros setting on the left side. Select the option to enable all.

 

[karthikcoep]

Did that too..
Still giving the same error.

 

[karthikcoep]

I m stuck after taking immense pains to develop the database,
Please some help.

 

[HiTechCoach]

I am willing to try testing it on my network.

If you would like me do do that, let me know. I will PM you my email address and you can send me the front end and back end. After you compact and repair the front end and back end and then ZIP them, how big are the ZIP file(s)?

 

[karthikcoep]

The FE is 1.37 mb and the backend is 1.37mb

 

[Kill_Switch]

I had a similar problem with our FE and BE on a networked connection.


Problem was, after 30 minutes of banging my on desk, was that when I saved the FE it compacted and repaired on close. I could create records on my computer, or any other computer I logged into, however once another person logged into their account, they could not even open the database. They would double click the icon where ther FE was, and would get the "Cannot find databse at file location N:\..\..\..\db.mdb. I check the security, the file permissions... all the normal.

So, being proactive as most of us are, I backed up the previous version before I did any changes.

I opened up the backed up DB, and copied/pasted the table and 2 forms I edited over, and re saved, all was fixed and working a-okay.

Hope this helps.

 

[karthikcoep]

Solved.
I created the db from start again.
Don't know what exactly the problem is/was.