Viewing 15 posts - 76 through 90 (of 274 total)
To resolve the issue if you have the constraint in Access, and then upsized it to SQL Server, you will have that some constraint in SQL Server, so you would...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
June 18, 2015 at 5:00 pm
You shouldn't have an issue with that as long as the SQL Server User has security permissions that allow the updating of the table. One way to test that...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
June 18, 2015 at 9:38 am
There are a couple of ways to exclude specific records from your query results. The most common is: Not Like "apples" and Not Like "oranges" and Not Like "pears"However...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
May 27, 2015 at 3:03 pm
That message usually means you have a lock file for that database that didn't get properly deleted when Access was closed. Check for a file in the same directory...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
May 26, 2015 at 7:17 am
OK - you still have two options - you can import Excel workbooks into SQL Server using that Import/Export capability, but the details vary depending on the version of SQL...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
May 8, 2015 at 2:08 pm
Where is your data coming from? In other words, is it data in Excel to begin with, or is it delimited text from some external system, or is it...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
May 8, 2015 at 10:05 am
That does seem unusually long for a table of that size. I've not seen that behavior, but we seldom run a process that deletes all the records in a...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
May 7, 2015 at 6:36 am
crowegreg (5/6/2015)
In closing, I've also tried append queries from Access, getting the same lengthy results. In simple terms, if Access is used to push or manipulate data to the SQL...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
May 6, 2015 at 2:57 pm
Since the database no longer exists, you have two options: 1) Restore it from a backup (are you backing things up? If not you should be), or 2)...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
May 6, 2015 at 2:37 pm
simsonmazar (4/25/2015)
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
April 25, 2015 at 2:16 pm
Unfortunately, it appears your best alternative is to go to a backup. That message is telling you that the system object where the VBA project as well as forms,...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
April 24, 2015 at 7:16 am
You will find that the WeekDay() function is your friend in this case. Do a search and you will find information on how to use it. Basically it...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
April 13, 2015 at 7:08 am
I believe you can import the objects from your Access97 database to a .mdb or .accdb format database in Access 2007 and have most things work. You would choose...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
April 8, 2015 at 8:27 am
Sorry to be so late - was travelling all of last week. Have you tried using an Indexed SQL Server view as the basis for your form, rather than...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
March 30, 2015 at 2:08 pm
In general the answer is no, although there is the ability to hide the VBA logic behind forms and reports by creating an ADE if the version of Access you...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
March 10, 2015 at 11:26 am
Viewing 15 posts - 76 through 90 (of 274 total)