PL/SQL with Access 2000

[GlenW]

Can I implement PL/SQL with ADO to an Access 2000 database.
If yes how?

[RSINGH]

PL/SQL is native to and only works against Oracle databases. So 'fraid not.

[GlenW]

Originally posted by RSINGH
PL/SQL is native to and only works against Oracle databases. So 'fraid not.

Is there anything similar I could use for Access or SQLServer?

[RSINGH]

In SQL Server, you would use Transact SQL which is used to create your stored procedures, views and program flow control. I've only used Access up to 97 and there is nothing comparable. Although I hear you can make stored procedures in Access 2000. You can then call these through an ADO command or connection object.

[GlenW]

God al-bloody-mighty I'm sick of learning new languages.
Hope this is the last one.

[RSINGH]

T-SQL is pretty straight forward and not too diferent to PL/SQL. I suppose you can consider it as Microsoft's implementation. Good luck - if you need any help just shout.

[GlenW]

Good luck - if you need any help just shout.

Cheers