Solved

Reverse Access Run-time into an mdb file

Posted on 2011-09-13
14
408 Views
Last Modified: 2012-05-12
I have assumed responsibility for an old access 97 database. The users have run-time access the database via an exe file. I found a mdb file but it only has tables in it, no forms or reports. The run-time executable must be linked to this mdb because it has the current data tables in it.

I also found some frm and frx files that I assume are the vb code for the forms. It's in a directory called 'Source' that looks like it packages the system. Other folders under 'Source' directory have dll's, msi, etc.

Is there a way to rebuild the mdb file so I can better support the users on this system?
0
Comment
Question by:mph23
  • 5
  • 5
  • 2
  • +1
14 Comments
 
LVL 6

Expert Comment

by:JVWC
ID: 36534540
You could possibly build a new Front End in Access and link to the same data...
I see you have placed this in the Web Browser zones. are you looking for a web based solution or desktop?

Cheers
JC
0
 

Author Comment

by:mph23
ID: 36534871
oh oh - I didn't mean to put it in the web browser zone.

I don't want to rebuild the front end because they want it exactly like how it is.

thanks
0
 
LVL 6

Expert Comment

by:JVWC
ID: 36534946
OK, so what is it that you want to achieve?

Cheers
JC
0
 

Author Comment

by:mph23
ID: 36535004
Using the frm and other packaging files, can I rebuild the original mdb?
0
 
LVL 6

Expert Comment

by:JVWC
ID: 36535006
To expand on my question...
<Is there a way to rebuild the mdb file so I can better support the users on this system? >
and
<I don't want to rebuild the front end because they want it exactly like how it is.>
Really means that you do not want to change anything...?
Are you asking about moving the data to something like SQL?
Adding reports?

Cheers
JC
0
 
LVL 6

Accepted Solution

by:
JVWC earned 200 total points
ID: 36535029
OK,
It seems that the MDB is a standalone data store with a VB front end.
You could rebuild the mdb using ACCESS, but I am not sure why you would want to do this if the VB interface will not change.
It would be a simple conversion to a later version of access, but your users would not notice...

Perhaps a move to SQL server is what you are after?

Cheers
JC
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 84
ID: 36535047
If you have a version of VB that is compatible with the one used to build the original FE, then you could possibly rebuild it. A lot would depend on whether you have all the needed files, whether the program uses 3rd party controls/libraries - or even controls/libraries from Microsoft, whether you have the right drivers on your machines, etc etc ... so it would be difficult to say if you could be successful with this.

However, like JVWC, I don't see any problems that you'll have if you convert the database to a newer version, so long as you use the Access 2000 format (which was the default all the way up to Access 2003). If you move to the newer versions of Access, you would have to change references and code in your VB program, and for that you'd have to be able to rebuld that VB frontend.
0
 

Author Comment

by:mph23
ID: 36535119
Sorry, I guess I need to clarify.
I don't want to move to SQL server or any other database.

I was just wondering if I could somehow import the package files (frm, etc.) to rebuild the original access database front end. If I can do that, I can make changes the user may need in the future using Access design view.

Thanks
0
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 100 total points
ID: 36535183
The 'frm,etc' files are created by VisualBasic (v6 or earlier) - they are nothing to do with Access.
The mdb file is just being used as a data store.

So there is nothing to 'reverse' into Access.

You either use VisualBasic (a suitable old version)  to open the project or you have to develop a brand new front-end.
0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 200 total points
ID: 36535188
That's what we're telling you: Access doesn't store items in this manner for the Frontend items (like Forms, REports, etc). All Access items are stored in a single file (the .mdb file).

If you're dealing with .frm and .frx files, then almost certainly you're dealing with Visual Basic 4.0/5.0/6.0 or some subset thereof. In order to make changes to those items, you'd need a copy of that program. You cannot import a Visual Basic form into Access. They're incompatible platforms (at least as far as development is concerned).

Often you'll find a .vbp or .sln file in that directory. You can open that with Notepad (DO NOT make any changes to this file), and you can see what version of Visual Basic is being used, along with quite  bit of other information.

In most cases you can use Visual Basic 6.0, which can generally open/convert earlier versions.
0
 

Author Closing Comment

by:mph23
ID: 36535309
Ok, now I understand. Thanks all for clarifying that those files are generated/used by VB6 not when building Access run-time. I will look further into using VB6 to rebuild the front end.
0
 
LVL 6

Expert Comment

by:JVWC
ID: 36535380
FWIW:
You could easily rebuild the same (if not better) frontend in access, as you already have in VB.
It could be a better option than rebuilding the VB project...

Just a thought.

Cheers
JC
0
 

Author Comment

by:mph23
ID: 36535545
Thanks!
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now