Major Problem with moving MSDE DB
-
For the Last 6 hours i have tried to connect to a MSDE database wich was produce on a another computer using Win 2000, When i use the ATL wizard consumer function I get the messeage "Could not open column information" I have troubel to connect to other sources to, it had work before but something is really wrong now, and Im very frustrated. I can look at the database in Access 2000 but when i will create a new table i get the mes. "You got no exclusive access to the database at this time". My questinon to you people are, How should the producer of the DB configure his database(using Access 2000 adp project) so it easy can move it to another machine and system? Im very grateful for answers. /Bigge
-
For the Last 6 hours i have tried to connect to a MSDE database wich was produce on a another computer using Win 2000, When i use the ATL wizard consumer function I get the messeage "Could not open column information" I have troubel to connect to other sources to, it had work before but something is really wrong now, and Im very frustrated. I can look at the database in Access 2000 but when i will create a new table i get the mes. "You got no exclusive access to the database at this time". My questinon to you people are, How should the producer of the DB configure his database(using Access 2000 adp project) so it easy can move it to another machine and system? Im very grateful for answers. /Bigge
-
Do you have admin priviledges? What are the security settings on the DB? Is it corrupted? Have you run a compact/repair successfully? Do you both have the latest MDAC on your systems?
When i lanche his DB i change the login ID and Sql server ID under connection in Access. And link the *.mdf file to the catalog om my computer. Thats it We have admin priviledges, the security settings im not shore of. compact/repair were is this option? I have only installed MSDE and i tried to use servicepack 3 for SQL server 7 to uppgrade MDAC and more. But i got some failurs. Do you now witch pack i should uses to uppgrade? Thanks alot /Bigge
-
When i lanche his DB i change the login ID and Sql server ID under connection in Access. And link the *.mdf file to the catalog om my computer. Thats it We have admin priviledges, the security settings im not shore of. compact/repair were is this option? I have only installed MSDE and i tried to use servicepack 3 for SQL server 7 to uppgrade MDAC and more. But i got some failurs. Do you now witch pack i should uses to uppgrade? Thanks alot /Bigge