Senin, 18 Juli 2011

[MS_AccessPros] Re: Web Based Database

 

Thanks for the feedback.

Now, what will I have to make diferently in a webbased database than I would in a database I currently make?

Will I have to learn to use SQL instead of ACCESS? What is the diference? A friend tells me SQL is better but I have not looked into it yet...

Jonathan Rivera
running MS ACCESS 2007
www.riveraservice.webs.com

--- In MS_Access_Professionals@yahoogroups.com, "patrickawood" <pwood57@...> wrote:
>
> Hi Jonathan,
>
> If you find a free web database host please let us all know about it!
>
> You can use SQL Azure or a hosted SQL Server back end. Access is not secure and my SQL Server hosting company does not even offer it any more.
>
> You can get a SQL Azure account for $9.99 a month plus data consumption charges, which in your case will probably be inexpensive. You can try SQL Azure free for a month at:
> http://msdn.microsoft.com/en-us/windowsazure/sqlazure/default.aspx
>
> See my Microsoft Access and SQL Azure Information Center for Developers at:
> http://gainingaccess.net/SQLAzure/AccessAndSQLAzureInfo.aspx
>
> If you want to use a hosted SQL Server back end I use Discount ASP.Net and the price is quite reasonable:
> http://www.discountasp.net/
>
> One main difference between the two is that you can create as many database users and roles as you want with SQL Azure. This allows you to grant permissions for users to have access to what they need and you can also deny users permissions to tables, views, and Stored Procedures they do not need. This way you will not have to worry as much about somebody getting people's names and email addresses and selling them to spammers.
>
> Best Wishes,
> Patrick Wood
> http://accesstips.wordpress.com
>
>
> --- In MS_Access_Professionals@yahoogroups.com, "jrv2110" <jrv2110@> wrote:
> >
> > Ok... I am not an expert in MS Access but I can defend myself on it. Thanks to you guys I have gotten much better. But now I need to learn to make web-based databases. I want to create a database where people I give the password too go in and input data from their group (13 groups located far from eachother). That data includes the basic information like phonenumbers and address to each speaker in the group. The database will also include diferent talk titles (many speakers can have the same talk and each speaker can have many talks). I want this database to be used not only for them to tell me what talks they have available, but also for them to make their local talks schedule and so that each other group can see those schedules and even print them. The schedule will be speakers picked out according to the talk that group wants to hear or according to the speaker they want to hear. I have a pretty good idea of how to make the database and I used a VISIO type freeware to make the layout of the tables and relationships. But now I am on hold untill I find out what is the best way to web base the database and if there is something specifica I have to do in the design... I would also like to know where could I put this database in a good and safe webhosting (free would be great).
> >
> > Any ideas or sugestions?
> >
> > Thanks everyone!
> >
> > Jonathan Rivera
> > running MS ACCESS 2007 (with developer extensions)
> > www.riveraservice.webs.com
> >
>

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar