Database Splitter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please Help,

I wish to split a database but i dont know a whole lot
about the database splitter.
I want to share a database on a NT Netork but i only want
certain uers to see certain data.
If i split the database can i centrally make changes to
the front end or will this be individual to each users
machine?? as in if i wish to create a a query will the
query have to be set up on each of the 4 machines?
 
Please Help,

I wish to split a database but i dont know a whole lot
about the database splitter.
Click to expand...

Then, you'll have to spend some time to use it on a copy of your database,
to see what it does, no?
I want to share a database on a NT Netork but i only want
certain uers to see certain data.
Click to expand...

For that, you will need to use Access user-level security. Unfortunately, it
has a steep learning curve, & many traps for the unwary. Locate, download &
study the Access Security FAQ which is often mentioned in this newsgroup.

If i split the database can i centrally make changes to
the front end or will this be individual to each users
machine??
Click to expand...

No, each user should have their own copy of the front-end. That means,
multiple copies of the front-end. So if you make a change in the master copy
of the front end, you will need to replace all existing front ends with the
new version.
as in if i wish to create a a query will the
query have to be set up on each of the 4 machines?
Click to expand...

Queries would normally be in the front end, so the statement above applies.

HTH,
TC
 
Back
Top