Recent content by DataChick

Is there a way for a SharePoint site admin to be able to see when the last time the members of the user groups logged in/accessed the SharePoint site? I have a SharePoint site with over 900 users in a group and I need to be able to see who is actively using the site content and who has not used...

I managed to figure out something that works for me so I can create the same pass through within the VBA code and not have to have a query that can be imported to another database with the password within the connection string: Dim wksp As DAO.Workspace Dim dabs As DAO.Database Dim...

I have an MS Access 2003 database front end that I am linking to a SQL Server 2008 backend. I need to assure that the users can log in through the ODBC DSN but NOT be able to access the password. I have 40 tables that are linked from SQL so what I was using was a PassThrough query that doesn't...

I have an MS Access database front end that is being used by over 50 users. I have one user who receives an error when attempting to run the "Set db = CurrentDb" code. He receives the error "Cannot Create Object" and when you click Debug it highlights "Set db = CurrentDB" in the VBA Code. He...

Thank you for your advice. I will try that when I am able to get access to the users PC and let you know what happens. "The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents."...

I have an MS Access database front end that is being used by over 50 users. I have one user who receives an error when attempting to run the "Set db = CurrentDb" code. He receives the error "Cannot Create Object" and when you click Debug it highlights "Set db = CurrentDB" in the VBA Code. He...

Thank you for all of the feedback. First off, we have lots of data that is managed through Oracle and we use Access a for reporting and analyzing the data stored in Oracle (so user licenses and ODBC connecting is not an issue). The fact that it needs to be installed on a server makes it a...

Maintain the backend data tables? Or are you saying the whole process...because that is not an option. We have attempted to have IT develop a system completely within Oracle and it failed miserably. The Access front end works great and everyone loves it - which is why it's now looking like we...

I am an MS Access developer working for a very large corporation. I have designed a database in Access to manage a process that has been thus far managed (poorly) in Excel and an eRoom. At the time that they gave me the specs on the project, they said it would have no more than 50 users -...

I have an MS Access database that I am using to send out notifications to distribution lists(generated from users linked to the MS Access record) through MS Outlook. The warnings and waiting that Outlook has is getting to be cumbersome for the users so I was attempting to use SharePoint to...

I need to be able to let users open a form that is linked to an Access 2003 database from within a Sharepoint site. All the info I can find only shows how to link it from Access 2007. Is this possible with 2003 or do we need to upgrade to 07? Thank you in advance for any help you can provide...

Never mind...I was able to figure it out. "The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents." -Nathaniel Borenstein

I am attempting to link tables in a MS Access database from a teradata database. The link table box shows up but there are no tables listed in the box (available for me to link). If another user links the tables (from their machine) then I can open the tables and access the data. Also, if...

Never mind, I was able to figure it out and fix it with a macro. Thank you anyhow. "The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents." -Nathaniel Borenstein

One of the users in my department had their Default File Location set to a share drive. The server was changed and now that share drive no longer exists so whenever he tries to change anything in the Tools > Options area, he gets an error saying it cannot access that directory and it won't...