Search results

Hi, looking for a tool which help to transfrom PostgresSQL to AccessSQL. I want to just use powerful access quuery designer from postgres. Thanks for any tips, Best, Jacek

Hi! Thank you very much i will check your solution Jacek

hi Guys, i want to import tables from postgresql into Access using Link tables. How can i do this if table name is something like (in postgres, i can not change it is part of a model): vn-bundle-majax:analytics:1.0.0.TableName This is why that in postgres schema name is...

We will see i hope it will be useful. Maybe i will try to do this via VBA... Jacek

Minty, you mean cant code by VBA? Jacek

Thanks: the error i am getting is like you see. Not working still ech. sqlS = "ALTER TABLE tblCustomers " & _ "ADD CONSTRAINT " & _ "CustomerCon UNIQUE NONCLUSTERED" & _ "(" & _ "LastName," & _ "FirstName" & _ ")" but it worked with out NONCLUSTERED - maybe this is SQL Server only...

i have composite keys as primary keys in both tables. What i know is that primary key is unique always from design. And if i am using composite primary key they have already index created. i do not undetsrand what you mean Minty

thank you The_Doc_Man. I have even issues with creating one to many relationships between composite keys. I am getting errors. Best, Jacek

Thank you. I tried. Maybe microsoft didnt implement this feature?

Thank you so much for your help, Still didnt work. I used your sql Pat: sqlS = "ALTER TABLE tblInvoices ADD CONSTRAINT FKLastName PRIMARY KEY ([LastName], [FirstName]) REFERENCES tblCustomers ([LastName], [FirstName])" But i am getting syntax error in ALTER statement... Maybe it is not...

Hi, thank you for the clue. I used VBA and DAO engine. This worked for me but creating many to one: Sub CreateTableX1() Dim dbs As Database ' Modify this line to include the path to Northwind ' on your computer. Set dbs = CurrentDb On Error Resume Next sqlS =...

Hi Minty, as i wrote before i tried: ALTER TABLE tblInvoices ADD CONSTRAINT FK_Test FOREIGN KEY ([PK]) REFERENCES tblCustomers ([PK]) --> worked and tried: ALTER TABLE tblInvoices ADD CONSTRAINT FK_LastName FOREIGN KEY ([Last Name]) REFERENCES tblCustomers ([Last Name]) -- no unique...

Thank you Pat for good lesson for me. I know that relationship is wrong. I only need technical solution how to write Access SQL to create composite key relationship plus 1 to 1 relationship. And if this is possible? Best Jacek

Thank you Minty. i am trying with this all the time but i have only errors returned... Best Wishes, Jacek

You mean in code? I could use VBA and ADO statements but i have to know what to pass :) I tried link attached but i failed - please see post #33 : ALTER TABLE tblInvoices ADD CONSTRAINT FK_Test FOREIGN KEY ([PK]) REFERENCES tblCustomers ([PK]) but this is relating only 1 to many... Please...

Thank you Galaxiom, yes i have to resign from this idea. Seems to be without sense. Yes i am tring to create relationships using Access SQL in this topic: https://www.access-programmers.co.uk/forums/threads/import-ddl-database-structure-to-access-database.315491/page-2#post-1739950 Thank you...

Hello, thank you Guys. Minty awesome explanation. Ok so no problem with this. But still would be nice how to create SQL 1:1 - just to know how to solve this technically. Plus sql for composite key 1 to many relationships plus 1 to 1 composite keys, these relationships are working: it is...

Thank you Pat.

Thank you Minty for getting involved! Sorry for example, it is poor but i do not need design it properly and i cant share fields name here. Can you please help with only technical solution, i.e. providing SQL which solve the issues from #33 ? Best Wishes, Jacek

thank you Colin! ah in postgres there is no relationships/diagram viewer unfortunately i thought it will be easier to see relationships in Access way... Best Wishes, Jacek