Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Is anyone can help

0 views
Skip to first unread message

Anthony

unread,
Nov 7, 2006, 5:14:13 PM11/7/06
to
My problem is that on most of the databases that i created there is too many
talbes. i tried the compact/repair feature but that still disnt work. i
need to put the database onto other computers so other computers users will
have the information too.


Rick B

unread,
Nov 7, 2006, 5:23:09 PM11/7/06
to
Not sure what you are asking. There will be as many tables as you create
(plus a few system tables that are always there). Compacting and repairing
does not get rid of tables (thank goodness) it just organizes the data on
the disk a little better and gets rid of some wasted space.

You should have about six system tables plus any tables you created. If you
created tables that you no longer need, simply delete them.

As far as sharing the information with other users, this is most commonly
done by splitting your database into a front-end (with all the queries,
reports, and forms) and a back-end (with the tables containing your data).
The back-end is typically placed on a shared drive on your LAN and a copy of
the front-end is typically placed on each user's PC. The front-end
databases contain links to the data in the back-end. This allows all your
users to view, add, and modify data on one shared back-end database.

--
Rick B

"Anthony" <no_...@please.com> wrote in message
news:OVLmPorA...@TK2MSFTNGP04.phx.gbl...

Anthony

unread,
Nov 7, 2006, 5:32:23 PM11/7/06
to
thank you, Rick I will try this
"Rick B" <Anonymous> wrote in message
news:%23F5zNtr...@TK2MSFTNGP04.phx.gbl...
0 new messages