Stand alone Access 97 and or 2000 Form Help

[TonyU]

Hey fellas, Can someone help with this? I'm STUCK
I have created an Access form that I need to distribute to 3 people, but my problem is that these three people do not have access to update my database.
Since I will be saving the database to the server I just want to give them access to the form executable and not the actual database cool? cool.

Can someone guide me on how I could create this executable?. (or is this even possible? Thanks.




Tony

 

[Robbo1974]

Bit confused Tony, you only want them to be able to see the form, not the data?

Or do you mean that they''ll only be able to read the data - not edit or delete it? x-/ Robbo ;-)

 

[TonyU]

Thanks for responding Robbo1974,
I would like them to view and edit the data. BUT, they don't have access. Tony

 

[TonyU]

. Tony

 

[JoaoTL]

Hi, relative to the EXE see faq

http://www.tek-tips.com/faqs.cfm?spid=181&sfid=1074&CFID=31553026&CFTOKEN=47928433.

Relative to the Form, create a MDB only with that Form and link the necessary Tables in The Link Table Manager. Best Regards

---
JoaoTL
mail@jtl.co.pt
My MS Access Site:

http://www.jtl.co.pt