linked tables problems

[hdesbiens]

Hi

heres my problem

i have two databases:

- sellers.mdb that contains all of the forms queries and reports

- data.mdb that contains all the tables

what i want to do is link the tables from the file sellers.mdb to the data.mdb by making a map on the network, when i dows that no problem all the tables are linked correctly and i can see the data if i click on the linked tables from sellers.mdb.

but when i open my forms sometimes i cant see the forms entirely and sometimes it is my subforms that i cant see they are grayed and dont see nothing on it.

I have made a test i used sql server whit an odbc and that not happens, i dont understand what is the problem with access.

can someone already have this problem and can help me find the problem?

thanks a lot

 

[BNPMike]

If you are saying you can see the raw tables OK but your forms don't work then it's not the linking that's the problem.

It's unlikely your test with SQL Server is relevant to your Access forms, unless you've gone to a tremendous amount of trouble.

Also 'sometimes' is worrying. Presumably therefore, these forms sometimes work just fine?

Can you tell us more detail? What is different between when it works and when it doesn't?

 

[hdesbiens]

Hi

okay

When i try to link my tables by a map on the server that point to the folder where the file data.mdb is, my forms are'nt working.

but

If my two files sellers.mdb and data.mdb are in the same directory and i link the tables directly in the same directory then it works!!!

this is the first time i saw that and i really dont undertstand.

Thanks a lot

Hugo

 

[willir]

Hugo

Could this be a security issue? Make sure you have full access to the different directories Sellers and Data databases. Access complains very loudly if you do not have write access to the database.

Richard

 

[hdesbiens]

ok thanks i will try this!

 

[hdesbiens]

Hi i have tried to change the esecurity of the files but it change nothing.

is there another thing that can cause me this problem?

Can someone tell me how to link my tables so that many users can have the files sellers.mdb on their machine and works at the same time on the same data.mdb on the server?

Heres some sample code that i use that doesnt work with linked tables.

Private Sub Commande5_Click()
On Error GoTo Err_Commande5_Click


DoCmd.GoToRecord , , acNewRec
Call UnlockForm
Me.no_formulaire.SetFocus

Exit_Commande5_Click:
Exit Sub

Err_Commande5_Click:
MsgBox Err.description
Resume Exit_Commande5_Click

End Sub

just that function does not work with linked tables it tell me unable to reach this record but it just a code generated by access to insert a new record!!!

thanks for your help

Hugo