Viewing 15 posts - 46 through 60 (of 274 total)
Apologies, I should have gone back and reread your original post before asking about versions. I should finish my morning joe before replying to posts!
Unfortunately the Upsizing Wizard was...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
October 19, 2016 at 10:57 am
J Livingston SQL (10/19/2016)
I think you have to set up the the RI in the SQL Server environment, not via your Access FE.....I may be wrong though
You are correct -...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
October 19, 2016 at 7:49 am
What tool did you use to migrate the Access back-end to SQL Server? Access has an upsizing wizard that in recent versions will preserve referential integrity. The second...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
October 18, 2016 at 3:35 pm
Since you have a ribbon, you have to be on Access 2007 or later. The first thing I would try is holding down the SHIFT key when starting the...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
October 5, 2016 at 9:46 am
Unless you are very proficient in VBA, in the object model for Microsoft Access, and you have more than 50 tables you need to reconnect, I would suggest you either...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
September 21, 2016 at 9:02 am
Is this a one-time task, or do you need to do it repeatedly? If it's a one-time task, you might just export it to Excel - a built in...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
April 14, 2016 at 11:10 am
I think some of the advice you received needs to be tempered a bit. I have routinely worked with multi-million row tables in ODBC linked SQL Server databases over...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
April 13, 2016 at 10:13 am
The short answer is no - the longer answer is you can do it by running a command prompt to start Access, do the export in code from an auto-run...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
April 13, 2016 at 10:04 am
I've not seen that behavior when using Access with linked SQL Server tables, but I am suspicious that your users may be doing repeated sorts of data in Access forms,...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
March 24, 2016 at 11:20 am
It appears you are using two subqueries in the expression, and Access does subqueries somewhat differently than ANSI SQL, which is closer to Oracle. Some versions of Access let...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
January 14, 2016 at 6:48 am
What is the extension of the Access database file? If it is .MDB or .ACCDB then it would be connecting using ODBC, and the PC where it currently resides...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
January 12, 2016 at 10:14 am
You don't mention what version of SQL Server you are using, or what data type the SQL Server table is defined as. But since using the Native Client 11...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
December 30, 2015 at 6:59 pm
Interesting idea - admin of users in multiple databases using SSMS can be a pain.
Haven't seen any differences in doing user admin between 2008 and 2012, but that doesn't mean...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
December 23, 2015 at 10:59 am
The issue of security in SQL Server is complex. It sounds as if you are using SQL Server Standard security, and in that case you do have to store...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
December 16, 2015 at 8:34 pm
The errors you are getting should have a numeric code on them. As long as you have some VBA code running you can use error-trapping to identify the error...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
December 15, 2015 at 2:38 pm
Viewing 15 posts - 46 through 60 (of 274 total)