With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.
Course Of The Month
5 days, 7 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Need to port access database app
Posted on 2014-12-17
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 :)
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 :)
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
4
3
2- +3
13 Comments
Active today
It's the middle of the night here and most people aren't awake. You will probably get some help tomorrow.
Active today
Can't speak to the interface, but as far as the data, you can keep it as a JET DB or move it to SQL using the SQL Server Migration Assistant (SSMA).
I think what you could add if this is a simple CRUD situation or if you have some business logic that needs to be ported as well. If the first, then I would think an example somewhere might be expanded. If the last, then things become a little more complicated.
and not sure what the situation is, but there's no real reason you can't keep it in Access, unless your tired of it for some reason.
Jim.
I think what you could add if this is a simple CRUD situation or if you have some business logic that needs to be ported as well. If the first, then I would think an example somewhere might be expanded. If the last, then things become a little more complicated.
and not sure what the situation is, but there's no real reason you can't keep it in Access, unless your tired of it for some reason.
Jim.
Active today
> looking for a simple way to give users on the network read/write/delete/edit access to this data.
Copy that database file from the old machine to a shared folder on the new server.
Grant users read/write/delete/edit rights on that folder.
Done.
/gustav
Copy that database file from the old machine to a shared folder on the new server.
Grant users read/write/delete/edit rights on that folder.
Done.
/gustav
Active today
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.
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.CrystalR
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.BadImageFormatExcep
I have installed crystal reports basic runtime for visual studio 2008 but still see this message.
Thanks
error.txt
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.CrystalR
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.BadImageFormatExcep
I have installed crystal reports basic runtime for visual studio 2008 but still see this message.
Thanks
error.txt
Active today
Are we talking about an Access application - forms/reports/modules/quer
Although Jet/ACE can be used as the BE to a website, if that is what you want, then SQL Server is a better choice.
If you are going to use Access as the FE to the data, what version are you planning on using?
Although Jet/ACE can be used as the BE to a website, if that is what you want, then SQL Server is a better choice.
If you are going to use Access as the FE to the data, what version are you planning on using?
Active 1 day ago
regarding the error you're getting, which version of CR did you install, 32 bit or 64 bit? You may want to uninstall/reinstall CR and make sure you're installing the right version.
not sure of your background, but if you're not much of a developer you may want to hire someone to bang this out for you, it seems like a pretty simple app to develop, and should be easy to do for someone with the experience. EE does have a "Hire Me" option as well.
not sure of your background, but if you're not much of a developer you may want to hire someone to bang this out for you, it seems like a pretty simple app to develop, and should be easy to do for someone with the experience. EE does have a "Hire Me" option as well.
Active today
<<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.
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.
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?
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?
Active today
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
You'll have to run the installer to get everything fixed.
/gustav
Active today
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.
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.
Featured Post
For Any Use & On Any Platform
Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| relocating SQL 2000 | 18 | 35 | |
| Word 2016 (32-Bit) - Hangs when attempting to select an existing list for Mailings | 13 | 30 | |
| SQL query joining 6 tables in asp.net | 4 | 30 | |
| Access VBA If Statements | 5 | 13 |
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s
ManageEngine
webinar, where attendees received a comprehensive look at the ma…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database.
Split up all multi-value fields into single values:
Split up fields that belong to other things into separate tables:
Make sure that all record…
Suggested Courses
Course of the Month5 days, 7 hours left to enroll
734 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.