Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Data base issues

BARETH_1981
Level 2
Level 2

i have created the data base but i am unable to get all the buttons to work properly it always show the error in sql query as the image given blow what is the possible reason to not to exicute the queiry in sql

i also wants to create user defined database is it possible?

is it possible to add key board shortcut for form buttons?

error.png

5 Replies
Ratnesh_Ranjan
Level 3
Level 3

In the screenshot I can see that you do not have space between column name mobile and keyword from. Please give a single space and then check the issue.

It becomes easy when you first write command in SQL query analyzer and test it there. IF it executes successfuly you can copy - paste to designer OLEDB connection window.

BARETH_1981
Level 2
Level 2

i have tried the same as instructed by you but it dosent works i have written the sql query as below.

"SELECT FirstName, MiddleName, LastName, Age, Gender, MonthlyIncome, Profession, Address, PhoneNumber, Email, Mobile FROM Survey;" let me know how i can correct the same.

regards

uma shankar

Ratnesh_Ranjan
Level 3
Level 3

Please post your "connection string" to check which connection you are using.

Do you get  "Test connection succeeded" under Data Link Properties window when "Test connection" button is clicked.

Try using select * from Survey and check the result.

oledb.jpg

BARETH_1981
Level 2
Level 2

please find the connection string which was created after the connection succeeded as you shown in the screen shoot the:

"Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DBQ=C:\Users\UMASHANKAR\Desktop\Survey.accdb;DefaultDir=C:\Users\UMASHANKAR\Desktop;Driver={Microsoft Access Driver (*.mdb, *.accdb)};DriverId=25;FIL=MS Access;FILEDSN=C:\Users\UMASHANKAR\Desktop\Survey.accdb.dsn;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes;";Initial Catalog=C:\Users\UMASHANKAR\Desktop\Survey.accdb"

in this project all buttons except the add button is performing well, when i have press the add button to add the next record all the buttons gets hange why?

regards

uma shankar

BARETH_1981
Level 2
Level 2

i want's to give a dynamic path instead to static path in form database is it possible? it is just because when i am running the form on my home pc it works well but as well as i am shifting it to my office pc along with its database it dosen't works well. rather it behave like a static form as per my requirement i need a dynamic form instead of static form.