One thing you'll want to look at carefully is licensing. If its just for internal use you can buy client access licenses (CAL's), but if you're going to have internet...

Generally you do formatting on the client, sometimes it makes sense to do in a view so you just code it once. Try this:

format$(.Fields("WORKPHONE_TXT"), "(999)000-0000").Value)

Andy

The view will show the update I believe.

Andy

It is possible. I think there is some sample code and headers that get installed if you choose the sample code option when you install SQL. The other option is...

I think to use a trigger in Access you have to be in project mode (.adp), which means you'd be using MSDE as the storage engine. If thats the case...

Not aware of a way, then again I dont do much data access with Excel. Are you using a DSN, UDL, or embedded connection string?

Andy

I try to stick with a single mdf/ldf unless I run into space limitations - just easier to administer. Testing filegroup performance is about like another test - come up...

BOL for IdentityIncrement Property (DMO) says it is read only for existing columns. Seems like it should be possible to change it - what would it hurt?

Andy

I've seen cases where it was slow if you had a large number of db's or a lot of backup history (or both).

Andy

Just to follow up - adding memory would let you preserve current performance levels or even enhance and still let you set aside more memory for server processes. I rarely...

Glad we were able to help a little!

Andy

Yes you can. Take a look at sp_attach_single_file_db. I'd recommend you make a copy of the mdf and ldf in a separate folder before you try - just in case!...

Only if you have to do it to keep your other processes running. I'd recommend adding more RAM.

Andy

Try this:

xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer', N'AuditLevel'

Andy

Maybe this one:

http://www.sqlservercentral.com/columnists/awarren/copyingdtspackagestoadifferentserver.asp

Andy