If you are using ADO.Net, look into the dataset, SQLDataAdapter, SQLCommand and DataView classes.   

I have never seen this problem unless it was a rights issue.  If you are using the same ODBC connection, then that is not the case.  Not many people will...

First thing to check, are you sure that the MSDE is running?  Second thing, make sure your account is a local admin on the workstation and try to log in...

Try this to generate a script:

declare @role varchar(15)

set @role = 'abc' -- replace with your role

create table #tempPermissions(owner varchar(50),object varchar(100),grantee varchar(100),grantor varchar(100),ProtectType varchar(15), action varchar(25), [column] varchar(25))

insert into #tempPermissions exec...

It's hard to find questions to answer since the contest started! I guess this is good for the people who need a little help.

One really easy way you can do this is to create a File type DSN.  THen when you link the tables, say you want to save the password.  If you...

Overall this looks like good news.  I am disappointed that the Report Builder is only available with Enterprise version.  We do have 4 or 5 Enterprise Edition installations now and have software assurance...

You can run a log backup in a stored proc, but you can't do it inside a transaction.  Look in you proc for the words "Begin Transaction" and "Commit Transaction". ...

If you are trying to add a record directly to a table and get this error, then I would look to see if there is a trigger on the table...

Even if you had Enterprise Manager, it is more efficient to add the field using code:

alter table myTable add myNewColumn int null

Here is an article about this error:

http://support.microsoft.com/default.aspx?scid=kb;en-us;301693

Looks like it is just a generic error that could mean anything.  The article tells how to find out what the actual error...

Back when I did lots of Access/SQL apps I kept a copy of the MDB file in place on the network.  At this company, there were about 50 users.  We...

I am very impressed with ADP.  I agree that Access does have lots of great features and this looks like a great way to combine those features in an efficient way...

I knew writing Access articles on a SQL Server site was going to be interesting.  The only comment so far about my Access Project article is that they can only...

I would think you can give each user their own copy of the ADP file, which is also what I recommend for MDB.  I haven't written any Access Project apps,...