The new version of Access is a PIA. Where is the Save As option ? 1

[vbajock]

Access 2013, talk about screwing up a good thing, you just can't find anything. Same with Windows 8. I have a query open and I want to save it under another name so I don't wipe out my original query, and I can't find the stupid Save As button for the life of me. Anyone know where it is?

 

[kjv1611]

Here's a page that talks all about it. You have to scroll down the page a bit for it to get to 2013.

http://www.addintools.com/documents/access/where-is-mdb-save-as.html

But from what that guy shows, it looks like it's in the same location as 2010. Were you using Access 2010 before?



"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

 

[strongm]

Save Object As ... under the File menu

 

[vbajock]

Great idea, add more work to do something simple, and hide the entire screen to do it. Seems to be what Windows 8 is all about. This entire environment is going to be the new "Vista", I predict a short life for Windows 8.

 

[kjv1611]

So I'm guessing you're going from Access 2003 or prior to Access 2013?

Can you verify that, either way, vbajock? Which version of Access/Office are you coming from?


"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

 

[strongm]

Er ... kjv1611's solution is for saving a copy of your entire database. I thought you simply wanted to save a copy of an existing, open query. In which case, my solution would seem to be the correct one, and doesn't involve finding a 'hidden' page. This was also the case for Access 2010, and is nothing to do with Windows 8

 

[vbajock]

I program for all versions, I don't use the user interface much in what I do, on large corporate networks we really just want Access to program the user interface forms and reports for quick frontend apps where data and queries are all handled on SQL Server via Access VBA using ADO , when you are dealing with hundreds of clients, it could be anything from Access 97 on up, so you usually write the app using 2003 to create what objects you need with pointer-safe redirects in your code to handle 64 bit versions, and you get a product that will easily deploy to all versions. We generally use Access to do down and dirty apps where you need quick results, for anything industrial strength we use VSTO/Excel and VB.net.

 

[vbajock]

strongm, thanks that worked the best altho I hate this constant obscuring of the work area just to do something simple. Just too much "tablet think".

 

[kjv1611]

Yeah, it'd of helped if I noticed the whole part about the query.

Glad you found the solution, though.

As bad as the Ribbon felt at first, it is nowhere near as bad as the Win8 interface you're talking about (in my opinion, and apparently across the board, I'm not alone, based on the market).

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

 

[vbajock]

Repeat of Vista, on steroids.

 

[strongm]

Marketing driven design ...