Need to install Access 2007 for an .adp conversion project.

[Paul H]

Does anyone know where I can get a copy full fledged of Access 2007? I was able to install the runtime version, but it did not have the utilities I needed.

Thanks in advance.



Paul Hammond

[Welshgasman]

No, but that is what I use, sparingly now I admit.
If I can help in any way, upload it, or work out a way to allow me access. No pun intended.

[Paul H]

If I can help in any way, upload it, or work out a way to allow me access. No pun intended.

No, .adp projects are wired to a SQL Server back end which you wouldn't be able to access.

Thanks anyway.

[Paul H]

I have found no sites where 2007 is available for download. Access 2010 will import forms and modules, but not the backend tables and queries. I am able to link to the SQL Server tables using a DSN file, I don't know how to find or use any queries in the SQL Server back end. I'm not sure there's an easy way around this. Our IT department wants to eliminate the use of Access 2010, but they have nothing in place to replace these apps. I haven't given up yet, but it doesn't look promising. I think our IT people are going to have to make an exception to this policy and keep these apps (21 of them) alive till they can develop new web based applications which could be a year or two down the line. I'm sure they won't be pleased.

Still accepting advice especially in regards to finding and linking to the queries in SQL Server.

[Gicu]

Hi Paul,

Not sure what you mean by "queries in the SQL Server back end". The SQL equivalent of Access queries are views and they should be visible along with the tables in the linking manager window.

Cheers,
Vlad

[Paul H]

Hmmm? I just discovered if I go into design view (which shows nothing) and switch to SQL view the transact SQL, but pasting that SQL into an .mdb or .accdb file does not work. None of the view names in SQL Server match up with the query names shown in the .adp file which are all in the dbo schema. SQL Server only shows one view in that schema. The trick here would be to convert that transact SQL into something Access would understand. With 60 queries in this one app alone and sixteen other .adp apps to convert this looks to be very labor intensive. Our IT department may have to extend the life of Access 2010 to keep them afloat till they can design a web based replacement. Their call.

[Gicu]

Hi Paul,

I still don't understand your problem (I don't have much experience working with adp projects), where exactly did you do that, in SSMS or in Access? Could it be that in Access the queries are actually pass-through and intended to run on the server?

Cheers,
Vlad

[Micron]

Does anyone know where I can get a copy full fledged of Access 2007? I was able to install the runtime version, but it did not have the utilities I needed.

Thanks in advance.

Paul Hammond

Quick search but what's wrong with the likes of something like this?
https://www.amazon.com/Microsoft-Off...s%2C226&sr=1-6

[Welshgasman]

I dare say cost? The 2013 is only $99 if all legit.
I would be happy to help, but it would rely on the O/P giving me access to their BE data, and he does not know me from Adam.

Paul H, what is it that you need to accomplish?
I *might* allow remote access to my 2007, under my supervision to use my 2007, if that helps at all?
I use AnyDesk to support my sister?

[Paul H]

[QUOTE=Micron;495603]Quick search but what's wrong with the likes of something like this?
Probably nothing if the powers that be want to pony up some cash. I'll keep it in mind.

[Paul H]

I dare say cost? The 2013 is only $99 if all legit.
I would be happy to help, but it would rely on the O/P giving me access to their BE data, and he does not know me from Adam.

Thanks for the offer, but I doubt our II Security would approve. There's lots of Personally Identifiable Health information.

[Paul H]

Hi Paul,

I still don't understand your problem (I don't have much experience working with adp projects), where exactly did you do that, in SSMS or in Access? Could it be that in Access the queries are actually pass-through and intended to run on the server?

Cheers,
Vlad

I don't have any experience with adp projects and almost none with pass through queries. I don't see them anywhere on the SQL Server Backend, but I can scrape off the Transact SQL in SQL Vies in Access.

[Welshgasman]

So, is there anyway you can change the BE to screened data? Moke 123 has a db on here to convert data to unrecognisable data.?
Up to you really, but I will help if I can.
I just look at it from your point of view.

[isladogs]

My understanding is that 2010 and 2007 have exactly the same level of support for ADP files. Deprecated in A2013

[Micron]

Granted, that is the whole Office suite rather than just Access. There might be offerings cheaper than that, but given the age of what you're looking for, I don't think I'd spend too much time looking. It's not like there's a ton of legit versions around. If the org is for profit, it seems strange to waffle about 300 bucks if it gets you want you want.