Avatar of GazClimbs
GazClimbs

asked on 

Need to port access database app

Hi,
  I have this simple access database app on an old 32 bit XP machine which I am looking to retire. I have a new 2012 R2 server on this network and am looking for a simple way to give users on the network read/write/delete/edit access to this data.

The data consists of a single flat table, with a unique identifier for each record and 10 other fields. I am thinking to create an sql express db and access it with an asp or asp.net script, I thought I would find a free out of the box script on the web but no luck so far.

Could someone please point me toward an easy to implement solution, thanks :)
ASPMicrosoft SQL ServerMicrosoft Access

Avatar of undefined
Last Comment
GazClimbs
Avatar of GazClimbs
GazClimbs

ASKER

Any takers? Is there any more information I can add ?
SOLUTION
Avatar of Dave Baldwin
Dave Baldwin
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of PatHartman
PatHartman
Flag of United States of America image

SQL Server seems like overkill for this problem.  Depending on what version of Access created the .mdb, you may have to convert it to a newer version.  If you don't want to buy Access for everyone, you can distribute the Access runtime engine which is a free download from Microsoft but, you will need to create an interface for the app.  The runtime doesn't allow access to design level views so you will need to create a form the user can use to view/update the data.
Avatar of GazClimbs
GazClimbs

ASKER

Its a simple CRUD situation, I don't mind whether its access, sql, or read from a text file as long as users can access it over the network. At the moment it consists of aspx files, associated files and an access db running on IIS on a windows xp machine and accessed through the browser using a http://localhost/somefolder/somefile.aspx url.

I have attempted to port it as is, created a website in IIs on the new server, kept the file structure the same and when I attempt to browse the url I get the following error (full text in the attached file)

Server Error in '/' Application.

Could not load file or assembly 'CrystalDecisions.CrystalReports.Engine.DLL' or one of its dependencies.  is not a valid Win32 application. (Exception from HRESULT: 0x800700C1)
  Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

 Exception Details: System.BadImageFormatException: Could not load file or assembly 'CrystalDecisions.CrystalReports.Engine.DLL' or one of its dependencies.  is not a valid Win32 application. (Exception from HRESULT: 0x800700C1)

I have installed crystal reports basic runtime for visual studio 2008 but still see this message.

Thanks
error.txt
ASKER CERTIFIED SOLUTION
Avatar of PatHartman
PatHartman
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
Avatar of Big Monty
Big Monty
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
<<I have attempted to port it as is, created a website in IIs on the new server, kept the file structure the same and when I attempt to browse the url I get the following error (full text in the attached file)>>

 I would if you have all that already.   Just focus on the error, which is just with CR and sounds like it is not installed properly.

Jim.
Avatar of GazClimbs
GazClimbs

ASKER

Hi Jim and everyone
  Thanks for this, I have installed the 32 bit version of crystal reports basic runtime for visual studio 2008 and am still getting the same errors.

I simply copied all these files across, there is a bin folder with several .dll's and a storedprocedures folder with one .dll do I need to register these?
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

I'm very shure that this copy-paste method won't work. In the days of DOS perhaps, but not today.
You'll have to run the installer to get everything fixed.

/gustav
Totally agree with gustav,

  Copy and paste won't cut it for the majority of apps in today's times.  Besides the application directory, stuff can get dumped into Windows directories, then there are registry entires, etc.  There's no end to the stuff an installer might do in order to get an app in.

 Apps/components that will work with a simple copy and paste are very few and far between these days almost to the point of non-existent.

  You need the installer for CR or change the app so that it doesn't use it.

Jim.
Avatar of GazClimbs
GazClimbs

ASKER

Thanks for all your help, I have asked a colleague to look at this for me
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo