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. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|