Build data external datalink based on user

M

Mr. Smith

Hi.

Is it possible to build data links "on-the-fly" based on the user that
starts my Access application? Based on user, the application should connect
to different external data sources. In fact, the data might be stored in the
same data source (SQL server), but the user should just connect to data
concerning the users agency.



In short I have a transaction database with one transaction table tbltrans
holding some 10 million records split between 15 clients. When user A starts
the Access application, the Access application should only "work" against
the transaction concerning client an in tbltrans. When user B starts the
Access application, only transactions concerning client B in tbltrans etc.



What are the most "smooth" approaches to achieve dynamic data binding in
this setup? The overall target is to only have one application file, serving
up to 15 different clients.



Kind regards



Mr. Smith
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please help me choose a product for the task 2
Automation of scanned file storage based on content 0
Build form dynamically based on user 3
How to limit the shapes and external data sources ? 1
Code to link external tables 1
Auto Import via Ftp get and run load script/macro 0
data.mdb on external web server 1
Automating Get External Data >> Import 1

Top