Access to Access DB

[Guest]

I have an Access db currently in 2002 that could be upgraded to 2007 if
necessary. I have about 12 people who need to read, edit and create new
records in. Plus I need to be able to make design changes. My problem is that
those people are all individual with stand alone computers - pc's and macs
all of different ages and configuration - operating out of their homes. They
are also of various skill levels, some rank computer beginners. I am an
individual consultant without a server or much tech skill.

I am looking for a way to have them all be able to access it over the
internet. I know that I get into databases that I have at various clients
through citrix or gotomypc but I don't have a server or the knowledge to make
it happen. I am wondering if there is someone who can give me a heads up on a
way to post this to the internet, find place that they can citrix into,
whatever. I am open to all ideas. I don't have a lot of money to do this with
and it is for a non-profit. Currently I have the users working on replicas on
different flash drives but it is not working well. I have 5 new records on a
replica that won't replicate onto the master and the president of the
organization has a mac! I am looking for a long term solution and one that I
can use for other similar organizations.

 

[Guest]

Access would probably be fine as a backend database for your Internet
application (so long as your host will accept it), but you will need to have
an ASP/ASP.NET or other language frontend interface designed to work with it.
You can't use Access frontends on the Internet.

Are all these people working for you or the same company?

One solution may be to set it all up on one computer and each user can
remote into it using Remote Desktop and Terminal Services. It should probably
be a server and you may need to buy Terminal Services licences.

Steve

 

[Guest]

Steve, the group is a large quilt group, like a community group, so there is
no office. I don't know any web language to do the front end in although it
is looking like a may have to. Unfortunately, I work out of my 500 sq ft apt
in NYC which kind of limits my ability to have a server here. I would love to
find a server situation that people could remote into which would have Access
and Outlook on it.

 

[AnandaSim]

Steve, the group is a large quilt group, like a community group, so there is

My wife's into quilting. Any website?

no office. I don't know any web language to do the front end in although it

You have a bunch of constraints - different hardware platforms,
different skill levels etc.. etc... And budget. You have sever the
Gordian Knot otherwise you won't achive your objective.

Given so many constraints and the only thing they have in common is
the web and a web browser, your best choice is to implement a server
side scripted language and rent server space. The cheapest costs would
be php but ColdFusion is easier to start off on. You need to know HTML
of course.

is looking like a may have to. Unfortunately, I work out of my 500 sq ft apt
in NYC which kind of limits my ability to have a server here. I would love to

A "server" is no longer a monster machine. You can run a "server" off
your PC sometimes even without contaminating your PC - This is for
writing and developing and testing. Once you have got that done, you
can put the programming onto rented webspace.

find a server situation that people could remote into which would have Access
and Outlook on it.

Finding a hosted service for Office (Word, Access, Outlook) is not a
problem. There are heaps of those. The cost of service will be much
higher than writing your own webpages.

It's up to you, cost or work and skilling up.

HTH
Ananda

 

[Guest]

Northernstarquilters.com...and I am quiltingpro.com a software for
professional quilters or artists.

Thanks, this solidifies it more for me. ultimately, I am going to have to
learn how to get it web based but I may have to bite the bullet on expense in
the short term. I am also a softeware trainer in the middle of writing
manuals for 2007, not an easy task with all the changes.

Thanks to you and Steve.

 

[AnandaSim]

Northernstarquilters.com...and I am quiltingpro.com a software for
professional quilters or artists.

Thanks for those. You write QuiltingPro in Access?

Thanks, this solidifies it more for me. ultimately, I am going to have to
learn how to get it web based but I may have to bite the bullet on expense in
the short term. I am also a softeware trainer in the middle of writing
manuals for 2007, not an easy task with all the changes.

Yeah, I know. I magpie some stuff here:
http://office2007.wikispaces.com/

I posted a link to asp.net tutorials but they don't seem to show up
here.
http://www.asp.net/learn/data-access/

Kindest regards,

Ananda