Search results

Hi, Can anyone please shed some insight into my problem !! We have an access 2000 database on our server, this database is being accessed via Jet ADO from many machines and users (normally 2 concurrent users). Every now and again, for no reason, the VB system crashes and the database says...

WOO HOOO !!! Thanks. That has done the trick ! Mark.

i have attached two sample databases, one with password. I am trying to get the data from 'Test_FROM.mdb' into 'Test_To.mdb' the database password is '1'

when i have the initial SQL code.. (ie. with the ;) i get "Not a valid password" Now, I know what ur gonna say !! But it IS the right password. when i have the new SQL code.. (ie. without the ;) i get "Syntax error In INSERT INTO statement" sigh......

Yes, still doesn't work. Brings up different error message. I am using the Access design screen, selecting Append Query. This is why i can't figure out why it is not working, Access is generating the SQL code ! Mark

Aaaaarrggghhh !!!!!!!!!! Can anybody PLEASE help me ! This is driving me mad ! I am using an append query to update data from one database to another. This works fine when the database i am appending to does NOT have a database password....However ! When the database I am appending to, DOES...

I am trying to append data in one database to another, both databases have a database password.. This is my SQL INSERT INTO [;PWD=driftwood].AcceptedPayment IN 'C:\TO.mdb'[;PWD=driftwood] SELECT AcceptedPayment.* FROM AcceptedPayment When i try and run this i get "Syntax Error In Insert...

I am using VB6 and have connected to an Access database. I have then wrote a function to "append" all data from this database into another database. However, this works fine so long as my "new" database does not have a "database password". Is there any way I can pass the password via VB in an...