Recent content by basshead22

Hello All, Few Questions!! I have a front end access database that has linked tables that reside in a SQL Server Database. I have about 300 + users using the database at any given time. I want to grant them access to the tables using an Active Directory group which they all reside in at...

Would you happen to know why i'm getting this error when i try to select the Microsoft DAO 3.6 Object Library reference as instructed in the link you posted about going DSN-less? "Name conflicts with exisiting module, project, or object library. I haven't selected any other references other...

Going to try it out now isladogs... but i have a few questions... Can i use the SQL Server migration assistant to upload and link my back end tables to the SQL Server? then use this code to distribute to others that use the front-end? Or is it best that i import and connect the tables manually...

Hi Tera, just curious what code are you using to do your DSN-less connection ? and does it work for you? I'm still having trouble getting it to work ....

I definitely don't want to do that! still trying to figure out how to go DSN-less.

Do you have any links to the other option as-well? File DSN on the server?

Hello All, I have a database that has been split with forms , queries , reports etc.. in the front end and just the tables in the back end file. I've decided to move the back end to SQL Server 2016. I used the SSMA tool to copy the tables to the SQL server and link the tables to my front-end...

TheDBGuy thanks a mil bro!!! It worked perfect!! ugh major oversite by me !!! Thanks!!

Hi guys i'm trying to establish a connection to my back end SQL Server using ADO ...but for some reason i am encountering some errors ... I get the compile error:syntax error and it hightlight the ADOConn.ConnectionString line.... i also get Compile error: Expected: end of statement when it gets...

Thank you CJ for your answer ! makes sense. I know this might sound stupid but could you give me a sample of what i should directly past into the module without the extra header stuff... like i mentioned im very new to programming in access. Much appreciated.

Hello All, I found this code online to be able to connect my front end to my back end SQL server tables... without having to create a DSN on each person's pc that is using my front-end. I just don't know where to put this code? in the start up form? in a module? Sorry i'm not to savy with...

That easy huh pbaldy!!!!!Thanks so much!!! exactly what i needed to do!!!

Hello All, It's been awhile since i wrote in here. Here is my scenario. I have a query that has several IIF statements based on the FTE count. I want the return result to be formatted as a number so when i do my total field it gives me back the correct number. Right now if i do a total based...

Thank you for the reply! so I changed the code to locked instead of enabled. Not sure what other contral name to use to set the focus... a control in my mainform or subform...? Also the code you wrote to suppress the error where does that go? Sorry if these are dumb questions I'm not...

hello all, I am trying to lock a sub form based on a checkbox on my mainform I was able to get it to lock but when I click on one of the cells of the subform after it's been locked I get error message 2185. Please see pic ! My code is as follows on my mainform (on current) event and I also put...