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 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...

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...

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...

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...

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...

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...

I have an application(front-end access 2000, back-end sql server 7). in one of my subforms i have a data-sheet bounded to an sql server table. in my network environment just 2 workstations have office 2003 suite prof. edition(on XP prof. OS). Only on these 2 machines, it keeps telling it can't...

I'm trying to utilize sql statement in an EDI application, but i have problem with handling some special characters: Single quote ' Double Quote " Question mark ? I was wonder if i can use escape sequence notation for them. (as far as i know ,in java or VB let's say, it's \nnn . is there...

I uninstalled an application from my machine, but it insists it's still there !! I examined the windows registery and found some left over entities in it. please help with this as i'm in extreme critical situation. i have to get something done today, and i need to have a fresh, clean install...

I had Sql 7.0 (main) and Sql 2000(eval. version) as an instance installed on my the machine. Sql 2000 was corrupted all of a sudden. I uninstalled it, but after that Sql 7.0 got corrupted too :-( I uninstalled the Sql 7.0 and it said it's successfully done, but when i wanted to re-install it...

I'm using a cursor in a stored procedure which has been defined as declare <cursor_name> cursor for select <f1>,...,<fn> from <table_name> where <condition> for update I tried several options in declare cursor statement(like for browse, ...). But it keeps giving me Err# 16957(for update can...

I need to join tables which are located in different database and eventually different servers, but i don't know how it is possible? (either in Enterprise Manager, or even better than that Transact-SQL statement) Please help me if you can ! Thanks in advance!

Is there any transact-SQL statement to run a DTS package from outside of Enterprise Manager? Or how can i do it from a stored procedure(if it's do-able at all)?

is there anyway to control the commit size, i meant to instruct sql server to write info to disk every n records? it's kind of emergency, please help me!