Recent content by Freshman

Thanks - I will add it to the notes :)

Thanks - will ask him about his backend as well. Not sure. They are a 3rd party who is supposed to work with us but keep thing close to their chest while still not delivering. Yes I know :)

Thanks - yes I can do it with a function but it's not me that needs it this time. I need to give the SQL to another developer not using Access. I'm waiting to hear that language he is using but thought if I could give him something in pure SQL it would be eaier for him. Anyway - will wait for...

Hi all, I need some help with the following please: I have 2 related tables (on Field1) and I want a query to display the "concatenated" data without using a VBA function. Thanks a lot!

Thanks - I'm wating to for the support session on zoom later today so will discuss this with them then as well

Thanks I have tried that and various other name options but none seems to work. I've managed to book a service call with Actian to assist me tomorrow. Thanks everyone for their input. I hope to get a soltution tomorrow!

Pervasive PSQL is SQL type database previously known as Btrieve. The Software company is actian.com See installed Driver below in the ODBC

Thanks but Pervasive does not appear there. I can connect without a problem but only if I setup the DSN in the ODBC first. They I don't even have to spesify the driver. My goal however is to create a DSN from scratch so that I don't have to first set them up at each User since there will be lots...

This is what I tried again getting either error 6 or 11 - Google did not help me find that those error code mean?? ''Driver = "HFSQL" ''Working ''Driver = "Pervasive ODBC Engine Interface" ''Driver = "{Pervasive ODBC Engine Interface}" ''Driver = "Pervasive ODBC Unicode Interface" ''Driver =...

I googled for some help and found this code which I modified a bit. (I tested with HFSQL which worked fine) But with Pervasive I get DSN creating failed: 6 Const ODBC_ADD_SYS_DSN = 4 'Add a system data source Private Declare Function SQLConfigDataSource Lib "ODBCCP32.DLL" (ByVal _...

No I did not - not sure how to. Function/Method not found. SQLConfigDataSource is declared like this: Declare Function SQLConfigDataSource Lib "ODBCCP32.DLL" (ByVal hwndParent As Long, ByVal fRequest As Long, ByVal lpszDriver As String, ByVal lpszAttributes As String) As Long Should I then...

Hi, I made sure all is 32-bit including Access thanks

Well I read and tried a lot of diffrent option but still no luck. sonic8 or someone else who can help with the correct syntax to create a DSN from scratch would be very helpful. Public Function CreateDSN(strDsn) Dim vAttributes As String ''vAttributes = "DSN=" & strDsn & ";Description=Pervasive...

Ahh - thanks a lot for the link - that might come in handy. Will go through it now.

HI David, thanks for the reply. I did not post the entire code since the rest is standard. I delete the table, then recreate it yes. I normally use the User of System tabs but I tried the File tab as you suggested. It also stopped hafl way with the same error but it did create a DSN file with...