Id id this once before and had not to much problem with it, but now with a office Access 2013 and in vb net 12, I cannot redo it.
All I want to do is building 2 Stored Procedure in access 2013, simple one like ( I have this running on my MySQL server )
`@`%` PROCEDURE `getHotStaff`(HotelID bigint)
Select * from staff where hot_id = HotelID;
and call it from vb net with something like this
Using conn As New OleDbConnection()
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\myaccess.mdb"
Using cmd As New OleDbCommand()
cmd.CommandText = "NameOfTheQuery"
cmd.CommandType = CommandType.StoredProcedure
' Note: You can also use CommandType.TableDirect
cmd.Connection = conn
my problem is that with office 2013, all I was able to build is a view but no 'stored proc', I google it but didn't find that step by step in access 2013 on how to build a S.P
A little help would be greatly appreciated,