Moving tables to Custom Folders (1 Viewer)

[sportsguy]

Is there any VBA which has been written to move tables into custom folders?

I have some VBA which deletes and reattaches tables which makes people saving the front end and back ends to their local drives from the network a single click. I use it when moving tables from front end dev to back end prod to relink the tables.

just curious, thanks in advance
sportsguy

 

[theDBguy]

Hi. Not sure I follow. Tables are created in database files. Database files are stored in folders. So, what exactly do you mean by moving tables into folders?

 

[The_Doc_Man]

Are you perhaps exporting and re-importing tables in some way? We need to know just a little bit more than you provided.

 

[sportsguy]

sorry, within Access, in the custom view, you can create categories, I called them folders. I want to move a table from unassigned to a category. Thanks!

sportsguy

 

[June7]

Bing: Access Navigation Pane custom groups

https://support.office.com/en-us/ar...ion-pane-ccfb0ee7-d72f-4923-b4fb-ed6c15484244

 

[sportsguy]

June7, um, I am asking if there is any VBA to move the tables to the custom groups. I know how to use the groups manually, which was the original question in the first post.

So, do you know how to move tables to groups with VBA?

Thanks!

sportsguy

 

[isladogs]

This involves writing to system tables. These links may help
https://social.msdn.microsoft.com/Forums/en-US/7bd1d1ca-7363-4e56-9421-c889ceb66f67/how-to-group-newly-imported-tables-using-vba-in-ms-access
https://stackoverflow.com/questions/12863959/access-custom-group

 

[June7]

I have never bothered with setting custom groups.

Why would users save backend to local drive?