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

Open anotehr database and close current...

P: n/a
I have a need to set up a gateway database so to speak that will read
the network ID of the user who opened the database and then send them
on to a second database based on that user ID. I know how to fetch
the network id based on code from Dev and his OSUserName module. To
make the example simpler here is what I want to do....

User clicks on a button.
The database as location X:\foo\NetworkUserID\database.mdb is opened.
The current database is closed.

I thought I had the code set to do this but it isnt working. Either I
am having a brain fart, a reference is missing, my code is botched, or
who knows what. Can someone help me get back on course with this
please?

Aug 15 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Wed, 15 Aug 2007 11:49:54 -0700, DavidB <je***@yahoo.comwrote:

Perhaps this utility will help:
http://www.trigeminal.com/lang/1033/...asp?ItemID=8#8

-Tom.

>I have a need to set up a gateway database so to speak that will read
the network ID of the user who opened the database and then send them
on to a second database based on that user ID. I know how to fetch
the network id based on code from Dev and his OSUserName module. To
make the example simpler here is what I want to do....

User clicks on a button.
The database as location X:\foo\NetworkUserID\database.mdb is opened.
The current database is closed.

I thought I had the code set to do this but it isnt working. Either I
am having a brain fart, a reference is missing, my code is botched, or
who knows what. Can someone help me get back on course with this
please?
Aug 16 '07 #2

P: n/a
On Aug 15, 11:30 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Wed, 15 Aug 2007 11:49:54 -0700, DavidB <je...@yahoo.comwrote:

Perhaps this utility will help:http://www.trigeminal.com/lang/1033/...asp?ItemID=8#8

-Tom.
I have a need to set up a gateway database so to speak that will read
the network ID of the user who opened the database and then send them
on to a second database based on that user ID. I know how to fetch
the network id based on code from Dev and his OSUserName module. To
make the example simpler here is what I want to do....
User clicks on a button.
The database as location X:\foo\NetworkUserID\database.mdb is opened.
The current database is closed.
I thought I had the code set to do this but it isnt working. Either I
am having a brain fart, a reference is missing, my code is botched, or
who knows what. Can someone help me get back on course with this
please?- Hide quoted text -

- Show quoted text -
Cant this be done without an addin? Seems like a simple enough thing
to do...

Aug 16 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.