post database

[Guest]

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

Thank you.

 

[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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[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.

 

[Guest]

thank you all for your help! appreciate it!

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.

 

[Guest]

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)

 

[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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-