How to pull tables in from SQL then push data back to SQL

[p-rat]

I'm very new and confused. I have created tables in Access. I have
queries in Access that pull in data from an SQL back end.

I have a form that has fields based on queries and just normal data
entry.

The tables I have created on Access are also on the SQL back end.

Do I need to link to ALL the tables on the backend or just the tables
that I'm pulling from? How to I export my form recordset to the tables
located on backend?

Urgent help is needed and I'd appreciate any that can be given.

 

[Albert D. Kallal]

Do I need to link to ALL the tables on the backend or just the tables
that I'm pulling from? How to I export my form recordset to the tables
located on backend?

Why not just link to all the tables on the SQL server, and when you open up
a form to edit data, that data will *always* reside on SQL server.

In other words I'm suggesting that you upload all of your tables to SQL
server, and leave them there from that point on. I see little or no reason
at all to have the local tables.

Is there any particular reason why you envision an idea where you have to
shuffle all this data back and forth between local tables and SQL server
tables?

I would suggest that you simply link to the tables on SQL server, and use
those for your forms and data, and you therefore you'll save all kinds
development efforts and time. That extra time you save can be used to feed
the local poor.....

Thus the general suggestion and idea here is simply to upload all of your
data into SQL server, and once you've done that then you should have no need
for your local data anymore.

 

[Powderfinger]

I agree with Albert . If the tables are linked, you would export form data
to them the same way you would export form data to any table. There should
be no difference the way you handle an access table vs. an sql table. They
are just tables as far as access is concerned.