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...

You were right about using ArrayList. like this is working. I guess I didnt understand the difference between generic and nongeneric types. thanks!

I tried tu use Collection. but I have the same warning. Imports System.Collections.ObjectModel Public Property m_KeywordList() As Collection(Of Keyword)

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...

I found a way to make a class library as a new project (in .net). and after this to add in references (in VBA) this .net dll. But, in my .net project there are a lots of classes, and I need just some of them. it means that I have to make a new project (class library) containing just these...

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...

I dont know if I understood corectly. the suser_sname() or curent_user or system_user will give me the user that is working on one table? what if they are 2 users login both of them working, one inserting in a table and one modifying something?! how can I make a difference between them? how can...

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...