Search results

Hi All. I've run into a problem which I need helt to solve: Run-Time error '-2147217887 (80040e21) ODBC--call failed. Background: Using Access 2016 (FE), SQL Server 2012. (BE) Linked tables, and using 'dsnless' hardcoded connection, with SQL Authentication. The error message occur on table...

Hi again. I understand this forum are not ment for Sql, but I will just inform you, that the probles is beacause I have selected nchar instead of nvarchar in table spec. in sql expr. server. Thanks to google, I've found that nvar are fixed length, and therefore the space/blanks added. So I...

Hi guys. Thansk for your replies! When I start checking with the usage of breakepoints, I found that some of the String variables, where added several spaces/blanks. So, using the Trim(var) fixed this problem. Seondly, when testing - addeing a record to sql backend table using my frontend...

Hi all. I've got into a problem I just can't figure out how to fix.. I know it sounds stupid, but here is the case: I have just created a copy of my database backend to Sql Server Express. all tables and fields are created 'by the book' - i think.. and the front end linked to the sql database...

Well, maybe a little more specific question are in place; Sharpoint Lists - I believe those lists are powered directly by Sharepoints 'internal' SQL Server? But, when I study the Wed Database via Access 2010, it gives me reason to believe that the datafile is powered by ACE/Jet. As far as I...

Hi! I have found that my ordinary database with Access FE and a datafile BE placed on a server, doesn't cover our needs any more. Mainly network speed is the biggest problem. I have been givven full access to the company's Sharpoint (Server Enterprise 2010), but I am strugling to decide how to...

Hi Isskint. It may not supprise you, this works exactly the way I wanted! Thanks! Regards. Geirr

Hi. I have a form with multiple controls, mostly check boxes and text fields. The check boxes are named like chkbox1 to chkbox15 What I would like to do, is the posibility to access the checkboxes like this: Counter = 1 Do While Counter < 15 Me.chkbox + str(Counter) = False Counter =...

Hi all. Is there a way to create a report with folowing criteria: On each line in detail section I want to have info from one field, but from multiple records. Example, I have a group code, and I want a list on all items ID on this gropup. Instead of haveing one item ID for each line, I would...

Hi. I have a question I qould like to have some input on. The case is that I am not sure which structure of databases/tables suits me (and the organtisation) best. The scenario is: Our orgainisation are working on projects. Each projects will hold somwhere between 6000 to 8000 records. Each...