I use access, i like access, i understand how access works (almost)

The bit i don't understand about access is the VBA side of thing, as i
don't know VBA.

In a couple of hours I'm going to be looking at a VBA database program
to try and work out what is going on.

Basically HOW DOES VBA INTERFACE WITH JET? CAN I GET IT INTO ACCESS?

the VBA programmer made the classic mistake- very pretty forms but
incorrect data structure.
ie lots of 1-to-1 and a 1-to-many when it is many-to-many.

what i want to know is there anyway i can take his underlying data
structure and look at it in Access.

I know that the guy did not do the underlying stuff (i don't even know
what it is called). only the forms and queries on top

Brougham

hoping for a quick response

I use access, i like access, i understand how access works (almost)

The bit i don't understand about access is the VBA side of thing, as i
don't know VBA.

In a couple of hours I'm going to be looking at a VBA database program
to try and work out what is going on.

Basically HOW DOES VBA INTERFACE WITH JET? CAN I GET IT INTO ACCESS?

the VBA programmer made the classic mistake- very pretty forms but
incorrect data structure.
ie lots of 1-to-1 and a 1-to-many when it is many-to-many.

what i want to know is there anyway i can take his underlying data
structure and look at it in Access.

I know that the guy did not do the underlying stuff (i don't even know
what it is called). only the forms and queries on top

Brougham

hoping for a quick response

The screens you are looking for are under Tools...Relationships and in the
Tables page on the database window.  Be advised that modifying
relationships may have strange effects on those pretty forms, so check them
out carefully after changes to make sure you are still getting the desired
results.

Let me try this again...this example is synchronizing a replicated database
using Jet

Private Sub Command0_Click()
Dim maindb As Database
Dim wrkJet As Workspace
On Error GoTo err_handler
' Create Microsoft Jet Workspace object.
    Set wrkJet = CreateWorkspace("", "admin", "", dbUseJet)

    ' Open Database object from saved Microsoft Jet database
    ' for exclusive use.
    DoCmd.Hourglass (1)
    Set maindb = wrkJet.OpenDatabase("G:\AccessDB\SysData.mdb")
    DoCmd.Hourglass (0)
    MsgBox "Ready to go...", vbOKOnly
    DoCmd.Hourglass (1)

    If chkSend = True Then maindb.Synchronize
"C:\Sysdata\Sysdata.Replica.mdb", dbRepExportChanges
    If chkReceive = True Then maindb.Synchronize
"C:\Sysdata\Sysdata.Replica.mdb", dbRepImportChanges

    (etc...)