Table Backup

[peshawa IT]

Hi every one i want backup my access file but i want just copy tables into another access file ,please help me.. thanks for all.

[NeoPa]

Use Export. It was in the File menu up to 2003.

[zmbd]

In ACC2010 it's in the external data ribbon tab under export, select the Access icon, dialog opens and then you can select an exsiting database file to export the tables to.

[peshawa IT]

Tank you I don't know this but I want use VBA code to create backup ,thank you for help

[pegicity]

Is there a specific reason it has to be VBA code? You can simply set up a macro to export the files for you, no VBA needed. Would you like more information on this?

[zmbd]

I would use the DoCmd.TransferD atabase Method (Access)Office 2010 method to export just a table or two.

[zmbd]

pegicity
Please be aware of the fact that this is mostly a VBA forum. Yes, it is an Access forum; thus, the macro language has some support here; however, not as much support as VBA.

BTW: The Macro action would be "ImportExportDa ta"
This Macro code is the exact same command as the VBA command I posted in #6, just hidden with a pretty dialog.

[NeoPa]

I would suggest that, while the forum covers any and all aspects of Access, we do tend to try to give out helpful advice where we can.

It is the belief of most people who have any experience with developing Access projects that introducing anyone to macros is not a very positive thing to do, and will almost certainly be something they come to regret in time.

Macros are so limited that anyone who does anything more than the very basics in Access will move beyond their scope to help in fairly short order. That leaves them with knowledge and experience they have picked up which is, frustratingly, all to soon clear will be useless to their continued development and any future projects.

That, and it leaves them with older projects they will probably feel they need to change to do properly.

This is why very few of us kind souls ever encourage anyone to start using macros. We know how unkind an act it will turn out to be.

[peshawa IT]

pegicity: I Would like more information on this side can you helpe me?

[zmbd]

YOu need no more information on the macro than what I gave you other than how to implement.

I wouldn't recommend using the macros for anything more than the basics or if you are going to publish to a sharepoint server.

I feel that I must point out once again, there is only limited support for the macro language within this forum as most of us have abandoned the macro language in favor of the VBA language. Even with the improvements in ACC2010 the macro language is very limited.

[peshawa IT]

thank for NeoPa and zmbd I have many tables I want create a button when kick as it create tables backup, I can create backup for all I main froms and tables.... but I want just table
sorry to late replay my internet disconnected :(

[peshawa IT]

My friend zmdb I don't like working with macro but if I don't have other way maybe use it , and I'm not good in macro know limit work ,but I want teach and have very information about VBA

[zmbd]

follow the link I gave you so that you have the context/syntax for the command.

Next, open the form in design mode, add a command button, in the events tab select the onclick event, select code, in the VBA-Editor that should open create your code. It's very simple to do. If you have any issues, post back here with your code please format it using the [CODE/] button in the toolbar and we'll take a look.
VBA is not that hard and you really should learn it.
(^_^)

>>EDIT>> BTW: These are the same steps one would go thru to add a Macro to a command button; However, the newer control wizard in ACC2010 defaults to Macro so it would be a tad more direct.

[peshawa IT]

Thanks my friend it is working with out any error ,but I don't want backup in is database self I want in another access file
look this DB I do what you send me Thanks

[NeoPa]

The link provided for you in post #6, which has also been flagged as Best Answer, includes details of the DatabaseName parameter. With this you can specify which database to export the table to.