Stand Alone Database

[okiedragonlady2]

Been years since I started using Access and new application needs to be used
for a farmers market group - I built it but some of the potential users don't
own access - I remember it could be set up as a stand alone form with no
ability to change the DB but also not have to own Access to use it. Am I
correct and if so, explain the process or give me the process name so I can
look it up.

 

[Gina Whipp]

okiedragonlady2,

I would suggest using Access 2007 as it comes with a free runtime for all
those users that don't have Access. (You would, of course, have to purchase
Access 2007 to develop your database.) You should also make sure your
application is split...

Access 2007 Runtime...
http://www.microsoft.com/downloads/...d9-9dc6-4b38-9fa6-2c745a175aed&displaylang=en

Information on splitting your database...
http://www.members.shaw.ca/AlbertKallal/Articles/split/

http://allenbrowne.com/ser-01.html


You may also want to take a look at MVP Tom Wickerath's article...

http://www.accessmvp.com:80/TWickerath/articles/multiuser.htm


To handle the update of multiple front ends see...

http://www.autofeupdater.com/


--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message Been years since I started using Access and new application needs to be used
for a farmers market group - I built it but some of the potential users
don't
own access - I remember it could be set up as a stand alone form with no
ability to change the DB but also not have to own Access to use it. Am I
correct and if so, explain the process or give me the process name so I can
look it up.