Search results for query: *

In migrating and application from Access 2000 to Access 2003, i faced an issue with transfering my queries from a 2000 format to 2003 format. I had a form and vb code behind it to let user ick his personal queries from old version of app. and import it to new version. it works fine for stations...

Hi All, I have a Access 2000 table with an OLE(embeded) field of word document. One of the records has a corrupted entry for this field (in datasheet mode, it shows "OLE Object" while it shows "Microsoft Word Document" for the others). when i focus to the field it gives me the error "Microsoft...

Hi there, Thanks for the reply. Unfortunately nothing is marked as MISSING in Tools->References window. The fact that 4 systems have the exact same situation, makes me suspicios. it should be a more general issue than something specific to a system. I tried to reinstall the MDAC 2.8 SP1 patch...

Hi , Try this statement after closing the connection: set dbase2=Nothing Thanks, Ramin

Hi all, All of a sudden i get error -2147024770 Automation Error... Specific module can not be found" on 4 of my workstations running office 2003 prof. edition over Windows XP prof. SP2. They were working fine till last Friday. I searched for this error, and found out it maybe caused by a...

The date format wasn't the issue. Thanks anyway Jerry!

Hi. when i design a query in access 2003 and filter one date field (between #1/1/1992# and #12/31/2001#) it ignores all the records >=1/1/2000 . is this a Y2K problem? and what's the solution? is there any settings to come over this problem? ** not to mention that the query works fine in...

Thanks NortonES2 very much. I figured it out yesterday and fixed it. Yes, it was Disk Quota. :))

Hi all, Recently we had a disaster and had to switch to a temporary server. After that , workstations can not see the real size of shared Network drive and real size of remaining space. It's different from workstation to workstation. meanwhile we have 48GB free space on Netwotk Drive, for some...

Hi DrSql, It seems that it's a general issue, and almost all the stations are involved. Now the question is, if every single ODBC connection to an object in sql server is counting toward concurrent connections to server. I set the server licensing to per server with limitations of 25 concurrent...

We had a disaster 2-3 days ago. Server Crashed after a Blackout. We replaced the server with a new one and restored the data from a backup set, including SQL Server 7.0 Data. Workstations are connected to the Sql Server via an ODBC connection. But the connection is not persistant for some of...

Hi. I am involved in a truely disaster happened few minutes ago. I'm a software developer and not a hardware guy. Our server has two identical scsi hdd(80 gb). we're using the second one as mirror disk. 10 days ago the primary hdd went bad and it was running on Mirrored disk. This morning we...

I have a VBA procedure (ADO/DAO) for copying a selection of queries from another Access database whick woks fine in Access 2000. But when it runs on Office 2003 environment, it loses the relation between query's components(subqueries and tables).Therefore the query is useless practically. will...

Excellent drctx! Thanks so much for your help ! Ramin

Is there any way (builtin function) to grab the windows login user id within the access? Thanks in advance, Ramin Riahi

In migrating and application from Access 2000 to Access 2003, i faced an issue with transfering my queries from a 2000 format to 2003 format. I had a form and vb code behind it to let user ick his personal queries from old version of app. and import it to new version. it works fine for stations...

Thanks a lot NortonES. It was main part of my issue, besides i had two non-identical version installed on that workstation(i don't know how... believe me!!!). one upgraded with a SR-1a patch and one not. So as soon as i upgraded the second one , and utilized that all local installation option...

No luck with it yet. I replaced that workstation with a brand new computer :-) . But still working on this issue. So please if anyone got an ultimate solution for this inform me. I truely appreciate! And ofcourse i do the same when i came up with something on this. Thanks a lot, Ramin

One of my workstations has win xp professional as OS and it's connected to a win 2000 server. On this machine i have microsoft office 2000 pro installed. It works properly only for one of the users (member of Administration group), and for others i get the message windows installer package is...

Hi. --Sorry for bothering you guys, but as my development phase deadline is so close, i had no choice other than bring it to you (last minute, short notice adding requests of customers ...Ayyayyaa...ya) :-( To best of my knowledge, Access 2000 doesn't have capability of dealing with XML files...