By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 2,153 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

how to take input to our application

P: 30

i am developing access application

in that my application should take input database for every operation..

how to implement this

the method should be user friendly.....

i dont want to use inbuilt import database method of access

for ex:

i have access application . in that i have written queries and vba which extracts data needed from input database,.....

after extraction from input database(access table) data is calculted and reports are generated....

but for every operation input table is different . how can my application access external database table....

how should i implement this.
what technique i should use so that my application will be able to use different database table for every time.
how to design this proble .

gus please help me i am in urgent need
Aug 27 '12 #1
Share this Question
Share on Google+
6 Replies

Expert Mod 100+
P: 2,321
I can't make clear from your question whether your application just reads different tables in the SAME database, or different tables in different database files.

Is this A)
Read table1 from Database1
Read table2 from Database1
Read table3 from Database1
Read table4 from Database1

or is this B)
Read table1 from Database1
Read table1 from Database2
Read table1 from Database3
Read table1 from Database4

or C)

Read TableX from Database1
Read TableY from Database2
Read TableX from Database3
Aug 27 '12 #2

P: 30
third case that is c)

plese help me urgently
Aug 27 '12 #3

Expert Mod 100+
P: 2,321
Of course you just had to choose the most complicated one! :)

Do you in advance know the location of the database files as well as the table names?

Or does the user need to be able to select both files and tables "on the fly"? If so we are really approaching trying to build something that the access interface allready has (the import wizard)
Aug 27 '12 #4

P: 30
yes user know location and name...

please tell me
Aug 27 '12 #5

Expert Mod 100+
P: 2,321
I would use VBA to ask the user for the database path (Use a filedialog) and then promt them for the table name.

You can then (by vba) write a query and execute from VBA, or store the query as a QueryDef and then execute it.

The syntax would be something like:
Expand|Select|Wrap|Line Numbers
  1. SELECT * FROM [Table Name] IN 'C:\TestFolder\testDatabase.mdb' INTO [Temporary Table Name]
You could as said, parse the query string together using vba and then execute it. I can't really provide you with more details, because you information you have have provided is very vague and general.
Aug 27 '12 #6

Expert Mod 5K+
P: 5,331

TheSmileyCoder has provided you with a course of action that you can build on to solve the question asked.

Please make an attempt and post back your code.

Aug 27 '12 #7

Post your reply

Sign in to post your reply or Sign up for a free account.