Allowing people w/o Access to use DB

[clickster]

I've heard that there is a way to make an executable so that people without Access can still use the forms you create to access your Acess DB. Does anyone know if this is possible? I would use Data Access Pages, but they aren't nearly versatile enough.

 

[Bastien]

You can create a runtime version of the Db which would allow users to get the forms and reports. This can be placed in the network and accessed by all the users, note ou may need to create a workgroup to limit access. Any book on developing applications with Access can give you info on how to do this...

hth
Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[clickster]

Another stupid question...
Can multiple users access this at the same time?

 

[vavroom]

To be able to distribute DB's with the runtime version of Access, you must own the Developer's version of Access (well, actually, Office). You can download the runtime version from Microsoft, but... If you don't own Developer, you don't have the right to distribute it.

If you play with the runtime version, make sure your error trapping is bomb proof, otherwise the users are likely to be stuck to infinity.

If you place the whole thing on a server, runtime and all, you can access with several users at the same time, I think... You can install the runtime version of access on each terminal and have the DB on the server too. The runtime version of Access works just like the full version of access, except that you don't have all the options. It's more like... you got the "engine" of the car, four wheels and a steering wheel, but nothing else

HTH Nic
"You must deal with me as I think of myself" J. Hockenberry

 

[ray00]

Could you create a run time version and if yes, how did you do it?

Thanks in anticipation,