Search results

I have it behind the form that functions as the main menu for my app, but it properly belongs in a class module, in my opinion.

We have a flash application that will open just fine. When I try to open it with a web browser control, it throws an error (below). I searched the forums but didn't find anything related to this, so apologies if this has been asked and answered. Error: an error has occured in the script on...

Problem solved. Deleted all the linked tables, re-linked them. Ran some VB code to remove the "dbo_" that Access prepends to linked SQL Server tables. All good now.

Environment: Access 2010 SQL Server 2008 R2 We are on a shared SQL Server and therefore must use SQL Server authentication (I know, worst practice). I changed the password on the SQL Server. I changed the connection string in the Access client to use the new password. I reconfigured the ODBC...

SELECTing counts is best done in SQL, and the resulting recordset used as the record source for a report. That SQl looks like this: SELECT COUNT(*) AS CasesProcessed, UserID FROM tablename WHERE DateColumn = some inputted date variable GROUP BY USERID Which will give: UserID...

tehNellie has this exactly right. I've done this, it is acomplishable if you have good hardware.

Is the slow query an Access query that SELECTS from a linked SQL Server view?

I believe ADP's are deprecated.

John, You can contact me directly at bparkinson@gmail.com if you wish. I'm happy to help however I can. Any of the great big Access books will have chapter on using Access as a FE to SQL Server. I'm also a big fan of William Vaughn, from whom I learned how to use VB6 against SQL Server in his...

Maybe I can start by just describing the steps I took? First, download SQL Server express. Find a company to host your SQL Server database. Price will vary depending on things like whether you are on a shared server or a dedicated server, number of databases you need, etc. I use DatabaseMart...

I think you might want to create a stratified histogram. Ken Henderson's excellent book describes how...

Since you have HIPAA rules to contend with, using access as your BE DB engine is a poor choice, IMO. for your 3-4 sites and 30 users, a hosted SQL Server database in the cloud with an Access front end will work fine. I'm doing that with my app with users on several continents and it's all...

you have linked tables then. Deleting the Access tables that were upsized to SQL Server is fine, and recommended.

If you have deleted the linked SQL Server table from the Access FE and your forms are still updating the SQL Server tables you must be using unbound forms with ADO recordsets, or be using stored procedures. Is something like this the case?

I learned something very useful. Thanks. Did you put the excel table out to a csv file, or is there a similar limitation there as well? How did you get around this limit?

I still don't understand why you are being forced into using worst practices. Not using stored procedures where you can is guaranteed to give you much poorer performance. You also forgo security advantages, code re-use opportunities, modularity, not to mention triggers. Is it the case that IT...

Sounds like the data are too big. You probably have data that exceed 8000 characters (or whatever SSIS decides is too big). I would try creating a destination table on SQL Server with a column of data type VarChar(MAX). It's wasteful, but it will hold 2GB. Try importing to that table and see...

When you migrate your data to SQL Server, your local Access queries would still work, as long as when you link the SQL Server tables, you rename them to the names the queries expect. However, in SQL Server, you have Views, which are like queries. In my app which is Access 2010 FE SQL Server...

Google Access DateDiff. It will return the number of months, days, etc. between two dates.

You could use TempVars, which are global, updateable, and destroyable. I use them to pass information between forms. You could have a form to select a farm, store that ID like this: TempVars.Add ("FarmID"), iFarmID Assuming iFarmID was set in the farm selection form. Now FarmID is available...