Support forum

Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_TopicIcon
Create database in ACCESS
sp_NewPost Add Reply sp_NewTopic Add Topic
March 4, 2021
2:53 pm
Henk Helmantel
Admin
Forum Posts: 1488
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

The link does not give any information about the reason for the error. It is possible that the error is caused by copying error in the SQL statements or perhaps because of a different ODBC or OLEDB driver that requires a slightly different SQL syntax, but that is hard to tell without a specific error.

You can find an empty 'SMSServer.mdb' Access database file in the 'Examples\SQLConnector' subfolder in the installation folder of Diafaan SMS Server. You can use that database file if you are not able to create a new database file with the SQL statements.

Regards, Henk

March 4, 2021
12:26 pm
Dimitris
Guest
Guests
March 4, 2021
10:27 am
Henk Helmantel
Admin
Forum Posts: 1488
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Dimitris,

I have tried the SQL statements for the Access database on the most recent version of Microsoft Access and did not get any syntax errors in the SQL statements.

What is the exact syntax error that you get?

Regards, Henk

March 3, 2021
10:00 pm
Dimitris
Guest
Guests

Hi, I downloaded earlier today the app and I began to give it a try but when I follow your instructions to create the database in ACCESS using SQL commands, when I copy and paste the commands in the SQL Query I get the syntax error from ACCESS and it wont create the table.

Can you please help?

Thank you in advance

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
3 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 672

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1141

Posts: 3899

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1488