Need to Split a DB for Multiple Users on Ntework drive

[noboffinme]

HI

I have a db built for several users & I have it on a Network drive but if I split it, the users get the forms flashing up for a moment & dissappearing.

As I need more than one user to enter data, I want to split the db, but need the db to work normally.

Has anyone else had this problem?

I'm saving the back end in the same directory as the front end , have tried to put the back end in a sub folder but same problem.

 

[boblarson]

The Frontend should be a COPY on EACH USER'S MACHINE. Not put on the network drive.

 

[boblarson]

You might want to read this article about Splitting to understand why.

 

[noboffinme]

Thanks boblarson Much better !!

 

[boblarson]

I'm glad that helped. Plus you'll be safer from a corruption standpoint. If one person's frontend goes down you just need to give them a new copy and everybody else can keep working like nothing happened.