When to split database?

[Jakboi]

Hello,

Should splitting only be done when all tables,queries,forms,reports, etc. are done. Or can it be done anytime. I am almost to that stage but didnt want to jump the gun and run into problems later on.

Thanks.

I will have about 20 users sharing this.

 

[pbaldy]

You wouldn't run into any problems doing it earlier, but it's probably easiest to split after you've finalized the table design. That way you don't have to refresh the links when you change something in the tables.

 

[Jakboi]

Thank you.

From what I read here this is the standard for doing this correct:


-Put FE & BE in same folder on shared network drive.
-Put workgroup file in the same folder as well.
-User copies FE to their desktop.


I have split it to see what happens and need to read more about it. So far on a test run, another person got the following:


-Unable to move or copy/paste the FE from the shared folder to their desktop.
-Cant find database file.


I will have seach some more, but will take any tips.

Thanks.

 

[pbaldy]

I don't use Access security, but that looks about right. The error smells like a permissions problem, so check the sharing and security on the server.

 

[gemma-the-husky]

there are a few catches with splitting databases - some commands work on local tables but not on connected tables, for example the seek and index methods in dao recordset navigation.

For this and similar reasons I would tend to split earlier rather than later, to ensure the integrity of the solution.

 

[Bat17]

-Unable to move or copy/paste the FE from the shared folder to their desktop.
-Cant find database file.

that sounds like you are using code to copy the files, need to know more details to have any idea what the problem is.

 

[Jakboi]

Ok I think I resolved my earlier issues.

Now this is what I have:

Another person that has the FE can open the database without using a password, but when I try to open on my workstation...it wants the logon information.

Anyone know why it is not prompting the other user to login but yet it prompts me?

Thanks.

**I noticed as well, Outlook doesnt like sending db's as attachments...so the best way to send to each user is as a zip file, right?