I don't know if this is the right forum for Excel to Access questions, but I'll have a go anyway.... Is it possible that any of the column headings aren't valid Access column names? Cheers, - Mark
2003-08-14
2 reads
Confirm that your ODBC connection is valid, also, confirm that the user 'Helpdesk_ABC' is a user in the 'tech' database and has proper permission to complete that persons needed tasks. jimmY Work like you don't need the money. Love like you've never been hurt. And Dance like no one is watching.
2003-08-14
Last week, when we installed SQL Server 2000 on Windows 2003, we got the same problem. Please look at the Microsoft web link below first. http://support.microsoft.com/default.aspx?scid=kb;en-us;319349 But we didn't follow the doc. We just remove SQL Server, then make sure uncheck the Force Protocol Encryption option before you reinstall SQL. Hopefully can give you an […]
2003-08-14
1 reads
Hi Bruce, quote: I have a table report.This table is used to write the hourly summary of the data.A stored procedure will be run for every one hour by a sql server USer.In this table i wanetd to display the time of running the SP and user_name of the user who has run the SP […]
2003-08-11
How about the SQL Server command CONVERT: SELECT CONVERT(VARCHAR(23), GETDATE(), 121) That will return the date and time in the format you want. yyyy-mm-dd hh:mi:ss.mmm -SQLBill
2003-08-04
2 reads
I do all my procs thru script files. Compile into dev, test and if all OK compile into uat and live. I still only have one script but different environments. Makes changing and testing easier.
2003-07-29
2 reads
Personally, I think it's funny that everyone balks at using QBE in EM for query building. I found that in Access, my percentage of reference ambiguity using Grid Manager was zero. However, when I use QA and templates, it's probably 5 to 25% and then I have to make corrections. To me, it's like comparing […]
2003-07-24
1 reads
Yes, I have numerous templates created already. However, my point to this whole thread is that there are some things that are far more easily done in EM using QBE and eliminating the reference ambiguity I mentioned earlier. You've been a great help. Thanks again.
2003-07-24
1 reads
Dale, look in BOL on how to create new templates. However, right clicking on the table in the SQL2K object browser, selcting Script to New Window -> Insert will do the trick.
2003-07-24
1 reads
P.S. I'd be interested in any third party QBE tools that are out there.
2003-07-24
2 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers