Recent content by leannemurphy

Hi everyone, has anyone done this before? I’m considering developing a few simple but useful excel /access apps that I’d like to stop people from sharing with others… has anyone attempted to do a type of licensing system that prevents/deters copying? Leanne

Hi everyone, I am able to export MS Office files to PDF via VBA, no problem. However, as Microsoft don't give an option to password protect the PDF using VBA I am now looking to the Acrobat VBA reference for this. I have Acrobat Pro on my PC, so have access to the Acrobat References...

Thanks @The_Doc_Man, but they aren't really relevant. I just want a digital signature for my databases.

Hi everyone, What digital certificates are people using? I know Access comes with a personal certificate where you self-cert... is this enough? I do Access databases for 1 client who trust me explicitly, so it's more to keep Microsoft happy when they open my databases. I am also starting to...

Thanks Minty. So if I were looping through an ADODB recordset and making changes to it, I could begin the transaction beforehand, make any changes, updatebatch and then Commit the transaction? Also, on a side note, every time I reply to someone and it quotes them I am told I can't submit my...

I often prefer to look through some records before I make decisions about what I want to do next. I was asking why the batchupdate doesn't work for me when I use it. Sounds like that's because I need to wrap the code in a transaction. I'm an Access VBA developer, not SQL Server. I've done...

Yes I know that.

Hi @Minty, Yes, if I can do an update query then I do one. But often I need information from the record in order to make a decision.

Hi guys, I read that you should be able to loop through a client side recordset making changes as needed and then at the end do a batchupdate to send all changes at once to the server... however, I've never been able to get this to work as batchupdate only seems to update the current record and...

Azure SQL Server?

Thanks CJ_London.... does this mean you're remoting into a physical PC at the office? Would it be their own pc at the office?

Wow, okay thanks Minty! Any idea how I can migrate my current database from Australia to the UK?? Regarding permissions for a user to access the Azure SQL Server - Can I not just get users to log in to the Access database with credentials that have been set up on the Azure SQL Server? And I'm...

Sorry to piggyback off this post, but has anyone tried to do a combination sharepoint and SQL Server solution? For example, for the lookup tables that feed your dropdown boxes could you use sharepoint to manage those lists, and then for the larger datasets that you may need to analyse, using...

Hi everyone, My name is Leanne. :) I am an Access developer and about 10 years ago set up one of my business databases to have a Sharepoint backend. It was surprisingly fast and effective, but I'm also aware that in 10 years lots of things change. I have also set up my current business...