Import VBA

[hinser13]

I need to create an import button for the database that allows users to import data from another databse. The code needs to allow the user to select tables, forms, queries, etc etc etc.

I know there is an import tool in external data heading, but I dont want the end user to have access to design features. If I can create code that replicates the import access data feature in "external data" heading. that would be great , "but how" ?

 

[DCrake]

You walking on a very thin line here. Why are wanting to do this? Giving someone the facility to actually knacker your own front end is a critical error.


Suppose you did indead build an interface, which is possible, and they chose a table that existed in you mdb and they overwrote it, BANG! your whole system is down.

Addimittedly you must have a reason to want to do this but I cannot think of a justifiable reason to do so.

The same thing goes for forms, queries, etc. how can you be sure that what they are importing is legal and legitimate?

 

[hinser13]

i want to be able to create udates that allow end users to import the revised forms, queriere etc. Tables will not be updated! I want to be able to provide the upadets in an access database and the users can only import whats in the databse!

Thanks for your reply. I would welcome ideas ?

 

[DCrake]

You need to employ a protocol for updating users with ne versions of the front end. If you consider that really you should be deploying mde's or accde's which do not permit such imports, Therefore if a new version is available the user should be updating the whole front end in its entireity. There are some very good examples of this on the forum. You simply cannot rely on users importing the files exactly in the right order and the right objects every time. I would bet it would fall over on the very first deployment.

But if this is how you want to proceed how are you going to deploy the version that has this built in factility? Think about that.

 

[hinser13]

Thank you for your reply and good advice.

I shall look for the xamples you mention and explore providing updates in the manner you suggest. Thank you again

Mark

 

[dbDamo]

I use code that provides the user with a new front end every time they open the Database. Have a look at my posts in this thread:- http://www.access-programmers.co.uk/forums/showthread.php?t=184544

If you don't want to use this then wiklendt provided some excellent code in this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=184109