Moving an Access db [modified]
-
Jon is correct. You'll need to compile your main exe as 32bit. With Microsoft's release of SQl Server Express, I doubt they'll ever do any further major releases of the Jet engine. Access isn't all that bad however. I still use it for small database apps. It's certainly a whole lot easier to deploy!
The mind is like a parachute. It doesn’t work unless it’s open.
It's classic ASP not ASP.Net, so there's nothing to compile.
¡El diablo está en mis pantalones! ¡Mire, mire! SELECT * FROM User WHERE Clue > 0 0 rows returned Save an Orange - Use the VCF! Personal 3D projects Just Say No to Web 2 Point Blow
-
Within IIS. Assuming Win2k8 R2: * Start -> Administrative Tools -> IIS Manager * Click on Application Pools * Right-click on your app pool, select Advanced Settings * Change "Enable 32-bit applications" from False to True
Jon Sagara Some see the glass as half-empty, some see the glass as half-full. I see the glass as too big. -- George Carlin .NET Blog | Personal Blog | Articles
How wrong I was. This is such a PITA, I'm actually going to request that the server be "downgraded" to the 32bit version of the OS. It's just not worth the hassle.
¡El diablo está en mis pantalones! ¡Mire, mire! SELECT * FROM User WHERE Clue > 0 0 rows returned Save an Orange - Use the VCF! Personal 3D projects Just Say No to Web 2 Point Blow
-
How wrong I was. This is such a PITA, I'm actually going to request that the server be "downgraded" to the 32bit version of the OS. It's just not worth the hassle.
¡El diablo está en mis pantalones! ¡Mire, mire! SELECT * FROM User WHERE Clue > 0 0 rows returned Save an Orange - Use the VCF! Personal 3D projects Just Say No to Web 2 Point Blow
Just a shot in the dark, having never done this on Win2k3 myself. Have you tried these steps? * Running 32-bit Applications on 64-bit Windows (IIS 6.0)[^] * Configuring IIS to Run 32-bit Applications on 64-bit Windows (IIS 6.0)[^]
Jon Sagara Some see the glass as half-empty, some see the glass as half-full. I see the glass as too big. -- George Carlin .NET Blog | Personal Blog | Articles
-
Just a shot in the dark, having never done this on Win2k3 myself. Have you tried these steps? * Running 32-bit Applications on 64-bit Windows (IIS 6.0)[^] * Configuring IIS to Run 32-bit Applications on 64-bit Windows (IIS 6.0)[^]
Jon Sagara Some see the glass as half-empty, some see the glass as half-full. I see the glass as too big. -- George Carlin .NET Blog | Personal Blog | Articles
Yeah, I just tried them, that in turn generates a new set of errors, which, according to this: http://support.microsoft.com/kb/894435[^] apparently means I need to install the 32 bit version of .Net, despite the fact that I'm NOT using ASP.net, and ASP.Net is actually disabled (why turn it on, I'm not using, right?). This is just reaching the point of absurdity. We certainly have NO need of a 64 bit OS for this machine, and I have no doubt that even if I get this to work, something else will probably break.
¡El diablo está en mis pantalones! ¡Mire, mire! SELECT * FROM User WHERE Clue > 0 0 rows returned Save an Orange - Use the VCF! Personal 3D projects Just Say No to Web 2 Point Blow
-
We have a small IIS web server that has an ASP (yes, gasp, it's nasty) website that uses as it's data source an access database (please stop laughing). It's an old machine and I'm trying to transfer the whole site to a newer machine that we just got. For the new machine, do I need to install MS Office to be able to read/write to the access db? The old machine has Office 2000, but *not* the Access component of Office. So I'm wondering if I need to even bother installing Office, or if it's needed because of the ODBC drivers? //edit PS: Thanks to everyone for being so helpful on this!
¡El diablo está en mis pantalones! ¡Mire, mire! SELECT * FROM User WHERE Clue > 0 0 rows returned Save an Orange - Use the VCF! Personal 3D projects Just Say No to Web 2 Point Blow
modified on Friday, July 23, 2010 1:43 PM
Virtualize this machine... it will be easier... You are speaking of JET and ACCESS... :rolleyes:
[www.tamelectromecanica.com] Robots, CNC and PLC machines for grinding and polishing.
-
We have a small IIS web server that has an ASP (yes, gasp, it's nasty) website that uses as it's data source an access database (please stop laughing). It's an old machine and I'm trying to transfer the whole site to a newer machine that we just got. For the new machine, do I need to install MS Office to be able to read/write to the access db? The old machine has Office 2000, but *not* the Access component of Office. So I'm wondering if I need to even bother installing Office, or if it's needed because of the ODBC drivers? //edit PS: Thanks to everyone for being so helpful on this!
¡El diablo está en mis pantalones! ¡Mire, mire! SELECT * FROM User WHERE Clue > 0 0 rows returned Save an Orange - Use the VCF! Personal 3D projects Just Say No to Web 2 Point Blow
modified on Friday, July 23, 2010 1:43 PM
My first thought was a shovel and gloves.... As you got sensible answers elsewhere
Never underestimate the power of human stupidity RAH
-
We have a small IIS web server that has an ASP (yes, gasp, it's nasty) website that uses as it's data source an access database (please stop laughing). It's an old machine and I'm trying to transfer the whole site to a newer machine that we just got. For the new machine, do I need to install MS Office to be able to read/write to the access db? The old machine has Office 2000, but *not* the Access component of Office. So I'm wondering if I need to even bother installing Office, or if it's needed because of the ODBC drivers? //edit PS: Thanks to everyone for being so helpful on this!
¡El diablo está en mis pantalones! ¡Mire, mire! SELECT * FROM User WHERE Clue > 0 0 rows returned Save an Orange - Use the VCF! Personal 3D projects Just Say No to Web 2 Point Blow
modified on Friday, July 23, 2010 1:43 PM
I've been trying to migrate Access back-ended ASP systems since I started my current job 3 years ago. The Migration tool is all well and good, but I've found it easier to re-create them by hand, whilst simultaneously re-writing the front-end. Depends on how big the project is, obviously. As others have said, Access is evil. :mad:
You don't have to be mad to live here [UK], but it helps.
-
We have a small IIS web server that has an ASP (yes, gasp, it's nasty) website that uses as it's data source an access database (please stop laughing). It's an old machine and I'm trying to transfer the whole site to a newer machine that we just got. For the new machine, do I need to install MS Office to be able to read/write to the access db? The old machine has Office 2000, but *not* the Access component of Office. So I'm wondering if I need to even bother installing Office, or if it's needed because of the ODBC drivers? //edit PS: Thanks to everyone for being so helpful on this!
¡El diablo está en mis pantalones! ¡Mire, mire! SELECT * FROM User WHERE Clue > 0 0 rows returned Save an Orange - Use the VCF! Personal 3D projects Just Say No to Web 2 Point Blow
modified on Friday, July 23, 2010 1:43 PM
I think the SQL upgrade wizard thing should be helpful. If not, I wrote a tool called SchemaMaster that can copy the tables and data to MSSQL, MySQL, Excel, dBase, FoxPro, (PostGres and Oracle though not as well tested)... At the same time! LOL... I find Access isn't so evil - but for a web app - it's underpowered for sure. I think Access is actually pretty sweet... one of Microsoft's cool ones in my book. However, trying to upgrade all those forms and not always cooperative queries and things.. not to mention the vba code you might have is where things get dicey. I'd recommend Microsoft's SQL Server or MySQL as your next DB for that thing... MS SQL is the obvious choice if you're in a Microsoft "Shop" and IIS and ASP or .Net is the direction you need to go.
Know way too many languages... master of none!
-
My sympathy man. I did inherit similar web app. Decided to upgrade to SQL server. run migration tool, copied queries to SP and with little effort it was up and running. Access is simply evil. p.s. Got nothing to add to previous suggestions. I'd start right there and Good Luck
Yusuf May I help you?
Simpler is sometimes better. SQLExpress is a big slow cumbersome beast that requires additional runtimes and background services. ASP and an Access database can be used on any Windows machine with nothing more than PWS, IIS, or Babyweb Server. ASP Classic still has a huge following and has a (mostly) pretty logical syntax. I presonally quite like it. More powerful than Access, less hassle than ASP.NET. Just IMHO, if you only require your web app to read/write an Access database, then why not?
-
We have a small IIS web server that has an ASP (yes, gasp, it's nasty) website that uses as it's data source an access database (please stop laughing). It's an old machine and I'm trying to transfer the whole site to a newer machine that we just got. For the new machine, do I need to install MS Office to be able to read/write to the access db? The old machine has Office 2000, but *not* the Access component of Office. So I'm wondering if I need to even bother installing Office, or if it's needed because of the ODBC drivers? //edit PS: Thanks to everyone for being so helpful on this!
¡El diablo está en mis pantalones! ¡Mire, mire! SELECT * FROM User WHERE Clue > 0 0 rows returned Save an Orange - Use the VCF! Personal 3D projects Just Say No to Web 2 Point Blow
modified on Friday, July 23, 2010 1:43 PM
A main reason to install office with Access is you will eventually need to open the database and modify the tables. With Access you will also need to run the compression tool because Access databases don't self compress and can become quite large with lots of activity. With multiple users acessing the database the data can become corrupted at times and being able to open the database, use the compression tool, etc is essential. Make it easy on yourself and install Access!
-
We have a small IIS web server that has an ASP (yes, gasp, it's nasty) website that uses as it's data source an access database (please stop laughing). It's an old machine and I'm trying to transfer the whole site to a newer machine that we just got. For the new machine, do I need to install MS Office to be able to read/write to the access db? The old machine has Office 2000, but *not* the Access component of Office. So I'm wondering if I need to even bother installing Office, or if it's needed because of the ODBC drivers? //edit PS: Thanks to everyone for being so helpful on this!
¡El diablo está en mis pantalones! ¡Mire, mire! SELECT * FROM User WHERE Clue > 0 0 rows returned Save an Orange - Use the VCF! Personal 3D projects Just Say No to Web 2 Point Blow
modified on Friday, July 23, 2010 1:43 PM
please read this before you give up. http://support.microsoft.com/?id=309051
RS
-
We have a small IIS web server that has an ASP (yes, gasp, it's nasty) website that uses as it's data source an access database (please stop laughing). It's an old machine and I'm trying to transfer the whole site to a newer machine that we just got. For the new machine, do I need to install MS Office to be able to read/write to the access db? The old machine has Office 2000, but *not* the Access component of Office. So I'm wondering if I need to even bother installing Office, or if it's needed because of the ODBC drivers? //edit PS: Thanks to everyone for being so helpful on this!
¡El diablo está en mis pantalones! ¡Mire, mire! SELECT * FROM User WHERE Clue > 0 0 rows returned Save an Orange - Use the VCF! Personal 3D projects Just Say No to Web 2 Point Blow
modified on Friday, July 23, 2010 1:43 PM
or please read this if you are using iis7. http://blogs.iis.net/bills/archive/2007/05/21/tips-for-classic-asp-developers-on-iis7.aspx
RS
-
My sympathy man. I did inherit similar web app. Decided to upgrade to SQL server. run migration tool, copied queries to SP and with little effort it was up and running. Access is simply evil. p.s. Got nothing to add to previous suggestions. I'd start right there and Good Luck
Yusuf May I help you?
I agree with you...Access and web applications have never mixed well for me, we always seemed to have major issues with permissions (access has to create a lock file everytime it is opened) and corruption due to concurrent users. Any version of SQL Express (or even MSDE) would be a huge improvement. I would go for the 2008 and use mgmt. studio to upsize. Use OLEDB instead of ODBC for connecting...much faster. Most of the queries that work in Access, should work against SQL Server. Change your date delimiters and concatenation symbols and you've got most of the conversion done.