ADO Connection to a Different Access mdb

M

Michael Miller

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
 
M

Michael Miller

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.
 
M

Michael Miller

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.
 
M

Michael Miller

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.
 
Top