mounty95
asked on
Access Front-End and Back-end and Network Connectivity
I have a user that has an Access database configured to have all of the forms, report, and dashboard in one database and the data tables residing in a separate database.
I can see when the initial dashboard database is open, the locking file is created for that file. When you go an open a form, you can see an additional locking file created for the backend database.
There is only one other person in the office that needs to be able to open that database and see the changes. I have tried copying the "front-end" database to the user's desktop and connecting to the "back-end" database on user 1's system? When I go into Linked Table manager to point to that file, I don't see that "back-end" file. I can see the front-end and back-end mdb files on user 1's system, but only the front-end database on user 2.
What am I missing here? How should I be setting this up?
Thank you for any help that you can provide.
I can see when the initial dashboard database is open, the locking file is created for that file. When you go an open a form, you can see an additional locking file created for the backend database.
There is only one other person in the office that needs to be able to open that database and see the changes. I have tried copying the "front-end" database to the user's desktop and connecting to the "back-end" database on user 1's system? When I go into Linked Table manager to point to that file, I don't see that "back-end" file. I can see the front-end and back-end mdb files on user 1's system, but only the front-end database on user 2.
What am I missing here? How should I be setting this up?
Thank you for any help that you can provide.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This worked as soon as I figured out how to split up the existing hard drive into an additional partition or drive. Worked perfectly!!!! Thank you Pat for the awesome explanation!!!!!!
on user 1's computer from an administrative command prompt
net share access= c:\<path>\foldername
the command is net share
access is the name of the shared folder
= simply equals
c:\<path>\foldername is the directory that the backend mbd resides.
now both computers can access \\computer1\access\filenam e.mdb
net share access= c:\<path>\foldername
the command is net share
access is the name of the shared folder
= simply equals
c:\<path>\foldername is the directory that the backend mbd resides.
now both computers can access \\computer1\access\filenam
ASKER
How do I handle this, if we don't have a server and simply these two desktop computers? I think I get how you are explaining this, but I am not sure about how I have a central place that they both are accessing.