Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using more than 2 other MDB Files with same table names

Status
Not open for further replies.
shyamsundar

shyamsundar

Programmer
Aug 23, 2002
75
IN
Hi tech guys

I have developed any application, and distributed to 4 peoples, the table names and fiel names are same for all the MDB files, but MDB file names is different, and information entered into the tables are different

Now I have to present the data from various MDB files.

I want to create form,Queries,modules etc, in the new MDB by calling other MDB tables. The MDB files are selected by the user. I can't link the files because table names are same.

Any solution please.

It might be linking files at runtime after the user selected the MDB files and then removed the links once he exits from it.

Sorry I don't know I may be wrong

Please help me




Shyam
cwizshyam@yahoo.com
 
Status
Not open for further replies.

Similar threads

Zyborg
  • Locked
  • Question
Using a variable as reference to a form
Replies
5
Views
460
Zyborg
Zyborg
Dan Stoica
  • Locked
  • Question
Problems with Foxpro dsnless linked tables
Replies
0
Views
370
Dan Stoica
Dan Stoica
M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
3K
SoftwareRT
SoftwareRT
aldi07
  • Locked
  • Question
update a front-end database with a new release using vba
Replies
5
Views
312
aldi07
aldi07
Moss100
  • Locked
  • Question
Transfer data from external table to identical local table - urgent please
2
Replies
27
Views
771
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top