Search results

Hi all. I'm a very big fan of the JStreetAccessRelinker, and up to now have worked perfectly for my projects. But, I've seen that my org. needs to splitt the back end in two different databases, one database for common company recource info, and one database for each project. When using the...

Hi. First, please excuse my lousy english grammar... I'm moving my access app from std access data file (be) over to sql server. In the Access app, I am using 'direct access' to underlaying linked table - in the manner that form field datasource are directly to underlaying querry/table. In the...

Hi all. I've tried to read throug lots of docs on best practice on PK on tables, but.... Background: For electro company in shipbuilding I'created a backend with several tables, one accdb for each project. Many of exisisting keys in those table are same for each project - due to what they call...

Hi theDBguy and isladogs. First, thank you for your time. After a new walkthroug with the IT guys in our company, I've got acceptance to go back to using DSN and Linked Tables. This mostly when they understood my side of the case, dealing with around 20 different forms, and ca 35 queries...

As I wrote earlier, it's based on a existing solution using linked tables to an sql server. It's a prject I have built up over a time. I'm familar with setting up queries based on query designer, based on linked tables, releated or not. Based on some issues related to the company I'm working...

Hi isadogs. Thanks for your efford, but this issues are little new for me, and I'm really strugling on how I can 'transform' the value I need in the Sql for record source. Brgh. Geirr,

Thanks for the replies! I understand what you are saying, but I just don't know how to figure out how to solve this issue. If you look at the querry, this is a record source to a combo box. So what I did, was just go into the RSource, and changed the underlaying query (based on inked tables)...

Hi I've run into a case I hope I can get some directions / help on. Background: Moved a Back End to SQL Server. The server management gave me a user name and pw for access to the sql datafile, used when setting up a DNS to the server, using SQL Server driver. Now, for some reason I've been...

Thanks for your reply. I believe you understod the question because your solution with Me.txtResult =rsCable!SumAvMeter worked perfectly. I just got a totally block on this solution, so simpla as it is...:banghead: Thanks again. -Geirr

Hi. I'm little stuck here, and I hope I could get some input.. On a pushbutton click event, I have the following code: Private Sub cmdTest1_Click() Dim rsCable As ADODB.Recordset Set rsCable = New ADODB.Recordset rsCable.ActiveConnection = CurrentProject.Connection...

Hi. Thanks for your reply! I did'nt mean to be to general, but the problems is that I will deal with several projects. In each project I will have the same products (product ID) and location (location ID), but the combination of product and location will not be the same for each project. So, no...

Hi. I have a question which might seems little odd, but I hope I could get some guidance here...:) I have a main table, lets call it Project. I have some seondary tables, which have the realtion back to the Project table, with the Project ID as relation link. Then - under one of the...

Hi. Thank you Jleach for your time. The case is that I am using a 'dsnless' solution with the connection with sql server authetication hardcoded in the program. And I believed this would be ok when using standard recodset def and open, like: Dim rsTable As ADODB. Recordset Set rsTable = New...

Sorry for wasting your time. I forgot to inform the most important (maybe) that I am am usng ado all over the project. I'm little familiare with errorhandling, but I haven't use it on ado connection before. If you have version for ado, I would be glad, because i couldn't find a verison I could...

Hi there! Can: Item not found in this collection. .. be the answer you want? if not, please excuse my stupid question on where should I put the code - ?DAO.Errors(0) Geirr.

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...