Access 2000 conversion and .mdw issues

[RubberChicken]

Hi all

I have inherited an Access 2000 database and now everyone in the office is on access 2013 I had to convert the old database to 2013.

Everything seems to be working as expected but I have an issue with people using it that are not assigned to the user-level security tables in the old 2000 database.

I need to know what to do about this (unfortunately) outdated security feature.
Ideally I still want to have people logging in as I need to record their actions against their usernames but I have no idea how to get round the issue.

I have done a few web searches and I am going round in circles trying to figure it out.

I'd be very grateful of any advice you guys and gals can offer.

Many thanks
Nik

 

[RubberChicken]

Update: 40 views and no responses. I'm guessing that Access 2000 is probably a bit old for a support question.
I have now asked this question in Mr Excel's Access section.

If anyone can point me in the correct direction I'd really appreciate it.

Cheers
Nik

 

[Minty]

I have no experience of the older security tables, but you can get their domain login name from vba using

Dim sUserName as String

sUserName = CreateObject("wscript.network").username

You can then use this to fill in a login table and probably look up their employee ID / name based on that?

 

[RubberChicken]

Thanks, Minty.
That will help when I get passed the ULS issue.
Much appreciated
Nik

 

[gemma-the-husky]

you no longer have the [cumbersome] old style features to manage user access to queries, forms etc.

if you want the later access version, and need to distinguish between users you just have to write your own user management functions.

 

[RubberChicken]

Thanks, Dave.
That should be fun