Export queries as views

access , db United Kingdom
  • 13 years ago

    As you most likely well know acess queries are more commonly known as views

    A customer has given me a database to create a web interface to as well as the traditional access one, this is fine except when you export to the ODBC database they get converted into tables

     this obviously isnt correct.

    apart from ripping out the JetSQL and converting into postGreSQL by does any one know a cheap and easy way to keep them as views in the postgres database??

     

    Drogo

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“There are only two kinds of languages: the ones people complain about and the ones nobody uses” - Bjarne Stroustrup