Re: [MS_AccessPros] How to change a backend table from the frontend

 

Onno-

Sure.  Just Shell to another instance and pass it the name of a macro you've stored in the back end database that opens the table in Design view.

But why do you want to do this?

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Jul 14, 2015, at 12:16 PM, onno.knol@pbl.nl [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hi John, thanks, that confirms what I experienced in looking for a solution (and not finding it)

 

Another thought: could I open another instance of msaccess application  from vba and call the opentable procedure from that?  Do you have any details on how to accomplish that?

 

Thanks, onno

---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Onno-

You can manipulate the TableDef of a table in a "back end" database from code in the front end (by working in the TableDefs collection of the db object you set with OpenDatabase), but there's no way that I know of to open and directly edit the design of a table in a linked database from the front end.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Jul 14, 2015, at 11:28 AM, onno.knol@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hi I have split my Db and now I want to make changes to the table structure from the frontend.

 

I prefer to use the docmd.opentable myname , acdesign   procedure.

 

But how can I run this form the  frontend?  

 

I Can open the backend  by

 

 Set db = OpenDatabase(BeName)

 

but 

 

db.docmd.opentable   myname

 

does not work. What is the right way to do this?

 

 Thanks,

 

 Onno

 

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___