vba To Convert Tables

[DMT Dave]

Hi Guy's this question maybe a little bizarre but i will ask anyway

1 of our office PC's is working on WIFI, all other machines are working hard wired to the server PC



all backend DB are on the server PC

On the PC that is not wired is really struggling to open a form where the table related to the form is shared via linked table manager

However, a form that is linked to a local table in that database opens instantly

There isn't enough ethernet ports to wire the machine in

1: is a WIFI booster any good and would this potentially solve ?

The next option i thought of is from my PC (cabled to network) all works instantly, if i update tables,

Is it easy for a vba option to convert all linked tables back to local tables and copy the Db over the the WIFI PC (not wired)

Hope i have explained correctly

Kindest

[ranman256]

You can use local tables for that PC, but you cannot just copy.
from a hardwired pc, youd need to create some append queries, that will add the data from the local table db to the server db.
A networked pc could link in the local tables (with slightly different names) then it can run the append queries.

ALSO, all this depends on your table structures. Some data can be simply appended, but some cannot due to keys, or the like. You'd know best.

[isladogs]

You should never use Access on a WiFi connection as there is a significant risk of corruption.

However, you can easily convert linked tables by right clicking and selecting Convert to Local Table.
Copying the modified data back to the network would still be an issue

[moke123]

There isn't enough ethernet ports to wire the machine in

Add a switch for @ $20 - $30.

[Welshgasman]

You can even get ethernet port doublers, though my choice would be a switch?

However, before that I would also try another PC on wifi, just to see if the same happens there?

[DMT Dave]

Thank you guy's i think we have problems trying get the said pc onto the network but that is best fix possible i think....

Kindest

[DMT Dave]

Hi Guy's so where i am with this now, i am waiting for our IT company to assist onsite, until then i need to do the following but can't quite get this going properly

Certain Tables Delete
Certain Table Import
Certain Tables Convert To Local

This what i have so far but !!! your expert advice would be better

DoCmd.DeleteObject acTable, "tblInvoices1"
Dim srcFile As String, srcTbl As String, DestTbl As String, DestFile As String


srcTbl = "tblInvoices"
DestTbl = "tblInvoices1"


DestFile = "C:\Users\David\Desktop\Accounts DMT Ltd.accdb"

DoCmd.DeleteObject acTable, "tblInvoices1"
DoCmd.TransferDatabase acImport, "Microsoft Access", DestFile, acTable, srcTbl, DestTbl, False
DoCmd.SelectObject acTable, "tblInvoices1", True
DoCmd.RunCommand acCmdConvertLinkedTableToLocal



MsgBox ("Tables Are Now Replaced With Linked"), vbInformation + vbOKOnly, "DELETED SUCESSFULLY"

Is there a easy fix to this ? i may have the source or destination the wrong way round

Kindest

[DMT Dave]

Man alive, guy's this is most of my problem is concenration, i was trying to import back end tables instead of front end!!! all works