Viewing 15 posts - 196 through 210 (of 334 total)
Thanks. THe article ref'd didn't really get into the use of Stream except for the usual getting data into and out of a BLOB. But you're saying ADO will copy...
March 22, 2005 at 7:12 am
paste the following two functions into a module, then in the Immediate window enter "? AttachDSNLessTable()" and press Enter. It may run for a while so be patient.
Function AttachDSNLessTable(stLocalTableName As...
March 8, 2005 at 6:58 am
Actually Newbie's ref to MS pointed to some code that could be used to convert a DSN based Linked Table to a DSN-less Linked Table. I copied the code to...
March 7, 2005 at 1:29 pm
Back to the specification of Shared Connections. Here's my Module:
1 Attribute VB_Name = "Module1"
2 Option Compare Database
3
...
March 3, 2005 at 8:00 am
Ummm... OK, any thoughts on how to do that in Access VBA?
March 3, 2005 at 7:23 am
How unique is the Enttime field? If it is a true datetime (down to ms) then they should be unique in which case you could use that as your primary...
March 2, 2005 at 6:57 am
Is this in code or is it a data-bound form? If it's in code (either module or code behind controls) try opening the form in design mode, go to the...
March 2, 2005 at 6:49 am
... Unless you have no suitable field or fields for a primary key. In that case you will have to re-establish the local table (if you haven't deleted it yet...
March 1, 2005 at 7:40 am
Did you upsize the Access DB to SQL? Does the table you're updating have a Primary Key? If not then the upsizing wizard will make it read-only...
March 1, 2005 at 6:34 am
That did the trick. I knew there was something missing...
Now I have a problem with Access complaining that there are concurrent updates to one of the tables, and I'm the...
February 25, 2005 at 1:06 pm
Is it safe to assume each user can have multiple roles, hence the UsersRoles table? If not then your table structure is too complex. If each user only has one...
February 24, 2005 at 8:02 am
Depending on the size of the tables and/or the number of rows being updated you might get better performance with Table Variables (Declare Tablea TABLE (idkey int, fname varchar(100)...)). Select...
February 24, 2005 at 7:54 am
Do you store content other than WAV files in this field? If not, isn't the field NULL if there's no WAV file? If so then
Select * from tablename where...
February 17, 2005 at 7:20 am
Viewing 15 posts - 196 through 210 (of 334 total)