Access 2000 conversion and .mdw issues

RubberChicken

Board Regular
Joined
Jun 20, 2013
Messages
50
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.

I have also posted this question in Access-Programmers.co.uk but haven't had any responses.
Access 2000 conversion and .mdw issues - Access World Forums

Many thanks
Nik
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
The new versions of Access do not support that old-style level of security.

If you just need to get and record their usernames for transactions they make, you can capture their Windows usernames in VBA code as shown in this link: How to get logged-in user's name in Access vba? - Stack Overflow

I have used this methodology successfully before.
 
Upvote 0

Forum statistics

Threads
1,221,814
Messages
6,162,132
Members
451,743
Latest member
matt3388

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top