473,406 Members | 2,371 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

how to create SQL Command using macros for Access Web Database?

hello everyone, I'm a newbie on Access. Somebody entrusts me with a project and I found so many obstacles since I'm not familiar with Access, especially Access Web Database.
My question is how do we create an SQL Command using Macros? I know that VBA is not compatible with Access Web Database, so I need to find a way so I could put some INSERT into command. Is there any other way other that using macros?
Any answer and help would be appreciated. Thank you.
May 12 '15 #1
1 1026
zmbd
5,501 Expert Mod 4TB
Link to the Macro Actions

RunSQL Macro Action
May 12 '15 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: clowtown | last post by:
I am fairly new to database programming in java. I have used odbc to make connections to access dbs but I was wondering how I could connect directly to an access db on my local machine. Do I have...
7
by: kowndinya | last post by:
Hello, i have developed a small program in VB 6.0 and the backend is MS ACCESS. i want to know who is currently logged ms access database. Some body accessing this database by using my program...
2
by: want2learn | last post by:
hi im using this om my web.config file <add key="ConnStr" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:/web/localuser/domain.com/data/base.mdb" /> and if i opload it to a host it...
3
by: koliver | last post by:
Can anyone provide me with information on linking an Access database with GPS mapping software
7
by: shivasusan | last post by:
Hello Friend! I am new for ASP. Database is Microsoft Access. So pls help me..... My problem is --- 1. In login page, two text boxs. first textbox is username & second textbox is...
1
by: jacc14 | last post by:
Hi I am trying to create an MDE from my access database. However I get an error and it suggests that I probably have too many forms/reports as the database engine version 4 can only create a...
0
by: Tom Loder | last post by:
I want to create a dataset at runtime from an access database (or another database) but at designtime I don't know the structure. Ideally what I want to do is: Dim ds as new DataSet =...
1
by: shobhit9243 | last post by:
private void update_Click(object sender, EventArgs e) { OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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
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
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
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...
0
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...

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.