Recent content by joyful15

How do you set up user level security for your database?

Is there a way to track changes made by different users to access tables? For instance if several users update or change data in various records is there a way to track when and what was changed (before and after data)?

how do I do that?

But when I use the Text format it only shows the currency as a string of numbers - it isn't monetarily formatted. I would need it to look like $134,000 instead of 134000

I am importing a spreadsheet from Excel - the problem is that one of the columns in excel has a currency and text format (ex. $123,000 in B5 and 3M in B6). I know in Excel you can have both formats in one column since each cell can be formatted individually - how do I replicate this in Access?