Using vb to write to be table

[Guest]

i have a fe mde file and a be mdb. I have some startup code in the fe which i
want to write data to the be tables.

my fe is in directory c:\appname
my be is in directory c:\appname\database

any ideas anyone?

 

[Graham Mandeno]

Hi Stu

The actual location of the FE and BE files does not matter here, because all
the BE tables you wish to access should be linked tables in the FE database.

Linked tables behave in almost exactly the same way as local tables (there
are a few differences and actually they behave more like updateable
queries). So you can write to them in the same way you would write to a
local table.

You could:
1) run an append or update query
2) execute an UPDATE or INSERT INTO SQL statement
3) open a recordset on the table and edit/addnew records

Take your pick

 

[Guest]

many thanks

Hi Stu

The actual location of the FE and BE files does not matter here, because all
the BE tables you wish to access should be linked tables in the FE database.

Linked tables behave in almost exactly the same way as local tables (there
are a few differences and actually they behave more like updateable
queries). So you can write to them in the same way you would write to a
local table.

You could:
1) run an append or update query
2) execute an UPDATE or INSERT INTO SQL statement
3) open a recordset on the table and edit/addnew records

Take your pick
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

i have a fe mde file and a be mdb. I have some startup code in the fe which
i
want to write data to the be tables.

my fe is in directory c:\appname
my be is in directory c:\appname\database

any ideas anyone?