i have created a database for subscriptions in MS Access 2007. I want to link it with my forms using the code below but its saying unrecognised database format.
Dim conn As Connection
Set conn = New Connection
conn.Open "PROVIDER=Microsoft.Jet.OLEDB.3.51;Data Source=C:\subscriptions2.mdb".......
Now i have converted it to Access 2000 format and it wont work. I have also converted to acces 2002-2003 but it doesnt work either. i wanted to convert it to Access 97 format but that option is not there on Save As in Access.
Can anyone help because i cant link with the database.
Thank You
Try to change your Provider ,., try to use Microsoft Jet 4.0,.I think it's the latest version..,if there are available service packs on their site...,download it and install it on your machine...My MS Access version is 2003, and my programs works smoothly in both 3.51 and 4.0....
If u import ur database in msaccsess them u meight this problum
to solve this problem fllow the fllowing steps
1.open ur project
2. Create a new data base
3. Close ur project
4. Open the data base
5. Now import ur table
6. Now u can found ur error is solved
Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.
This thread is more than three months old
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Marked Solved 
Offline 
