Thread: MSAccess Problem
Hi to all... I am facing a small problem.. I created a database in MSAccess with 5 tables,1 form,1 query and report . I want my client to view the report only..not the entire database... What should i do.. He should not able to even view tables... Does anyone can help me.. Any help is appreciated... Thanking in advance smitha ********************************************************************* Disclaimer: The information in this e-mail and any attachments is confidential / privileged. It is intended solely for the addressee or addressees. If you are not the addressee indicated in this message, you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer does not consent to Internet email for messages of this kind. *********************************************************************
On Thu, 16 Oct 2003, Smitha V. Babu wrote:
> Hi to all...
> I am facing a small problem..
> I created a database in MSAccess with 5 tables,1 form,1 query and report .
> I want my client to view the report only..not the entire database...
> What should i do..
> He should not able to even view tables...
> Does anyone can help me..
> Any help is appreciated...
> Thanking in advance
> smitha
In Access write some Macros. One can be an autorun macro that
offers an option to view the report.
Password protect your Access Database so they can't circumbert
your front line interface.
You will need to find some other docs on Access.
This does work I've seen it done. I'm never touching it again.
What has this got to do with Postgres?
Peter Childs
I don't know if this will solve the problem, but what happens if you
create a new schema with only the tables you want your users to view and
grant access to that view to your access user.
Or an I completely wrong? Could be, 'cause I never tried it...
On Thu, 2003-10-16 at 13:35, Smitha V. Babu wrote:
> Hi to all...
> I am facing a small problem..
> I created a database in MSAccess with 5 tables,1 form,1 query and report .
> I want my client to view the report only..not the entire database...
> What should i do..
> He should not able to even view tables...
> Does anyone can help me..
> Any help is appreciated...
> Thanking in advance
> smitha
>
> *********************************************************************
> Disclaimer: The information in this e-mail and any attachments is
> confidential / privileged. It is intended solely for the addressee or
> addressees. If you are not the addressee indicated in this message, you may
> not copy or deliver this message to anyone. In such case, you should destroy
> this message and kindly notify the sender by reply email. Please advise
> immediately if you or your employer does not consent to Internet email for
> messages of this kind.
> *********************************************************************
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
Cheers!
Wim De Hul
------------------------------------------------------------------------------
IP SERVICES SPECIALIST
Belgacom Carrier and Wholesale Business Unit (CBU)
------------------------------------------------------------------------------
AS6774
Ripe : WDH25-RIPE
reply-to : NOC{at}belbone{dot}be
peering : peering{at}belbone{dot}be
NOC Tel : +32 2/547.51.00
www.belgacom.be/carrier
------------------------------------------------------------------------------
Nothing is foolproof. Fools are too ingenious.
------------------------------------------------------------------------------
1:47pm up 4:20, 1 user, load average: 1.36, 1.31, 1.28
--- "Smitha V. Babu" <smitha.v@sonata-software.com> wrote: > Hi to all... > I am facing a small problem.. > I created a database in MSAccess with 5 tables,1 > form,1 query and report . > I want my client to view the report only..not the > entire database... > What should i do.. > He should not able to even view tables... I've never done this, but... You could conceal the table & report definitions by creating them dynamically, i.e. by code which runs as required. I'm not sure whether it is possible to have bound forms/reports etc. for dynamically created tabledefs: you could use unbound forms etc, but then you would need to write code to handle the things that Access itself usually handles, e.g. populating data fields on forms, saving inserts/updates. Then you could conceal your code by distributing the app as a .mde file. The Developer Edition gives you more options, but I haven't used it. This is not a PostgreSQL issue, you need to look at your Access references. __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com