Split Database Problem

[justair07]

Hello,



I'm attempting to create my first split database and I'm failing. Here is what I did in the exact steps.

1 - Created a database with one table and 11 forms (database is on my desktop).

2 - I created a split database and saved the back end on our company network.

3 - The front end is on my desktop(works fine)

4 - I put a copy of the front end on the company network (near the same location as the back end)

When I tried to open the front end from another persons computer who has access to the location i saved the back end and front end db's . It open fine, but my navigation form will not open the other forms. I get a blank sheet.

Any ideas?

Thank you,

[June7]

Did you change the table links for the different path?

The frontend should be installed on each user's workstation so each runs their own copy, like everyone has their own installed MS Office application.

Then everyone needs the same drive mapping that the table links are set for or set the links with UNC pathing. https://www.accessforums.net/access/...ing-32819.html

[justair07]

Okay that makes perfect sense! I just created a different issue though, I'm trying to move the backend to a different location via the Linked Table Manager and i keep getting this error:

[June7]

What do you mean by 'move the backend to a different location via the Linked Table Manager'? The LTM does not 'move' the db.

If multiple users are opening the same file, then only the first person to open it has design edit rights.

Here's how I manage a split db. http://forums.aspfree.com/microsoft-...ue-323364.html

[justair07]

Ok, I guess i took advice from the wrong forum on how to move a backend db. How do i change its location?

[June7]

Wherever the backend is, you need to set table links to it. That's what the TLM does. You copy the frontend and backend files to whatever folders you want them in then use TLM or VBA code to set the table links in the frontend.

[justair07]

I may have the wrong impression of how a split database works. Please correct me if i'm wrong.

When you split a database you create a frontend and backend database. You only need one backend (for the project manager) and multiply "copies" of the front end for each user to input data (via forms in my case). The backend still needs to be in a location on the server that each frontend can have a path to.

I accidentally put my backend in a bad location and now i can't move it.

[June7]

That is the idea. Set table links with UNC pathing and don't have to be concerned with drive mapping on each user computer.

How could file not be moved or copied to another location? You don't even have read rights to the folder location? Who does have rights to that folder and can move file for you? You don't have another copy somewhere?

[justair07]

I just relized how tired my brain must be. Please forgive my newbie misunderstanding. I just had to relink to the table once i moved the backend manually. I have the frontend on my desktop right now. Correct me if i'm wrong but all i should have to do now is make a copy of the frontend on all the computers that i want to have access to the project properties.

[June7]

That is correct IF:

1. the links are UNC path

or

2. also on each user's computer set identical drive mapping that is the path of the link

[justair07]

To automate the mapping, should that be done via VBA? So if I simply email the frontend to everyone and tell them to save it on their desktop the mapping will be correct. To avoid me going to 40 computers and manually linking it.

[June7]

UNC path linking should be done in the 'master' frontend before distribution. I do this with code. See the link referenced in post 4.

If you leave the linking with drive letter pathing, drive mapping would have to be manually set up on each user's computer and if for some reason the mapping was deleted, the frontend link would not work.

[justair07]

Perfect! thank you so much! I just tested it on several computers and it works great. Thanks for all the help. Now for the final touches of security settings. Do you have any good suggestions or links i can read up on? If you like I can ask this question in another post since it's a different topic.

[June7]

Search the forum. It is a common topic. I have responded to quite a few if you want to narrow the search with my member ID. Then if need more info, start a thread.

[justair07]

Awesome, thanks again!