Save / Save as - Access database to particular destination

[johnseito]

Save or save as - access db to a particular location.

It's probably a simple code but I couldn't find anything on it.

[ranman256]

filecopy currentdb.name, "c:\folder\newname.accdb"

[johnseito]

how about can it be save because I want to save what was updated from the database ?

[Micron]

You're wanting to save a copy of the db as a backup? Not very clear to me what you mean.
If so, I used a batch file run by another db and checked if no one was logged in. That info was in the user table. The reason for the second db was to use Task Scheduler and run the backups at night.

[johnseito]

I meant to save like how an VBA can save an excel workbook to the destination it open it from ?

[davegri]

While the database is open, click on the File icon at the upper left to get to the backstage. You can 'save as' from there.
As for doing this in VBA, offhand I would Google that, but I don't see the point. Access saves everything automatically anyway.

[johnseito]

I tried to google it but I couldn't find anything on it.
I created a program VBA, that upload data to Access and do things, and I just want to save what is uploaded after the program completes.

[Micron]

Access isn't like a Word document or any other similar object. When you enter, edit or delete data in Access, what saves the changes is you moving off of the record, or any action that causes a form to update, which includes invoking a mouse action to close the db. There is no need to save the records in the fashion that you seem to want to do. The only exception I can think of that might come into play is if you modify data and pull the plug on a computer that has no power interrupt fail safe. If we're still not understanding, it's because your responses are not very clear. Sorry.

If we are on the right track, surely you can perform a test on a copy of your db.

[johnseito]

I believe I understand what you are saying. Access can save table, query, module, report and macro objects but not the db. It can only backup the db. However if you updated the db, it can save the changes if you quit or close the db (access).

But how do you backup the db and how is a backup different than saving each of the mentioned objects separately or altogether ?

[Micron]

Access can save table, query, module, report and macro objects but not the db

Basically, that IS the db.

It can only backup the db

I think I and others are saying it can't back up itself.

However if you updated the db, it can save the changes if you quit or close the db (access).

Again, records would have already been saved before you quit or closed as previously described.

But how do you backup the db

Answer already given in #4. Use a batch file - .bat or command file (.cmd) Examples are easy to find. If you go to Windows Explorer (not Internet Explorer) and right click on a file and do a Save As, that's basically a backup, but a .bat file does it via code (sometimes it's just old DOS commands).

[johnseito]

Ok thank you !