sql server
6 TopicsUnable to insert records in Linked table from MS Access to SQL Server
Hi, I have created an MS Access project in 2007-2016 format. The OS is Windows 11. For POC purpose it is a simple form with ID as Autonumber and Name1 with short text fields. Now I am trying to link the MS Access to sql server table. For this I have selected ODBC driver 17 for sql server. First I exported table from ms access to sql server to create the table copy in sql server. Then added Primary Key in sql server table. Then I have right clicked table in MS Access and selected Linked Table Manager to select the table in sql server. On adding new record and save in ms access form, the table in ms access is adding new records but sql server is not. Earlier while exporting the data was exported successfully but after linking table new records are not getting added.Solved1.3KViews0likes5CommentsAccess Europe Meeting - Wed 1 Nov - Using SQL Server skills to extend Access
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on Sunday 29 Oct, whilst the USA remains on Daylight Savings until mid November. The start time for this meeting is equivalent to 19:00 (7PM) in Central Europe and (for this month only) 11AM in Seattle / PST Due to the clock changes, please carefully check World Time Buddy this month for all local times This session will be led by John Heaser who is an experienced Access developer based in the U.K. Topic outline: SQL Server has a Geography data type that can represent points, lines and polygons on the Earth’s surface. This data can be used to: • Find which polygons contain a point: e.g. find the Local Government Region for a location where you know the Latitude/Longitude (Lat/Long can be found from the PostCode) • Find the points that lie within a radius of a starting point and order them by distance: e.g. find the Stores that lie within 50 miles of a customer and show them in ascending order of distance This can be very useful for many purposes and SQL Server calculates the results very fast - provided that suitable Spatial Indexes are defined. Unfortunately Access can’t work directly with Geography data types! However, you can make use of Geography data in Access by using: • Persisted Computed Columns • Scalar Functions • Stored Procedures • Triggers We will look at how these SQL skills can be used to bring the benefits of Geography data types to Access. The same skills can also be used to leverage the power of SQL Server to do other tasks that would be slow to perform or difficult to code, if done directly in Access. For more details about this month's presenter and session content, see: https://accessusergroups.org/europe/event/access-europe-2023-11-01/ or https://isladogs.co.uk/aeu-21/ The meeting will again be held on Zoom. When the time comes, you can connect using: Join Zoom Meeting. If you are asked, use: Meeting ID: 924 3129 5683 ; Passcode: 661210 For more connection options, please see the AccessUserGroups.org web page for this event As always, the session will be recorded and the video uploaded to YouTube after the event478Views0likes1CommentODBC from Access to SQL Server database - query timeout expired
I am having issues connecting to a database located on a SQL Server 2022. When creating the connection all test gives OK. But when trying to connect, it fails with: ODBC--call failed "Query timeout expired" If I don't define the database, then Access connects to master db and lists the tables that I can access. So it seems the connection to the server itself is ok. Tried ODBC SQL server driver, SQL Server 17 and 18 odbc driver, all same results. Same database on SQL Server 2014 also does not work for my user, but another user has previously been able to connect to old database, but seems something is missing either client-side or server option in the new setup?16KViews0likes8CommentsAUG Access Pacific User Group Meeting: Migrating Access Tables to SQL Server, a Comparison of Method
Former Access MVPs Tom Wickerath and George Hepworth will discuss preparing for a migration from Access to SQL Server and demonstrate two tools for doing it. The Access Pacific AUG Monthly Chapter meeting is on April 6th, at 6:30PM Pacific (UTC -8) (Please verify your Time Zone offset for your local start time.) We'll discuss pre-migration preparations and planning, then take a closer look at two methods for migrating data from your Access tables to SQL Server. Scripting tables in VBA and exporting the data from Access to SQL Server -- Tom Wickerath. Using SSMA to create tables in SQL Server and migrate data from Access to those tables -- George Hepworth. In preparing for this presentation, George encountered a bug in the newest version of SSMA (9.3) and reported it. Within 24 hours the SSMA team responded. Within 72 hours they'd released the fix. That kind of response is notable and noteworthy. Don't you wish all of our bug reports could be resolved as efficiently? Bring your own questions and suggestions for the group. We like to round out a presentation with discussions about real world situations. If you have ever struggled with migrating data from Access to SQL Server, using SSMA or another approach, please join us. We'll try to explain what to look for, how to prepare for the migration, and how to use the tools.687Views0likes0Commentssql server migration
Hi Expert, I am doing migration of sql server 2012 from server A to server B. There is no connectivity between server A to server B. so will be doing backup and restore . we have availability group name called group1,group2group3. so while migrating, can we use the same availability group 'name' as it is to server B or it suppose to be different Regards Shree800Views0likes2CommentsI'll be in Iowa August 12, 13 and 14th at SQL PASS meetings talking about optimizing Access with SQL
For three nights August 12th, 13th and 14th 2019 I will be in three cities on three nights doing my popular "Optimizing Access with SQL Server": Access can be much faster with SQL Server, allowing many more users, improving stability and safeguarding your data over a regular Access database. In this session, Juan Soto, the only Access MVP in Illinois, will discuss how to avoid pitfalls with performance, the proper method to designing tables for Access and how to leverage stored procedures and views with pass-through queries. Monday August 12, 2019 - Iowa SQL Server Users Group 6 PM to 9 PM CDT Location: Helpful Smiles Technology (HST) 3801 South James Street Suite 400 Grimes, IA 50111 Click here to reserve your spot! Tuesday August 13, 2019 - I-380 PASS SQL Server Users Group 7 PM to 830 PM Location: 201 S Clinton St, 201 S Clinton St, Iowa City, IA, 52240 Click here to register for Tuesday! Wednesday August 14, 2019 QCPASS Chapter 5:30 PM Twin State Technical Services 3541 E Kimberly Road Davenport, IA 52807 Click here to register!654Views0likes0Comments