Recent content by mytaurus2000

I'm sorry, I have a table with several columns of boolean datatype, true/false. I need a query that will display the column name when it's value is true. column1 column2 column3 true false false I would like to have column 1 showing as a result of the query.

Is there a SQL query that allows you to query a table and return the column name if the value of the column is true?

Remou & dhookom You are so AWESOME!!! It is working perfectly. Thanks for all your help.

I'll try this and see what happens

Yes, all the tables are in the be and the links are only in the fe. The fe is on another server, I thought it would be easy for each user to access on the other server rather than have a copy locally. Is this correct?

So I should create the password before I split the database? When you say use it before, what do you mean?

I linked the tables from the fe to the be, but two users are still unable to open the database simultaneously

I created the database and then made a backup copy. I have been experimenting with thd backup copy. The fe tables are imported from the origiinal database. Should i have imported in the backend and linked the front end to those tables?

Can you create a password for the backend only?

Yes, each user has the ability to read write update on both servers. But when one has the database open, and another tires to open nothing happens. No error messages, nothing.

I checked when I open there is a ldb file, but when another user clicks nothing happens. The tables aren't linked, but I imported. Would this make a difference?

Remou, Long time no hear from. The be is on a server that everyone has access to.

I have a database that is split fe/be. the front end is on one server while the be is on another server. When a user opens the fe, no one else is able to access the database. Open in share mode is selected, there is no row-level locking and I have given each user full control permissions and...

Public Sub New(ByVal tmpDS As RAMs) MyBase.New() 'This call is required by the Windows Form Designer. InitializeComponent() 'Add any initialization after the InitializeComponent() call RaMs1.Merge(tmpDS) clsRAMType = New RAMType...

Sorry, I've been debugging for 5.5 hours a little brain drained. Public Sub New(ByVal tmpDS As RAMs) MyBase.New() 'This call is required by the Windows Form Designer. InitializeComponent() 'Add any initialization after the InitializeComponent() call...