Separate forms & DB tables

[Guest]

Guys,

How do I separate the forms and database? I remember reading it somewhere
in the forum but do not remember what it is called and how to go about it.
The problem I've is that only one person can open my application at any given
time. The second user has read only access. I want to separate forms and
database so that multiple people can access the forms and update the tables.
What to do now? Do I need to redesign from scratch? Please advise a best
approach at this point.

Thank a lot.

 

[Brendan Reynolds]

In recent versions of Access, you will find the Database Splitter on the
Tools, Database Utilities menu. In earlier versions you may find it on the
Tools, Add-ins menu.

 

[Douglas J Steele]

Actually, it's more likely that your problem is caused by your users not
having the appropriate permissions on the folder where the database exists,
but splitting is always a good idea.

Tony Toews has information about splitting your application at
http://www.granite.ab.ca/access/splitapp/index.htm (or you could use the
built-in Splitter wizard)

As to permissions, each user needs to have Read, Write, eXecute and Delete
on the folder where the database exists. This is because the first user in
needs to be able to create a locking file (.LDB) in the same folder as the
..MDB file, subsequent users need to be able to update that locking file, and
the last user out needs to be able to delete the file.

 

[Guest]

Thanks Brendan for the quick response. Could you plz. explain how this DB
Splitter works. What is the logic behind it. There is an option (as you
mentioned it) and I used it. It basically duplicated the mdb file. I see
tables in both of them. Do I need to put both of them in the same folder on
the network?

PS

 

[Amy Blankenship]

Do the tables in one of the versions have a little green arrow next to them?
These are the linked tables. The forms should be on that side. The data
tables will be in the other mdb, and there won't be any forms there.

HTH;

Amy

 

[Guest]

Yes. There is an arrow next to the table and no forms on the other side
(..be.mdb). What about the data. Data exists on both sides? Can I delete
the data from tables where the Forms exits?

 

[Amy Blankenship]

Yes. There is an arrow next to the table and no forms on the other side
(..be.mdb). What about the data. Data exists on both sides? Can I
delete
the data from tables where the Forms exits?

Because the tables are LINKED this means that if you delete the data in the
"tables" on the front end side (the mdb without _be in the title), the data
will be deleted from the source tables in the other file. If that's the
result you want, by all means delete the data.

HTH;

Amy