Compatibility with VB .net

[Guest]

After installing VB .net, I can't get into my Access db. I get an error when the menu comes up. Then if I try to go into any of the tables in design, nothing happens. If I click Open, nothing happens. If I double click on a table, I get an error box with "unknown" in it with an OK button. The forms all appear OK, and the properties on the tables appear OK. I tried to compact and repair and it didn't work. Then tried to open a backup copy and got the same problem. Is there something in VB.net that I can turn off? Or do I need to upgrade Access?

 

[Anushi]

Hi Laurel,

VB.NET installation has nothing to do with Access. Seems like your database
is corrupted, and needs repair.

Try running JetComp.exe, the final solution to get your data out of a
corrupted db.

http://support.microsoft.com/default.aspx?scid=kb;en-us;273956

Download this utility and run it on the corrupted db. Get back if this does
not work....

Anushi.

After installing VB .net, I can't get into my Access db. I get an error

when the menu comes up. Then if I try to go into any of the tables in
design, nothing happens. If I click Open, nothing happens. If I double
click on a table, I get an error box with "unknown" in it with an OK button.
The forms all appear OK, and the properties on the tables appear OK. I
tried to compact and repair and it didn't work. Then tried to open a backup
copy and got the same problem. Is there something in VB.net that I can turn
off? Or do I need to upgrade Access?

 

[Guest]

Anushi,
Thanks for your prompt reply. Having trouble using JetComp for some reason. It states "3. In the Database to Compact Into (Destination) box, type the path and name of the new compacted database that you want to create." When I type a new name, says the DB does not exist. So I created a blank database and it just gives "Error Compacting Database". Any ideas?

----- Anushi wrote: -----

Hi Laurel,

VB.NET installation has nothing to do with Access. Seems like your database
is corrupted, and needs repair.

Try running JetComp.exe, the final solution to get your data out of a
corrupted db.

http://support.microsoft.com/default.aspx?scid=kb;en-us;273956

Download this utility and run it on the corrupted db. Get back if this does
not work....

Anushi.

After installing VB .net, I can't get into my Access db. I get an error

when the menu comes up. Then if I try to go into any of the tables in
design, nothing happens. If I click Open, nothing happens. If I double
click on a table, I get an error box with "unknown" in it with an OK button.
The forms all appear OK, and the properties on the tables appear OK. I
tried to compact and repair and it didn't work. Then tried to open a backup
copy and got the same problem. Is there something in VB.net that I can turn
off? Or do I need to upgrade Access?

 

[Anushi]

Hi Laurel
There is , for sure, no connection between access and .net. Have you tried
opening other tables in MS Access? If they are opening up , and only this
particular one is not having issues, then this db is corrupted. You would
need to manually import the data into an excel sheet. The following are the
steps:
1. Open Microsoft Excel and create a new sheet (file)

2. Click on the " Data" drop down menu, select " Get external data"

and click on " New database query"

3. select " MS Access Database*"

4. On the " Select Database" dialog browse to where your " corrupted"

database is located and open it (double click)

At this point you' ll see a dialog box displaying all the tables in your

database under the heading " Available tables and columns"

5. All you do is select your table and click the > arrow to move it over

to the " Columns in your query" section.

6. Click " Next"

7. Click " Next" again

8. In the " Sort by" just select the first field on your table (ID, Index,
whatever)

9. On the next screen make sure the " Return data to Microsoft Excel"

is selected and click " Finish"

10. In the " Where do you want to put the data" screen, make sure that

" Existing worksheet" is selected and that " =$A$1" is showing.

11. Click Ok

Now you' ll see your data from that table as a excel worksheet.

Save it and you' re done. If you have more than one table in your

Access database you' ll have repeat steps 2 - 11 for every table you have.

After you' ve recovered and saved your table(s), open Microsoft Access and

create a new blank database. Then:

1. Select the " File" drop down menu, select " Get External Data" and then

select " Import..."

2. Browse to where your saved Excel data (recovered table) is and import it.

I' m assuming you know your way around Access so at this point the rest of

the process is quite obvious.

I hope the steps mentioned above are descriptive enoughto help you recover

your files.

However, if you have issues with all dbs in Access, then I am afraid to say
that you might need to uninstall and install MS Access, and .NET !!

I faced a similar issue in VB long back, and had to reinstall studio. Good
luck !!

Anushi,
I got it to work by just typing in the path instead of using the ... to

select it. But, it did not work. The reason I was questioning VB .net was
because I had recently installed it. The problem seems to me to be an
interference because the backup that I have on a Zip drive is acting the
same way and I'm "sure" it was ok. I also recently installed SQL Server.
Any other ideas?

 

[Guest]

Anushi
The problem is with all files on all databases. And Access is part of office. Which reminded me that I just applied an office patch the other day. Not sure which happened first. Are you suggesting that I reinstall Office? I tried to just install Access and it took about 3 seconds and didn't fix the problem. Suggestions

----- Anushi wrote: ----

Hi Laure
There is , for sure, no connection between access and .net. Have you trie
opening other tables in MS Access? If they are opening up , and only thi
particular one is not having issues, then this db is corrupted. You woul
need to manually import the data into an excel sheet. The following are th
steps
1. Open Microsoft Excel and create a new sheet (file

2. Click on the " Data" drop down menu, select " Get external data

and click on " New database query

3. select " MS Access Database*

4. On the " Select Database" dialog browse to where your " corrupted

database is located and open it (double click

At this point you' ll see a dialog box displaying all the tables in you

database under the heading " Available tables and columns

5. All you do is select your table and click the > arrow to move it ove

to the " Columns in your query" section

6. Click " Next

7. Click " Next" agai

8. In the " Sort by" just select the first field on your table (ID, Index
whatever

9. On the next screen make sure the " Return data to Microsoft Excel

is selected and click " Finish

10. In the " Where do you want to put the data" screen, make sure tha

" Existing worksheet" is selected and that " =$A$1" is showing

11. Click O

Now you' ll see your data from that table as a excel worksheet

Save it and you' re done. If you have more than one table in you

Access database you' ll have repeat steps 2 - 11 for every table you have

After you' ve recovered and saved your table(s), open Microsoft Access an

create a new blank database. Then

1. Select the " File" drop down menu, select " Get External Data" and the

select " Import...

2. Browse to where your saved Excel data (recovered table) is and import it

I' m assuming you know your way around Access so at this point the rest o

the process is quite obvious

I hope the steps mentioned above are descriptive enoughto help you recove

your files

However, if you have issues with all dbs in Access, then I am afraid to sa
that you might need to uninstall and install MS Access, and .NET !

I faced a similar issue in VB long back, and had to reinstall studio. Goo
luck !

Anushi
I got it to work by just typing in the path instead of using the ... t

select it. But, it did not work. The reason I was questioning VB .net wa
because I had recently installed it. The problem seems to me to be a
interference because the backup that I have on a Zip drive is acting th
same way and I'm "sure" it was ok. I also recently installed SQL Server
Any other ideas