Search results for query: *

hi! I have an Access front-end with SQL Server database. I want to change the isolation level in SQL Server to serializable from Access, not to be able to insert while another user is selecting (reading). I tried making a store procedure just to: "set transaction isolation level serializable go"...

Hi! my problem looks like this: I have an Access app using linked tables from SQL Server. for the UserManagement I need to know exactly who is connected to the DB. I thought about creating a new DSN using info from a login form (DSN name, database, username and password) and re-link the...

Hi! I need to be able to reuse some vb.net classes in some other projects (one in VBA). I thought that I should make a class library project(containing COM classes) and after this to add it in references in VBA. I encoured some problems, some warnings, like: Type library exporter warning...

Hi! I have a project in VBA and I want to use some classes and functions from a vb.net project. is this possible? without changing the vb.net project? thanks for any advices!

Hi! I've made 2 triggers: one for insert and one for update that should put in the every table the user who makes an insert or update a record and also the system date. but, when I make an insert in Enterprise Manager, everything is ok, its updating just the record that suffer the changes.When I...

Hi, I have an application in visual basic.net with a database in sql server. in my database I have a table user that stores every user_id and password. also, every table has create_user and update_user columns linked to user table. how can I know who made an insert or modified something in one...