Search results

As a security measure on a database, I'd like to setup a Macro or Stored Procedure such that when the database is opened, it sends an email to a gmail account. I'd store the logon and password in the macro or stored procedure. It would be helpful if it also contained a line of data from one of...

I have a Macro that runs several queries to update a table and wanted to run a Module within the Macro. I haven't figured out how to add that step. Can someone tell me how to run a Module within a Macro?

I created a database that I'd like to share with my colleagues. Currently, we use Dropbox for business to share files. If two people access the database, Dropbox will create a conflicted copy that we'd need to merge into the original copy, which is a pain. Anyone have possible solutions? Is...

I have several Access databases that are proprietary to me and I want to be able to track use and unauthorized use. Is there a way to setup the database such that, when it opens, it will ping me or invisibly send an email to track use, preferably with an IP address?

Does anyone know of a way so I can track use of a database that I created? I want to make sure it is not subsequently stolen by employees who leave or otherwise used without permission. I was first thinking there is a way to ping me or send a secret email whenever the database was opened. I also...

I have a database that I want to put on my firm's network. The database is proprietary to me and I want to secure it. I would like to make it such that 1) the database will only work from a set network location and cannot be copied onto someone's hard drive and 2) no one can modify or export...

I'm having an issue whereby when I highlight a tab on my form, it blacks out the tab name (see pic). My database was from converted Access 2003. So far, I haven't been able to figure out how to change the color. I tried changing color theme, but it didn't help. Any advice would be GREATLY...

I have a table that looks like this: I'm trying to get the net present value for each asset for the values in the last column. Any suggestions? Thanks in advance to those who reply.

I have an old database that required joining a workgroup, then entering a user ID and password to open. When I copied the database several years ago, I forgot to copy the 'mdw' file (i.e., the workgroup file). Now I can't open the database. I know the passwords. Is there a way to create a new...

I'm trying to set up a database to track a huge group of corporations. There is the parent company, then a bunch of subsidiaries below it. Some subsidiaries have another layer of multiple subsidiaries below it, some have none. Any thoughts as to how to do it???

I've got a Macro that runs well over 100 queries as well as sub-macros. I'd like to know what query the Macro is running. My best solution so far was to create a bunch of forms that open and close with the name of each query, but that's kind of sloppy. I don't think I can use the msgbox because...

I'm looking to get a new server and am looking for an optimal setup. We are currently on one with dual 1.8 GHz hyperthreaded processors. It seems slow and we can only get 25% usage in the task manager. I suspect that Access isn't capable of using hyperthreaded technology.

I've got a database that is about to blowup with Access' 2GB limit. Just wondering if I should wait for Access 12.

I've got Access Tables that have reached the 2GB limit and I want to do a SQL backend. I've exported my Access table to SQL and linked it up. However, it take 20 times longer to run a query that populates or updates data in SQL than in Access. Anyone have suggestions as to how I can improve this???