How do I Share Database on Network?

W

WatermasterChris

How can I put an Access database on the network without other users being
able to change any information in my tables, etc? I mainly want to give them
access to the reports (labels, etc) in the database not the tables. Please
help! Any info and tutorials would be appreciated! THANK YOU!
 
A

aaron.kempf

this:

Access works best if it does not need to move a lot of information over

the LAN which means static data is best kept on the front end
databases.
Also kept on the front end machines will be most forms, reports queries
etc.
This will allow the whole system to work faster and in some cases allow
for
customization of some forms reports etc.


is crap

ACCESS MDB SUCKS ACROSS A NETWORK

use Access Data Projects and it woudl work quite well for larger
amounts of data without worrying about frontend this and backend that.

just a simple, single connection to SQL Server.

there is a free version of SQL Server 2000 that is called MSDE. the
license for this is included with every copy of Access.

I think that you should definitely give MDB a try; and when you're
tired of the BS then move it to ADP.
ADP is harder to write-- but much more powerful, reliable and scalable
 
Top