473,508 Members | 2,032 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Create Link to BE table

I run a system written in A2003, and it is a standard BE/FE split. I am
distributing a new FE which includes code to update the BE. I can
successfully create new fields in existing tables. I can also create
new tables in the BE, but can anyone help me on how I create the new
links in the FE for the new tables I'm creating in the BE ?

Thanks
Dave

Apr 21 '06 #1
2 1383
DoCmd.TransferDatabase acLink, "Microsoft Access", StrDataPath, acTable, "SourceTableName", "DestTableName", False
strDataPath needs to be the fullpath to the BE

Arno R

<Da*************@gmail.com> schreef in bericht news:11**********************@i39g2000cwa.googlegr oups.com...
I run a system written in A2003, and it is a standard BE/FE split. I am
distributing a new FE which includes code to update the BE. I can
successfully create new fields in existing tables. I can also create
new tables in the BE, but can anyone help me on how I create the new
links in the FE for the new tables I'm creating in the BE ?

Thanks
Dave

Apr 21 '06 #2
Thanks - works a treat

Apr 21 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2059
by: shadow.demon | last post by:
G'day guys, i've looked around but i can't find how to create an A tag with a onclick to remove a row in a table. Can add rows to table, but i can't get it to create a link in the last coloumn...
4
5993
by: Melissa | last post by:
I have a frontend file named CustomerApp and backend file named CustomerData. CustomerApp is at C:\Customer Database and CustomerData is at S:\Customer Database. Could someone help me with the code...
6
2465
by: skgolden | last post by:
My husband and I own a small temporary labor company and deal with 4 major clients (A,B,C & D), each of which has about 2 dozen units in our tristate area that we deal with (ie, Company A, units...
1
2068
by: David | last post by:
I am hopeing someone can help me with this as I have struggled over the last few days with it. I have a make table query which I want to use to split the table up into seperate tables which are...
1
9397
by: Bruce Lawrence | last post by:
I know this works for Access 97. Not sure about other versions. This will create a DSN to a SQL server in your ODBC connections and then link a table of your choise from that SQL DB to the...
7
1264
by: Apollo0130 | last post by:
hi, how can i create a link in a table in a webform, which links to another page??? please help me, my project must go on... :? Apollo0130 :) Posted Via Usenet.com Premium Usenet...
3
10564
by: Kent | last post by:
I am try to link a SQL 2000 table to Access 2000 using VB.Net 2003 Here is my code: Dim Con As New ADODB.Connection Dim Cat As New ADOX.Catalog Dim tbl As New ADOX.Table ...
4
8103
by: Wayne Wengert | last post by:
I am trying to create a VB.NET Windows application to move some data from a local Access DB table to a table in a SQL Server. The approach I am trying is to open an OLEDB connection to the local...
15
7720
by: Killer42 | last post by:
Hi all. Ok, I'm using VB6 but I think the answer to this (if there is one) is more likely to be found in the Access forum. I have a situation where I've got tens of millions of records, spread...
3
4911
by: Vee007 | last post by:
Following is my code: Dim objCatalog As ADOX.Catalog Dim objTableLink As ADOX.Table Dim objADOConnection As ADODB.Connection Try objADOConnection = New...
0
7125
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7328
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7388
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
7049
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7499
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
5055
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4709
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
1561
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
422
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.