post database

M

mary_janeii

I want to make my database available over our network at work, but just a
viewable version. How do I do that?

Thank you.
 
R

RobFMS

If you are asking for users to see the data but not make any
modifications....
(this is off the top of my head)

1. Create the database as an .MDE (see Tools->Database Utilities)

2. For your forms, set the AllowEdits, AllowAdds, and AllowDeletions
property to FALSE.

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
G

Guest

if you do make a .MDE, be sure that you have a copy of the
original database. once you convert to a .MDE, you cannot
go back. Warning waring waring.
 
M

mary_janeii

ok, tried, works great, but, i just want them to be able to view a window
where they can browse for the information, not the whole database....
possible? (I have ACCESS 2000)
 
R

RobFMS

Create a query and make it read-only. This way they cannot perform any
edits.

Here's the syntax you can use:

docmd.OpenQuery QueryName:="QueryName", view:=acViewNormal,
DataMode:=acReadOnly

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Top