Search results

My point: This has worked thousands of times before I imported everything from the original database. What changes could have taken place with that import? Thank you.

I have an Access database that is linked to a SQL back-end. It runs slow. I checked some things you guys gave in a prior post. Now, I have created a new database and imported everything into it. I had to go through and add 4 References to match the old DB. Nothing else changed. It is updating...

Thank you.

I use normal VBA code. Most of the queries pull data from the SQL DB. I process it, then append new or update the old via a query. As you can tell, my knowledge of SQL is not at a high level.

I believe it is DSN. Also, as I said, I have no control over the SQL other than connect to it. I use to have a contact when I first set it up. He has since left.

I don't know. It is even hard for me to get a SQL support person. So, when I do, I have to have the right question. I do know that they usually close the database at the end of each day.

I work for a hospital support team and have created Access databases with a SQL back-end for our department. I have no control over the SQL. Here is my issue. Onsite, my database is average to good speed. The other users are much slower than mine. Using Cisco to connect from offsite, we get the...

I found this on a crosspost and it doe answer my question. I thought it would speed it up. If not, I will use what I have. "Switching a saved query to VBA will in no way speed it up." Thank you.

I have several queries like this. I made a change to the query to simplify it and came up with this. How would this work? Thank you. START OF CODE INSERT INTO tblDiagnosesHold ( Diagnosis, ICD9Code, ICD10Code, PatientID ) SELECT tblDimDiagnoses.Diagnosis, tblDimDiagnoses.ICD9Code...

Thank you

I am trying to convert the SQL behind an Access query and use it in a Docmd.RunSQL "" query. I have made several attempts and cannot figure it out. Can someone help me with this? I have two tables linked on the PatientID. START OF CODE INSERT INTO tblDiagnosesHold ( Diagnosis, PatientID )...

I was not able to use that. I need something simpler. Thank you.

I have a procedure that creates a file that is to be uploaded through a website. I use the following to open that web page. Application.FollowHyperlink "http://page1.ohio.gov/Pages/default.aspx" We are currently using IE as our default browser. This opens that page in IE. However, that site...

The one in the field is a stand-alone version. The main DB loads it up with data. They go out, meet with a client, collect information, return to the office, and upload it into the main.

I have a SQL backend. I have a database that the team takes with them out in the field. When I open the main database it reloads that database. Also, if they make certain changes to records in the main, it updates the field DB.

I have several linked tables in a database. They are linked to two other databases. I am sure you guys can answer this. Is it more efficient to use linked tables for queries or is it better to use the Append To Another Database? I am trying to speed up the queries. What do you think? Thank you.

There are only 3 users. Each has their own front-end and it resides on a shared drive as directed by the managers. I put front-end on my C drive and it does the same thing. I have compacted and repaired it and I use a module to turn off the subdatasheets.

There is no way. Access is frowned upon here and if they could get rid of it they would. Just recently they heard that Microsoft was getting rid of Access and it was sheer jubilation. I let them know about the SharePoint version that was being done away with and that the actual Microsoft Access...

The new IT group is attempting to move all Access DBs into one area on the shared drive. Since the process started several months ago, there has been a noticeable continuous slowing of one of my DBs. It is linked to a SQL Server. I have no permissions to do anything to the SQL Server. I have...

Yes., that is exactly what I want to do. Right now, I want to concentrate on the front-end development because the current Access DB is connected to SQL Server.