Recent content by GeorgY

Why input on this, anyone?

I've created a program with VB that uses SQL to get and display data from the database onto a grid. Problem is that when the program is running, it is as if someone has opened Access and when the user tries to upload data from an Excel file to the database, the data simply does not get uploaded...

Ok, that works only if Access is physically open on my computer. I was hoping, that this would also log out any other users that may be logged into the database from another computer or application. Any way to do this? Thanks again..

Thanks, what exactly do I need to change in that code to make it work for me?

Can anyone tell me how I can run an Access sub from Excel VBA? The sub is: Sub CloseDB() DoCmd.Quit End Sub Thanks in advance

It really makes no difference to me, as long as it is all done by code. How would I go about doing that?

Hello, I have VBA code, which in Excel, formats a worksheet and exports it to Access. I use an OLEDB connection with the database to do this. My request is the following: before the formatted data can be exported to Access, I need some sort of code that will kick all users that may currently be...