A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Simplest way to put an Access 2007 database on the Web?



 
 
Thread Tools Display Modes
  #11  
Old December 21st, 2007, 03:16 AM posted to microsoft.public.access.tablesdbdesign
AccessVandal via AccessMonster.com
external usenet poster
 
Posts: 461
Default Simplest way to put an Access 2007 database on the Web?

I'd like to know in more detail what those limitations (of EW) are insofar as
database control(s), etc.


Refer to Sylvain post.

It is looking like Microsoft Visual Web Developer 2008 is what we may want.
The "Express Edition" is free, I'm told - I'm not sure if there is a fuller
edition, and what that includes that the Express Edition does not.


Not sure about a stand-alone version for this. MS seems to package it into
Visual Studio. So it seems that you’ll have to buy Visual Studio.

There is a free stand alone Microsoft Visual Web Developer 2008 at the
download page but you’ll also need to download the free version of SQL Server
2005 Express Edition, .NET 2.0 or 3.0, IIS, latest service packs for OS.

http://www.microsoft.com/express/download/default.aspx

Brett2007 wrote:

--
Please Rate the posting if helps you

Message posted via http://www.accessmonster.com

  #12  
Old December 21st, 2007, 05:51 PM posted to microsoft.public.access.tablesdbdesign
Brett2007 via AccessMonster.com
external usenet poster
 
Posts: 6
Default Simplest way to put an Access 2007 database on the Web?

I downloaded MS VWD 2008 and SQL Server 2005 Express along with NET 3.5.

Wonder how easy it is to 'copy' my access db to sql server format (more than
I'd planned on getting into for sure).

AccessVandal wrote:
I'd like to know in more detail what those limitations (of EW) are insofar as
database control(s), etc.


Refer to Sylvain post.

It is looking like Microsoft Visual Web Developer 2008 is what we may want.
The "Express Edition" is free, I'm told - I'm not sure if there is a fuller
edition, and what that includes that the Express Edition does not.


Not sure about a stand-alone version for this. MS seems to package it into
Visual Studio. So it seems that you’ll have to buy Visual Studio.

There is a free stand alone Microsoft Visual Web Developer 2008 at the
download page but you’ll also need to download the free version of SQL Server
2005 Express Edition, .NET 2.0 or 3.0, IIS, latest service packs for OS.

http://www.microsoft.com/express/download/default.aspx


--
Message posted via http://www.accessmonster.com

  #13  
Old December 21st, 2007, 08:44 PM posted to microsoft.public.access.tablesdbdesign
Sylvain Lafontaine
external usenet poster
 
Posts: 528
Default Simplest way to put an Access 2007 database on the Web?

You don't need to upsize your Access database to SQL-Server to start playing
with EW or Visual Studio 2005/8, as these two products can connect as easily
with a MDB database as with SQL-Server. For VWS 2008, I don't know but I
would be surprised if it can't connect to an Access database file.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Brett2007 via AccessMonster.com" u39983@uwe wrote in message
news:7d06be08f4ca2@uwe...
I downloaded MS VWD 2008 and SQL Server 2005 Express along with NET 3.5.

Wonder how easy it is to 'copy' my access db to sql server format (more
than
I'd planned on getting into for sure).

AccessVandal wrote:
I'd like to know in more detail what those limitations (of EW) are
insofar as
database control(s), etc.


Refer to Sylvain post.

It is looking like Microsoft Visual Web Developer 2008 is what we may
want.
The "Express Edition" is free, I'm told - I'm not sure if there is a
fuller
edition, and what that includes that the Express Edition does not.


Not sure about a stand-alone version for this. MS seems to package it into
Visual Studio. So it seems that you'll have to buy Visual Studio.

There is a free stand alone Microsoft Visual Web Developer 2008 at the
download page but you'll also need to download the free version of SQL
Server
2005 Express Edition, .NET 2.0 or 3.0, IIS, latest service packs for OS.

http://www.microsoft.com/express/download/default.aspx


--
Message posted via http://www.accessmonster.com



  #14  
Old December 21st, 2007, 11:48 PM posted to microsoft.public.access.tablesdbdesign
Brett2007 via AccessMonster.com
external usenet poster
 
Posts: 6
Default Simplest way to put an Access 2007 database on the Web?

Does Access 2007 database/file format have the power to handle a public
webiste (read only hits)?

Or, is upsizing to SQL server a necessity?

Sylvain Lafontaine wrote:
You don't need to upsize your Access database to SQL-Server to start playing
with EW or Visual Studio 2005/8, as these two products can connect as easily
with a MDB database as with SQL-Server. For VWS 2008, I don't know but I
would be surprised if it can't connect to an Access database file.

I downloaded MS VWD 2008 and SQL Server 2005 Express along with NET 3.5.

[quoted text clipped - 23 lines]

http://www.microsoft.com/express/download/default.aspx


--
Message posted via http://www.accessmonster.com

  #15  
Old December 22nd, 2007, 05:42 AM posted to microsoft.public.access.tablesdbdesign
Sylvain Lafontaine
external usenet poster
 
Posts: 528
Default Simplest way to put an Access 2007 database on the Web?

I don't know because it solely depends on the load of your website. Having
a few hundred hits par second or per minute will not have the same load as
having a few hits per hour or per day. There is also the size of the
backend database to take into account but as you are already with Jet, there
shouldn't be any problem on this side.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Brett2007 via AccessMonster.com" u39983@uwe wrote in message
news:7d09dd1d5c7a8@uwe...
Does Access 2007 database/file format have the power to handle a public
webiste (read only hits)?

Or, is upsizing to SQL server a necessity?

Sylvain Lafontaine wrote:
You don't need to upsize your Access database to SQL-Server to start
playing
with EW or Visual Studio 2005/8, as these two products can connect as
easily
with a MDB database as with SQL-Server. For VWS 2008, I don't know but I
would be surprised if it can't connect to an Access database file.

I downloaded MS VWD 2008 and SQL Server 2005 Express along with NET 3.5.

[quoted text clipped - 23 lines]

http://www.microsoft.com/express/download/default.aspx


--
Message posted via http://www.accessmonster.com



  #16  
Old December 22nd, 2007, 06:05 AM posted to microsoft.public.access.tablesdbdesign
Tom Lake
external usenet poster
 
Posts: 193
Default Simplest way to put an Access 2007 database on the Web?



"Brett2007" u39983@uwe wrote in message news:7cdc2791d6c87@uwe...

Is the SIMPLEST way for me to get Expression Web - and use the tools
within
that tool itself to create the web interface for my database?


I'd convert the mdb to a PHP file and use it that way.

http://dbconvert.com/convert-accessf...mysql.php?DB=1

Tom Lake

  #17  
Old December 22nd, 2007, 06:23 AM posted to microsoft.public.access.tablesdbdesign
Brett2007 via AccessMonster.com
external usenet poster
 
Posts: 6
Default Simplest way to put an Access 2007 database on the Web?

WOW, that is a nice progam/script, Tom!

Though we were hoping to stick with Access (to keep things simple), it may
well be SIMPLER to convert it to a mysql/php database driven platform. How
ironic - we originally got ACCESS 2007 thinking it would SIMPLIFY our work!

Tom Lake wrote:
Is the SIMPLEST way for me to get Expression Web - and use the tools
within
that tool itself to create the web interface for my database?


I'd convert the mdb to a PHP file and use it that way.

http://dbconvert.com/convert-accessf...mysql.php?DB=1

Tom Lake


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200712/1

  #18  
Old December 22nd, 2007, 02:33 PM posted to microsoft.public.access.tablesdbdesign
Rick Brandt
external usenet poster
 
Posts: 4,354
Default Simplest way to put an Access 2007 database on the Web?

Brett2007 via AccessMonster.com wrote:
WOW, that is a nice progam/script, Tom!


I was intrigued, but the first demo page gave me an endless stream of error
alerts that forced me to kill my browser with task manager.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


  #19  
Old December 24th, 2007, 03:15 AM posted to microsoft.public.access.tablesdbdesign
AccessVandal via AccessMonster.com
external usenet poster
 
Posts: 461
Default Simplest way to put an Access 2007 database on the Web?

I forgot to mention that you’d also need the SQL Server Management Studio
Express. You’ll need to to upsize the access database.

http://www.microsoft.com/downloads/d...displaylang=en


I do not have A2007. In older version, you upsize by connecting the SQL
Server by ODBC or file DSN. You must create this first after you install the
SQL Server.

From your access database.
1.Tools – Database Utilities – Upsizing Wizard
2.Create new database and give a name to the database
3.click next
4.“connect to your Data source”
5.Upsizing Wizard Box – select the tables to export to SQL Server.

Brett2007 wrote:
I downloaded MS VWD 2008 and SQL Server 2005 Express along with NET 3.5.

Wonder how easy it is to 'copy' my access db to sql server format (more than
I'd planned on getting into for sure).


--
Please Rate the posting if helps you

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200712/1

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:56 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.