ADO Connection to a Different Access mdb

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a main Access 2000 application and about 3-4 times a month it gets
corrupted and I have to get everyone out and repair it.

Problem is knowing who is in. So, I created a separate log database and put
it on the server. I am starting code to take the NT Login Name and place it
in a new record in the log database, in a particular tablename, plus the
login date, time separate field.

I have the basics for a connection and an rst, but also need the Jet
provider, which I cannot find in help, and the correct syntax to point to the
log database, the table, and then I need to assign the fields
..fields("loginname"), etc.

Can you help with the jet syntax, pointing to the (non current) mdb, and
identifying the table?

Thanks.

mdm
 
But, the ultimate problem is that when the main mdb is corrupted, you cannot
get into it at all. I need to write it out to another mdb that is separate
and local.

Thanks.
 
Thanks. I'll check that out. I did have a previous routine that only
returned the machine name, which was pretty useless.

I still have to figure out how to write out that schema and data to the
different database.
 
Hi.

I did try it and it does work, but only returns the machine name and says my
login name is Admin. I need the NT login names, like MMILLER, type of thing.

In the meantime, I will try to matchup machine names with the users.

I also noticed, after I got into the code, that they did separate the source
mdb from the target mdb (even tho they were the same). I should be able to
target my local mdb ok.

We will also be switching to XP Pro workstations and server, in 3-5 months.

Thanks again and if you have a method to get the NT User login name, that'd
do it.
 
Back
Top