Replace a query

[ChoonBoy]

How can I replace a query in another database.mde?

I have in C:/Test/database.mde

I want to replace a query "qSales" in database.mde from another mdb or mde.

I am thinking along this line

Click button - "qSales" is removed and new "qSales" is replaced.

Thanks in advance.

 

[bhicks11 via AccessMonster.com]

You can't in an mde - you have to do it in the mdb.

Bonnie
http://www.dataplus-svc.com

 

[Linq Adams via AccessMonster.com]

You cannot make design changes to mde files. To change this you have to have
access to the original mdb file.

 

[Linq Adams via AccessMonster.com]

Well, Bonnie, the motion's been made and seconded, shall we take a vote?

;0)>

 

[Dirk Goldgar]

How can I replace a query in another database.mde?

I have in C:/Test/database.mde

I want to replace a query "qSales" in database.mde from another mdb or
mde.

I am thinking along this line

Click button - "qSales" is removed and new "qSales" is replaced.

I have to differ with those who have posted saying you can't do this. While
you can't change the design of forms, reports, or modules in an MDE, you can
change tables and queries. Suppose you have a database you're running this
update from, and that database has a query "qSales" that you want to replace
the like-named query in "C:/Test/database.mde". This line of code will do
it:

DoCmd.TransferDatabase acExport, _
"Microsoft Access", "C:/Test/database.mde", _
acQuery, "qSales", "qSales"

 

[bhicks11 via AccessMonster.com]

Okay - I second the motion! Ha, we hit the button at precisely the same
moment.

Bon

 

[Dirk Goldgar]

Okay - I second the motion! Ha, we hit the button at precisely the same
moment.

Bon

Not so fast!

 

[Rick Brandt]

You cannot make design changes to mde files. To change this you have
to have access to the original mdb file.

Incorrect. Nothing about an MDE affects queries or tables. The existing
query could be changed or a new one imported to replace it or exported from
another file.

 

[ChoonBoy]

Thanks, I will test this out.

I have to differ with those who have posted saying you can't do this. While
you can't change the design of forms, reports, or modules in an MDE, you can
change tables and queries. Suppose you have a database you're running this
update from, and that database has a query "qSales" that you want to replace
the like-named query in "C:/Test/database.mde". This line of code will do
it:

DoCmd.TransferDatabase acExport, _
"Microsoft Access", "C:/Test/database.mde", _
acQuery, "qSales", "qSales"


--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[ChoonBoy]

It works very well

TQ

Thanks, I will test this out.

 

[bhicks11 via AccessMonster.com]

Interesting - where are you running that export from?

Bonnie

How can I replace a query in another database.mde?

[quoted text clipped - 6 lines]

Click button - "qSales" is removed and new "qSales" is replaced.

I have to differ with those who have posted saying you can't do this. While
you can't change the design of forms, reports, or modules in an MDE, you can
change tables and queries. Suppose you have a database you're running this
update from, and that database has a query "qSales" that you want to replace
the like-named query in "C:/Test/database.mde". This line of code will do
it:

DoCmd.TransferDatabase acExport, _
"Microsoft Access", "C:/Test/database.mde", _
acQuery, "qSales", "qSales"

 

[ChoonBoy]

From another DB.mde.

The objective is to replace a query with an updated query.

Can anyone please help me with the close database.mde codes before the
replace query code is run.

Thanks

Interesting - where are you running that export from?

Bonnie

How can I replace a query in another database.mde?

[quoted text clipped - 6 lines]

Click button - "qSales" is removed and new "qSales" is replaced.

I have to differ with those who have posted saying you can't do this. While
you can't change the design of forms, reports, or modules in an MDE, you can
change tables and queries. Suppose you have a database you're running this
update from, and that database has a query "qSales" that you want to replace
the like-named query in "C:/Test/database.mde". This line of code will do
it:

DoCmd.TransferDatabase acExport, _
"Microsoft Access", "C:/Test/database.mde", _
acQuery, "qSales", "qSales"

 

[bhicks11 via AccessMonster.com]

I guess that's why I'm puzzled. You can hit the tables but you can't modify
an mde.

Bonnie
http://www.dataplus-svc.com

From another DB.mde.

The objective is to replace a query with an updated query.

Can anyone please help me with the close database.mde codes before the
replace query code is run.

Thanks

Interesting - where are you running that export from?

[quoted text clipped - 16 lines]

 

[Dirk Goldgar]

I guess that's why I'm puzzled. You can hit the tables but you can't
modify
an mde.

Yes, you can. You can modify the design of tables and queries in an MDE.

 

[bhicks11 via AccessMonster.com]

Thanks Dirk - I'll go back to school. I thought you could get at the
database window or any design views.

Bonnie

 

[bhicks11 via AccessMonster.com]

I meant couldn't!

Thanks Dirk - I'll go back to school. I thought you could get at the
database window or any design views.

Bonnie