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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Code to close and open a DB

Status
Not open for further replies.
AFKAFB

AFKAFB

Programmer
Aug 22, 2005
26
US
All
I've a form with four command buttons.
Selecting the first button allows the user to use the current DB.
However, clicking any of the other three buttons should close the current DB and open up a new DB, e.g. DB_2.mdb, DB_3.mdb etc...
Ideally the user should not notice the current DB has closed.
I cannot use the same DB as there are chinese walls issues and the data needs to be ring-fenced at all times.
Regards
Chris
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

ameedoo3000
  • Locked
  • Question
switch between two open database
Replies
12
Views
1K
Andrzejek
Andrzejek
ameedoo3000
  • Locked
  • Question
format partition by vba code
Replies
6
Views
759
mattKnight
mattKnight
TheresAlwaysAWay
  • Locked
  • Question
Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them? 4
2
Replies
22
Views
4K
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
3K
TheresAlwaysAWay
TheresAlwaysAWay
lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
3K
lmcate
lmcate

Part and Inventory Search

Sponsor

Back
Top