postgreSQL og Access

may I ask why you would prefer to use PostgreSQL? if its just for your data then why not use MSDE which is a free version of SQL Server and because its a Microsoft product it works well with Access. Other databases can give problems.

Hej Terry,
PostGRASQL foretrækkes da EU er ved at lavew et kemiprogram som bruger nævnte DB som backend.
Men det er ikke et must for mig. Det vil blot gøre det nemmere for brugerne hvis de allerede har den gratis SQL installeret.
Men hvordan gør jeg så med MSDE?
Jeg er noget blank på det område. KAn man linke direkte fra access? Og hvordan skal jeg sætte MSDE op?

Tak for din tid so far.

VH
Jind

If you intend using it in a multi user environment then it should be installed on a server so that all user have access to it.

When it is installed then you make a ODBC data source on each PC and then in Access you can link to the tables in your SQL Server.

Doing all of this can be a bit complicated if you have never tried it before, and it would take some time to explain all steps.

It is also necessary to concider permissions in the SQL Server, but that would also be necessary in PostGRASQL I would think.


But here is a link to MSDE if you decide to use that. You could also concider the new 2005 Express Edition.

http://www.microsoft.com/sql/prodinfo/previousversions/msde/prodinfo.mspx

Hej Terry - jeg kom helt væk fra denne sag.
Du får ddine point - og jeg takker for din tid.

Send lige et svar


VH
Jind

:o)

just in case you didnt get a mail

Nej jeg fik ikke email email første gang.
Tak for hjælpen.

thanks jind.
Have a good day